# cockroachdb-sql

> Claude/Codex skill by [@cockroachdb](https://omgskills.com/library/cockroachdb/index.md) · 4 stars · Updated 2026-10-09

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.

Tags: claude, cockroach-cloud, cockroachdb, developer-tools

## Install

```sh
git clone https://github.com/cockroachdb/claude-plugin /tmp/claude-plugin && ln -s /tmp/claude-plugin/skills/cockroachdb-query-and-schema-design/cockroachdb-sql ~/.claude/skills/cockroachdb-sql
```

## From README

CockroachDB SQL Skill Converts natural language questions into CockroachDB-compliant SQL queries, following CockroachDB best practices. Use it for schema design, writing queries and optimizing query. How to Apply this Skill Connection Detection — already performed on skill invocation; reuse active connection.

## Links

- HTML page: https://omgskills.com/library/cockroachdb/claude-plugin/skills/cockroachdb-query-and-schema-design/cockroachdb-sql/
- GitHub: https://github.com/cockroachdb/claude-plugin
- Author: [@cockroachdb](https://omgskills.com/library/cockroachdb/index.md)

## More from this repo

- [molt-fetch](https://omgskills.com/library/cockroachdb/claude-plugin/skills/cockroachdb-onboarding-and-migrations/molt-fetch/index.md) — Guide for using molt fetch to migrate data from PostgreSQL, MySQL, Oracle, or MSSQL to CockroachDB.
   - [@cockroachdb](https://omgskills.com/library/cockroachdb/index.md) · 4 stars
- [molt-replicator](https://omgskills.com/library/cockroachdb/claude-plugin/skills/cockroachdb-onboarding-and-migrations/molt-replicator/index.md) — Guide for using the CockroachDB replicator to continuously replicate changes from PostgreSQL, MySQL, or Oracle to...
   - [@cockroachdb](https://omgskills.com/library/cockroachdb/index.md) · 4 stars
- [molt-verify](https://omgskills.com/library/cockroachdb/claude-plugin/skills/cockroachdb-onboarding-and-migrations/molt-verify/index.md) — Guide for using molt verify to compare source and target databases for schema and row-level consistency after a...
   - [@cockroachdb](https://omgskills.com/library/cockroachdb/index.md) · 4 stars