SQL Federated Queries
Query Redpanda topics as SQL tables through Redpanda catalogs in Redpanda SQL on Redpanda Cloud BYOC, including the Iceberg history of Iceberg-enabled topics in the same query. Use when mapping a topic with CREATE TABLE default_redpanda_catalog=>name, choosing schema subject, error handling, struct mapping, or key and header decoding options, reading the redpanda metadata column, querying nested fields, querying live and Iceberg records together through a catalog linked with USING CATALOG, running REFRESH after a schema change, fixing Iceberg queries after a REST catalog secret rotates, or ins
Install
/plugin marketplace add redpanda-data/skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add redpanda-data/skills --skill sql-federated-queriesgit clone --depth 1 https://github.com/redpanda-data/skills.git /tmp/skills
mkdir -p ~/.claude/skills
cp -r /tmp/skills/skills/sql-federated-queries ~/.claude/skills/sql-federated-queriesPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Redpanda SQL: Query Topics Through Catalogs Redpanda SQL reads Redpanda topics in place. Each topic is mapped to a table through a Redpanda catalog, and on a BYOC cluster with an Iceberg REST catalog, the same table also returns the topic's Iceberg history. Connection details come from the **SQL** tab of the cluster's **How to connect** panel; see `/redpanda:sql`. ## How to work This skill has no product-specific procedure of its own. Its evals showed that an agent with the Redpanda docs maps topics, chooses decoding options, queries Iceberg history, and fixes a rotated catalog secret correctly without extra guidance. Look everything up in the docs. ## Use the docs for everything else Look up the managed catalogs that Redpanda Cloud creates, `CREATE TABLE` options and their defaults, the `redpanda` and `redpanda_raw` columns, nested fields, `REFRESH`, Iceberg mode matching and type limits, the catalog-metadata system tables, and the Iceberg Topics cluster and topic properties in the Redpanda docs, following `/redpanda:redpanda-docs`. Pass `platform: "cloud"` to `ask_redpanda_question`: Redpanda SQL runs in Redpanda Cloud. Start from: - Redpanda catalogs: https://docs.redpanda.com/cloud-data-platform/sql/query-data/redpanda-catalogs/ - Query streaming topics: https://docs.redpanda.com/cloud-data-platform/sql/query-data/query-streaming-topics/ - Query Iceberg-enabled topics: https://docs.redpanda.com/cloud-data-platform/sql/query-data/query-iceberg-topics/
Details
- Skill name
sql-federated-queries- Repository
- redpanda-data/skills
- Path
skills/sql-federated-queries/SKILL.md- License
- Apache-2.0
- Repo updated
- 16 November 2026
FAQ
What does the SQL Federated Queries skill do?
Query Redpanda topics as SQL tables through Redpanda catalogs in Redpanda SQL on Redpanda Cloud BYOC, including the Iceberg history of Iceberg-enabled topics in the same query. Use when mapping a topic with CREATE TABLE default_redpanda_catalog=>name, choosing schema subject, error handling, struct mapping, or key and header decoding options, reading the redpanda metadata column, querying nested fields, querying live and Iceberg records together through a catalog linked with USING CATALOG, running REFRESH after a schema change, fixing Iceberg queries after a REST catalog secret rotates, or ins
How do I install the SQL Federated Queries skill?
Claude Code plugin: /plugin marketplace add redpanda-data/skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is SQL Federated Queries popular?
It lives in redpanda-data/skills, which has 9 GitHub stars and 4 forks.
Related skills
Adp
9redpanda-data/skills
Redpanda's Agentic Data Plane: governance infrastructure for building, running, and governing AI agents and MCP servers behind a credential-injecting AI Gateway for LLM providers, operated through the `rpk ai` CLI and the ADP UI at ai.redpanda.com. Use when installing `rpk ai`, signing in to an environment, checking setup with `rpk ai doctor`, managing managed or self-managed AI agents and their triggers with `rpk ai agent` and `rpk ai trigger`, configuring remote or managed MCP servers with `rpk ai mcp-server` (including code mode and user-delegated OAuth), setting up LLM providers and models
Adp Governance
9redpanda-data/skills
Govern what Agentic Data Plane agents may do, spend, and expose, through the `rpk ai` CLI and the ADP UI at ai.redpanda.com, and look up governance features in the Redpanda docs. Use when writing or debugging a Cedar access policy with `rpk ai policy`, giving a new agent access, capping agent spend with `rpk ai budget`, analyzing cost, attaching a guardrail to a provider, containing or releasing an agent with the kill switch, storing or deleting a credential with `rpk ai secret`, minting an API key, masking MCP tool data with data policies, or setting up inbound or outbound OAuth. For signing
Adp Observability
9redpanda-data/skills
Read what Agentic Data Plane agents did and why, through traces, conversation transcripts, the audit log, and the monitoring views in the ADP UI at ai.redpanda.com and the `rpk ai` CLI. Use when finding which call made an agent run slow, failed, or expensive with `rpk ai trace`, reading or filtering a conversation with `rpk ai agent transcript`, finding conversations with a failed tool call, investigating a denied or masked call with `rpk ai auditlog`, working out on whose behalf an agent acted, or reading the Agent network or Home views. For budgets, cost, and access policies, see `/redpanda:
SQL
9thechandanbhagat/claude-skills
Write SQL queries, optimize database performance, design schemas, and debug SQL issues. Use for database operations, query optimization, and schema design.
SQL Debugging
9redpanda-data/skills
Diagnoses Redpanda SQL problems on Redpanda Cloud from the SQL endpoint, and looks up the system tables, error causes, and recovery steps in the Redpanda docs. Use when a Redpanda SQL query is slow, stuck, or canceled for memory, when SHOW NODES reports a degradation error, when a topic-backed table returns decode errors or fewer rows than the topic holds, or when a query over an Iceberg-enabled topic returns stale history or fails to plan. For writing queries, see `/redpanda:sql`. For enabling, scaling, or disabling the SQL engine, see `/redpanda:sql-admin-api`. For catalogs and table mapping
Cheat Status
9miaqu766520-a11y/ai-line-skills
cheat-on-content 的状态看板。显示当前模式 / rubric 版本 / 校准进度 / 待复盘 / pool 状态 / 是否该升级 SQLite / 是否该 bump rubric。**任何时候都可调,无副作用**。触发词:"状态"/"看板"/"status"/"我现在该做什么"/"进度怎么样"。
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.