From cockroachdb
Use when writing, generating, or optimizing SQL for CockroachDB, designing CockroachDB schemas, or when the user asks about CockroachDB-specific SQL patterns, type mappings, and distributed database best practices. Also use when encountering CockroachDB anti-patterns like missing primary keys, sequential ID hotspots, or incorrect type usage.
npx claudepluginhub cockroachdb/claude-plugin --plugin cockroachdbThis skill uses the workspace's default tool permissions.
Converts natural language questions into CockroachDB-compliant SQL queries, following CockroachDB best practices. Use it for schema design, writing queries and optimizing query.
references/EXAMPLES.mdreferences/cockroachdb-rules/00-fundamental-principles.mdreferences/cockroachdb-rules/01-schema-design.mdreferences/cockroachdb-rules/02-dml-operations.mdreferences/cockroachdb-rules/03-query-patterns.mdreferences/cockroachdb-rules/04-optimization.mdreferences/cockroachdb-rules/05-operational.mdOptimizes complex SQL queries, tunes performance with indexes and EXPLAIN plans, designs data models for cloud-native databases and OLTP/OLAP systems.
Optimizes complex SQL queries, tunes performance with indexes and plans, and designs patterns for cloud-native databases and hybrid OLTP/OLAP systems like PostgreSQL, Snowflake, and BigQuery.
Provides Supabase Postgres best practices for optimizing queries, schemas, connections, RLS security, and configurations across 8 prioritized categories with SQL examples and metrics.
Share bugs, ideas, or general feedback.
Converts natural language questions into CockroachDB-compliant SQL queries, following CockroachDB best practices. Use it for schema design, writing queries and optimizing query.
Activate this skill when:
Connection Detection — already performed on skill invocation; reuse active connection.
Parse Natural Language Intent
Context Gathering
SHOW TABLES; to see existing tablesSHOW CREATE TABLE table_name; for existing structureApply CockroachDB Rules
references/cockroachdb-rules/00-fundamental-principles.md - Always apply these first01-schema-design.md - Table creation and structure02-dml-operations.md - Data modification03-query-patterns.md - Query construction04-optimization.md - Performance, Optimization and anti-patterns05-operational.md - Admin and maintenanceValidate against DB(MANDATORY)
When skill is invoked, ALWAYS:
Immediately detect connection before any other action or response:
cockroach sql --url "<provided-url>" -e "SQL" to run queries. Do not use psql.echo $COCKROACH_URL).
cockroach sql --url $COCKROACH_URL -e "SQL" to run queries. Do not use psql.Focus exclusively on CockroachDB
Emphasize "natural language to CockroachDB SQL" not "database conversion"
Keep user-facing content CockroachDB-specific regardless of internal PostgreSQL rules.
references/cockroachdb-rules/ - CockroachDB SQL rulesreferences/EXAMPLES.md - SQL examples and patterns