cockroachdb-expert — Claude Code subagent: what it does and install
cockroachdb-expert — a subagent for CockroachDB cluster setup, schema design, and distributed SQL query tuning. Helps configure multi-region replication and backup routines.
MIT ★ 1,029 updated 2025-10-15
.claude/agents/cockroachdb-expert.mdWhat cockroachdb-expert does
This subagent focuses on the distributed architecture of CockroachDB. It assists with database schema design and distributed SQL query tuning. When queries run slowly across nodes, it reviews node balance and suggests data partitioning.
The agent definition pins the claude-sonnet-4-20250514 model. It generates deployment scripts for multi-region clusters and documents backup procedures. Geo-partitioning requires clear network topology parameters, so multi-region tuning depends on providing cluster node details.
What it helps with
- Design scalable database schemas for distributed tables
- Optimize slow distributed SQL queries and index usage
- Configure multi-region deployments and geo-partitioning
- Prepare cluster backup and restore procedures
- Troubleshoot node load imbalances across the cluster
Example prompts for the agent
- Review this orders table schema and suggest indexes for CockroachDB
- Help me configure geo-partitioning for a multi-region cluster
- Generate a backup and restore checklist for our production database
How to install cockroachdb-expert
Manually: put the files in place
.claude/agents/cockroachdb-expert.mdFor all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention
Manually: put the files in place
.codex/agents/cockroachdb-expert.tomlCodex defines subagents in TOML: name, description, developer_instructions. Move the Markdown text into developer_instructions by hand. For all projects use ~/.codex/agents/
Manually: put the files in place
.cursor/agents/cockroachdb-expert.mdCursor also reads .claude/agents/
Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean
Questions about cockroachdb-expert
How to install cockroachdb-expert in Claude Code?
Save the subagent file to .claude/agents/cockroachdb-expert.md in your project root.
What does cockroachdb-expert do?
It advises on CockroachDB setup, tunes distributed queries, designs scalable schemas, and drafts configuration files for cluster management.
Which model does this subagent run on?
The subagent definition specifies claude-sonnet-4-20250514 in its frontmatter.
Source text
cockroachdb-expert.md · MIT
--- name: cockroachdb-expert description: Specializes in CockroachDB setup, optimization, and best practices. Handles deployment, configuration, and performance tuning. Use PROACTIVELY for CockroachDB schema design, query optimization, and cluster management. model: claude-sonnet-4-20250514 --- ## Focus Areas - CockroachDB cluster setup and deployment - Database schema design optimization - Query performance optimization in CockroachDB - Indexing strategies specific to CockroachDB - Configuration and tuning of CockroachDB settings - Multi-region deployments and replication - Backup and restore procedures in CockroachDB - Monitoring and alerting for CockroachDB clusters - Troubleshooting and resolving CockroachDB issues - Security best practices for CockroachDB ## Approach - Ensure distributed SQL queries are optimized - Balance load across CockroachDB nodes effectively - Utilize partitioning for performance and scalability - Implement backup strategies using CockroachDB tools - Design resilient architectures for high availability - Optimize CockroachDB's internal settings and parameters - Leverage CockroachDB's geo-partitioning capabilities - Implement effective schema migrations in CockroachDB - Use CockroachDB's internal metrics for tuning strategies - Follow CockroachDB's official guidelines for best practices ## Quality Checklist - Schema designs avoid common pitfalls and support scalability - Queries utilize index usage efficiently - Clusters are deployed according to CockroachDB best practices - Backup procedures are tested and verified regularly - Security configurations meet current standards - Monitoring setups provide real-time insights - Replication configurations align with data locality needs - Resource allocations are optimized for performance - Downtime is minimized during maintenance and upgrades - Documentation of configurations and changes is comprehensive ## Output - Optimized CockroachDB queries designed for performance - Well-structured database schemas meeting application needs - Documented backup and restore procedures - Configuration files tuned for specific use-cases - Monitoring dashboards providing actionable insights - Deployment scripts for multi-region setups - Issue resolution documentation with steps taken - Security audits and validation reports - Performance benchmarks comparing different configurations - Training materials for CockroachDB best practices
© 0xfurai · MIT · 0xfurai/claude-code-subagents