SQL Debugging
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
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-debugginggit clone --depth 1 https://github.com/redpanda-data/skills.git /tmp/skills
mkdir -p ~/.claude/skills
cp -r /tmp/skills/skills/sql-debugging ~/.claude/skills/sql-debuggingPersonal 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: Debugging Redpanda SQL is the analytical SQL engine on Redpanda Cloud. Users diagnose it through SQL on the cluster's SQL endpoint and through the Cloud Console; node logs, engine configuration, and engine metrics are collected by Redpanda Support. This skill keeps only the product-specific procedure below. Look up everything else in the docs (last section). ## How to work **When a topic-backed table returns fewer rows than the topic holds, or decode errors, read the table's mapping before guessing.** Query `system.kafka_sources` for the table and check its `error_handling_policy`, schema subject, and Protobuf message name. A table mapped with `DROP_RECORD` skips every record that fails to decode, with no error. To see those records, map the same topic again with `error_handling_policy = 'FILL_NULL'` and select the rows whose `redpanda_raw` is not null; the `redpanda` column gives each one's partition and offset. **Before deleting an Iceberg-enabled topic, keep its Iceberg table if anyone still needs the history.** By default, deleting a topic also deletes its Iceberg table. If the user wants the history kept, set `redpanda.iceberg.delete=false` on the topic first, then delete it. If you can't tell whether the history is still needed, ask before deleting. ## Use the docs for everything else Look up the runtime system tables (`system.nodes`, `system.queries`, `system.execs`), who can
Details
- Skill name
sql-debugging- Repository
- redpanda-data/skills
- Path
skills/sql-debugging/SKILL.md- License
- Apache-2.0
- Repo updated
- 16 November 2026
FAQ
What does the SQL Debugging skill do?
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
How do I install the SQL Debugging 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 Debugging 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 Federated Queries
9redpanda-data/skills
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
SQL Admin API
9redpanda-data/skills
Administers Redpanda SQL on a Redpanda Cloud BYOC cluster: enabling, scaling, and disabling the SQL engine through the Cloud Console, the Cloud API, or the Terraform provider, finding connection details, and managing authentication and access. Use when a user wants to turn Redpanda SQL on or off, change its compute size or availability zone, set it up on a BYOVPC cluster, find the SQL endpoint, connect with an OIDC token or a SCRAM password, assign the SQL Manage or SQL Access roles, or understand how grants gate access to topics. For writing queries and GRANT syntax, see `/redpanda:sql`. For
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.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.