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

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-debugging
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-debugging ~/.claude/skills/sql-debugging

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

Details

Skill name
sql-debugging
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

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 Federated Queries

9

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

Databases

SQL Admin API

9

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

Databases

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

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