Can AI agents automate CockroachDB?

CockroachDB is automatable today through SQL and the CockroachDB Cloud API. This record is CockroachDB, including self-hosted clusters and CockroachDB Cloud. It is the database, not the separate CockroachDB docs assistant. CockroachDB speaks the PostgreSQL wire protocol. The cockroach sql client runs statements from an interactive shell or from the command line with --execute, --file, or stdin, and Cockroach Labs documents the non-interactive output as a stable interface aside from lines that begin with #. The Cloud API is a separate REST management plane at https://cockroachlabs.cloud/api/v1. The opened guide uses version 2024-09-16, sent with the Cc-Version header. Service accounts authenticate with Authorization Bearer and a secret key. The documented rate limit is 10 requests per second per user. The guide shows cluster list and create calls for Basic, Standard, and Advanced clusters. Only service accounts can call the Cloud API. Cockroach Labs documents two first-party MCP servers. The self-hosted server in cockroachdb/cockroachdb-mcp-server runs over stdio or HTTPS. Read tools are the default, and writes require CRDB_MCP_ENABLE_WRITE_QUERIES. The Cloud MCP is hosted at https://cockroachlabs.cloud/mcp and uses OAuth or a service-account API key. By default it can reach every cluster the caller can access. An optional mcp-cluster-id header pins one cluster. Cloud read tools include list_clusters, get_cluster, list_databases, list_tables, get_table_schema, select_query, explain_query, show_statement, and show_running_queries. Cloud write tools are create_database, create_table, and insert_rows. Cloud tool calls run one statement, time out after 20 seconds, and cap responses at 10 KiB. A docs index is published at https://docs.cockroachlabs.com/llms.txt. iPaaS connector catalogs were not opened. Computer-use viability is unassessed. API scores 8 and is the best path.

Best path today: api · Overall automatability: 8/10