Language:JapaneseEnglish

cockroachdb Claude Code Plugin

Author
Cockroach Labs
Category
Database
Topics
Databases & Storage · AI Agents & AI App Development · Cloud, Deployment & CI/CD
First cataloged
2026-07-09 (UTC)
Explanation last updated
2026-07-16 (UTC)
Source (GitHub) last updated
2026-07-22 (UTC) (36 days ago)

The explanation below is AI-generated. Please verify it against the sources.

This plugin lets Claude Code connect to CockroachDB clusters to inspect schemas, compose and tune SQL, and administer distributed clusters. It offers 14 tools spread across two active MCP backends — a self-hosted MCP Toolbox and a Cockroach Labs managed Cloud MCP Server — plus three role-based agents (DBA, Developer, Operator) and a set of 32 skills grouped into six operational areas such as query design, observability, security, migrations, and cluster operations. Built-in hooks intercept SQL execution to block destructive statements like DROP DATABASE or TRUNCATE and flag risky patterns in edited files. A companion ccloud command-line tool is also included for provisioning, connecting, scaling, and monitoring clusters through JSON-formatted shell commands. Overall it turns Claude Code into an interactive assistant for day-to-day CockroachDB development and operations.

About the service

CockroachDB is a distributed, PostgreSQL-compatible SQL database designed to run across on-premises, hybrid, and cloud environments while emphasizing resilience, horizontal scalability, and geographic data-placement compliance, according to the CockroachDB homepage. It is offered as a fully managed cloud service as well as through self-hosted or bring-your-own-cloud deployment models.

What you can do with cockroachdb

  • Inspect database schemas, table structures, and table definitions through MCP tools
  • Run and validate SQL, including SELECT queries, EXPLAIN plans, and lists of currently running queries
  • Create databases and tables and insert rows once explicit write access is granted
  • Consult the DBA, Developer, or Operator agent for performance tuning, ORM/transaction guidance, or operational tasks
  • Use skills covering query and schema design, observability, security auditing, MOLT-based migration, and cluster lifecycle management
  • Manage cluster provisioning, backups, disaster recovery, networking, and audit logs via the ccloud CLI
  • Rely on hooks that block dangerous SQL operations and automatically flag anti-patterns in SQL files

Sources

Back to list