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

9 stars 4 forksDatabases Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add redpanda-data/skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add redpanda-data/skills --skill sql-federated-queries
Manual install
git 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-queries

Personal 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/
Read the full skill on GitHub

Details

Skill name
sql-federated-queries
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

9

redpanda-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

AI, LLMs & Agents

Adp Governance

9

redpanda-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

AI, LLMs & Agents

Adp Observability

9

redpanda-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:

DevOps & Cloud

SQL

9

thechandanbhagat/claude-skills

Write SQL queries, optimize database performance, design schemas, and debug SQL issues. Use for database operations, query optimization, and schema design.

Databases

SQL Debugging

9

redpanda-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

Databases

Cheat Status

9

miaqu766520-a11y/ai-line-skills

cheat-on-content 的状态看板。显示当前模式 / rubric 版本 / 校准进度 / 待复盘 / pool 状态 / 是否该升级 SQLite / 是否该 bump rubric。**任何时候都可调,无副作用**。触发词:"状态"/"看板"/"status"/"我现在该做什么"/"进度怎么样"。

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.