Loading…
cockroachdb-sql-patterns
Cursor Rule
CockroachDB SQL best practices, anti-patterns, and distributed database patterns. These rules MUST be followed when writing SQL, schema definitions, or application code that interacts with CockroachDB. Covers 24 verified best practices from production workloads.
CockroachDB plugin for Cursor — explore schemas, write optimized SQL, debug queries, and manage distributed database clusters directly from your AI coding agent.
Rules4
cockroachdb-app-patternsApplication-level best practices and anti-patterns when building applications on CockroachDB. Covers transaction retry logic, ORM configuration, schema design, connection management, online DDL, batching, session guardrails, and multi-region patterns. Based on real-world producti
cockroachdb-developer-patternsAdvanced CockroachDB application development patterns for JPA/Hibernate, Spring, JavaEE, and set-based SQL. Covers JPA identity generators, Spring AOP transaction retry, JavaEE BMT/CMT retry interceptors, CTE-based set operations, Hibernate batch configuration, entity mapping opt
cockroachdb-operator-patternsCockroachDB operations, SRE, and runbook patterns. Covers cluster maintenance procedures, monitoring and alerting, diagnostic queries, troubleshooting contention and hardware issues, emergency procedures, backup/restore, version upgrades, changefeed management, capacity planning,
cockroachdb-sql-patternsCockroachDB SQL best practices, anti-patterns, and distributed database patterns. These rules MUST be followed when writing SQL, schema definitions, or application code that interacts with CockroachDB. Covers 24 verified best practices from production workloads.
Skills32
benchmarking-transaction-patternsGuides benchmarking and comparing explicit multi-statement transactions versus single-statement CTE transactions in CockroachDB, with fair test methodology, contention analysis, and performance interpretation. Use when comparing transaction formulations, benchmarking CockroachDB
designing-application-transactionsGuides application developers in designing correct and performant transaction patterns for CockroachDB, covering transaction lifetime, implicit vs explicit transactions, retry handling with exponential backoff, pushing invariants into SQL, selective pessimistic locking, set-based
designing-multi-region-applicationsGuides developers in selecting and implementing multi-region patterns for CockroachDB applications, covering active-passive vs active-active architectures, REGIONAL BY ROW, GLOBAL tables, manual geo-partitioning with lease preferences, and live demo setup with validation queries.
analyzing-range-distributionAnalyzes CockroachDB range distribution across tables and indexes using SHOW RANGES to identify range count, size patterns, leaseholder placement, and replication health. Use when investigating hotspots, uneven data distribution, range fragmentation, or validating zone configurat
analyzing-schema-change-storage-riskEstimates storage requirements for CockroachDB schema change backfills by analyzing per-index range sizes using SHOW RANGES WITH DETAILS and applying the 3× free space rule. Use when planning CREATE INDEX, ADD COLUMN, or ALTER PRIMARY KEY operations on large tables to avoid disk
Related plugins
Railway
Railway agent skills and hosted MCP server for deploying, configuring, monitoring, and troubleshooting apps and infrastructure on Railway from Cursor. Manage services, environments, deployments, databases, object storage, networking, and observability.
AWS Core
Build, deploy, and operate applications on AWS. Skills to author infrastructure-as-code (CDK, CloudFormation), use core services (Lambda, API Gateway, Step Functions, ECS/Fargate, ECR, IAM, Amazon Bedrock with Knowledge Bases and Guardrails, Amplify), and complete common tasks across observability (CloudWatch, X-Ray, CloudTrail, ADOT), messaging and streaming (SQS, SNS, EventBridge, Kinesis, MSK), AWS SDKs (boto3, JS v3, Swift), and cost optimization.
Netlify
Netlify platform skills — functions, edge functions, blobs, database, identity, image CDN, forms, config, CLI, frameworks, caching, AI gateway, and deployment
Coralogix
Connects Cursor to the Coralogix Observability MCP Server, letting your AI agent query logs, metrics, traces, and RUM, manage alerts and dashboards — all without leaving the editor.
ScyllaDB
Official ScyllaDB agent skills. Bundles guided skills for ScyllaDB Cloud setup, CQL data modeling, and Vector Search; each is invoked independently by the agent when relevant.
ParadeDB
ParadeDB adds Elastic-quality full-text search, vector retrieval, and aggregations to Postgres, with no second system to deploy and nothing to sync. This plugin teaches agents how to use ParadeDB effectively by giving them access to the documentation MCP server.