cockroachdb-sql
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.
- Version
- 1.0
- Compatibility
- Can work with or without connection to a database. Without connection it generates the SQL and gives instruction for connection.With connection it requires appropriate privilege on target database and tables (SELECT, INSERT, UPDATE, DELETE, or admin).
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/cockroachdb-sql/SKILL.md
- skills/cockroachdb-sql/references/EXAMPLES.md
- skills/cockroachdb-sql/references/cockroachdb-rules/00-fundamental-principles.md
- skills/cockroachdb-sql/references/cockroachdb-rules/01-schema-design.md
- skills/cockroachdb-sql/references/cockroachdb-rules/02-dml-operations.md
- skills/cockroachdb-sql/references/cockroachdb-rules/03-query-patterns.md
- skills/cockroachdb-sql/references/cockroachdb-rules/04-optimization.md
- skills/cockroachdb-sql/references/cockroachdb-rules/05-operational.md
Every link opens the file at its source, pinned to the revision this page describes.