Skip to main content
subagent CX Codex

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

Install into Claude Code · Manually: put the files in place All methods and platforms ↓
.claude/agents/cockroachdb-expert.md
Open on GitHub

What 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.md

For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

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

Similar subagents

All subagents for Data and databases →

From the same set137

The whole set →
php-expert php-expert — a subagent for PHP work: PHP 8+ syntax, sessions, Composer and PDO, checked against a PSR and security checklist. CX Codex ★ 1,029repo stars aspnet-core-expert aspnet-core-expert — a subagent for designing, debugging, and optimizing ASP.NET Core web services, middleware, and database access. CX Codex ★ 1,029repo stars sql-expert The sql-expert subagent handles complex SQL, execution plans, indexes, schemas, and transactions. Use it when a query or database design needs a closer review. CX Codex ★ 1,029repo stars docker-expert docker-expert — a Claude subagent for Docker work: Dockerfiles, Compose stacks, volumes, networking, health checks and registries. CX Codex ★ 1,029repo stars react-expert react-expert is a Claude Code subagent for React refactoring, performance work, and complex state changes. It can handle tasks involving hooks, context, and unnecessary renders. CX Codex ★ 1,029repo stars csharp-expert csharp-expert — a C# subagent that checks code against SOLID, moves blocking calls to async/await and hunts bottlenecks. Handy when you refactor or inherit an unfamiliar module. CX Codex ★ 1,029repo stars oauth-oidc-expert oauth-oidc-expert is a Claude Code subagent for OAuth 2.0 and OpenID Connect. It helps review sign-in flows, token handling, and API security. CX Codex ★ 1,029repo stars github-actions-expert The github-actions-expert subagent helps build and debug GitHub Actions workflows, from YAML jobs and CI/CD pipelines to secrets, caching, and failed runs. CX Codex ★ 1,029repo stars

Project sponsors

Companies that keep this analytics open