SQL Admin API
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
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-admin-apigit clone --depth 1 https://github.com/redpanda-data/skills.git /tmp/skills
mkdir -p ~/.claude/skills
cp -r /tmp/skills/skills/sql-admin-api ~/.claude/skills/sql-admin-apiPersonal 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: administration on Redpanda Cloud Redpanda SQL is the analytical SQL engine that Redpanda manages inside a Redpanda Cloud BYOC cluster, including BYOVPC. Users turn it on, size it, and turn it off through the Cloud Console, the Cloud API, or the Terraform provider. This skill keeps only the procedures below. Look up everything else in the docs (last section). ## How to work **Save the SQL state before you disable Redpanda SQL.** Disabling deletes the engine's catalogs, table mappings, and roles and grants, and re-enabling starts a fresh engine with none of them. Before you send the disable, record what the user needs to rebuild: run `SHOW REDPANDA CATALOGS;`, `SHOW ICEBERG CATALOGS;`, `SHOW REDPANDA TABLES;`, and read the grants from `information_schema.role_external_relation_grants` and `information_schema.role_table_grants`. Then tell the user what was removed and where the record is. **Don't disable Redpanda SQL to reach another goal.** When a change such as moving SQL to another availability zone is refused while SQL is enabled, don't disable and re-enable on your own. Tell the user that this deletes every catalog, table mapping, and grant, and leave the decision to them or to Redpanda Support. **On AWS BYOVPC, detach the Glue policy from the SQL engine role before you disable SQL.** Check the policies attached to `redpanda-<cluster-id>-redpanda-oxla-cluster` and detach any Glue policy
Details
- Skill name
sql-admin-api- Repository
- redpanda-data/skills
- Path
skills/sql-admin-api/SKILL.md- License
- Apache-2.0
- Repo updated
- 16 November 2026
FAQ
What does the SQL Admin API skill do?
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
How do I install the SQL Admin API 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 Admin API 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 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
SQL
9redpanda-data/skills
Writes and runs read-only Redpanda SQL queries on Redpanda Cloud and manages which SQL users can read which topics. Use when a user wants to connect to Redpanda SQL with psql, a PostgreSQL driver, or SQL Studio, query topic-backed tables, create views, export results with COPY TO, grant or revoke access to topics or views, fix a user who lost SQL access, or check how Redpanda SQL differs from PostgreSQL. For enabling SQL, the SQL Manage and SQL Access roles, and the access model, see `/redpanda:sql-admin-api`. For catalogs, mapping topics with CREATE TABLE, and Iceberg-enabled topics, see `/re
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
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.