--- title: "cockroachdb" description: "Build resilient, globally distributed apps on CockroachDB: connect to CockroachDB Cloud clusters, design schemas and transactions for distributed SQL, go multi-region, and migrate from PostgreSQL with MOLT." canonical: https://agentpluginsdirectory.com/plugins/cockroachdb last-updated: 2026-09-26 --- # cockroachdb Build resilient, globally distributed apps on CockroachDB: connect to CockroachDB Cloud clusters, design schemas and transactions for distributed SQL, go multi-region, and migrate from PostgreSQL with MOLT. - Slug: cockroachdb - Publisher: Cockroach Labs - Repository: https://github.com/harshn08/cockroachdb-kiro-power - Manifest: plugin.json - Version: 0.1.0 - License: Apache-2.0 - Category (editorial): other - Skills: 10 (cockroachdb-cluster-scope, cockroachdb-getting-started, cockroachdb-sql, designing-application-transactions, designing-multi-region-applications, molt-fetch, molt-verify, profiling-statement-fingerprints, reviewing-cluster-health, setting-up-local-cluster) - MCP servers: 1 (cockroachdb-cloud) - Stars: 0 - Repository created: 2026-09-24 - Repository last pushed: 2026-09-25 - Publisher type: User - Listing: https://agentpluginsdirectory.com/plugins/cockroachdb - Schema: https://agent-plugins.org/schemas/1.0.0/plugin.schema.json ## What cockroachdb does, in the publisher's words > Status: WIP / pre-release. Personal staging repo; intended to move to a Cockroach Labs org before public listing. Give your Kiro agent CockroachDB expertise on demand. When you mention CockroachDB (or related terms like crdb, multi-region, molt), Kiro activates this power and loads: - CockroachDB Cloud managed MCP server (https://cockroachlabs.cloud/mcp): list databases/tables, inspect schemas and indexes, run read-only SQL and EXPLAIN, and (with explicit write consent) create databases/tables and insert rows. Sign in with OAuth in the browser, or use a service account API key. - CockroachDB Agent Skills: schema & SQL best practices, transaction/retry design, multi-region patterns, local cluster setup, MOLT migrations, statement profiling, and cluster health reviews. This power uses Kiro's recommended Agent Plugins 1.0.0 format. - git clone this repo and run./scripts/sync-skills.sh. From the project README, punctuation lightly normalized. Full text: https://raw.githubusercontent.com/harshn08/cockroachdb-kiro-power/HEAD/README.md ## Skills - cockroachdb-cluster-scope: Applies to every cockroachdb-cloud MCP session, including onboarding and demos. Rule: if the power's mcp.json sets an mcp-cluster-id header, the connection is locked to that cluster. Check mcp.json BEFORE calling list_clusters or passing cluster_id. Never repeat the Authorization header or any API… - cockroachdb-getting-started: Use when setting up CockroachDB for a project, connecting Kiro to a CockroachDB Cloud cluster, starting a local CockroachDB cluster, or wiring a CockroachDB connection string into an application. Also use when the cockroachdb-cloud MCP server fails to connect or authenticate. - 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, sequ… - designing-application-transactions: Guides 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 operations, connec… - designing-multi-region-applications: Guides 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. Use when designing… - molt-fetch: Guide for using molt fetch to migrate data from PostgreSQL, MySQL, Oracle, or MSSQL to CockroachDB. Use when running molt fetch commands, configuring storage backends, handling fetch failures/resumption, or chaining fetch with verify. - molt-verify: Guide for using molt verify to compare source and target databases for schema and row-level consistency after a migration. Use when running verify commands, tuning concurrency/sharding, handling schema mismatches, or validating data integrity post-migration. - profiling-statement-fingerprints: Ranks and analyzes statement fingerprints using aggregated SQL statistics from crdb_internal.statement_statistics to identify slow, resource-intensive, or error-prone query patterns. Use when investigating historical performance trends, identifying optimization opportunities, or diagnosing recurrin… - reviewing-cluster-health: Performs a comprehensive health check of a CockroachDB cluster. Gathers deployment context first, then provides tier-appropriate diagnostics. Self-Hosted uses SQL against node-level system tables and CLI. Advanced/BYOC use Cloud Console and SQL with node visibility. Standard monitors provisioned co… - setting-up-local-cluster: Downloads and starts a local CockroachDB cluster for development using the official binary. Use when a developer needs a local CockroachDB instance, when no cluster is available, or when setting up a new development environment. Descriptions come from the frontmatter of each SKILL.md, punctuation lightly normalized. ## MCP servers - cockroachdb-cloud: transport: streamable-http; url: https://cockroachlabs.cloud/mcp Read from the plugin's own mcp.json. Environment variable names only, never values.