create_database
ChatGPTCreate a new database in the cluster
Overview
Work on CockroachDB with guidance and live tools maintained by Cockroach Labs. The plugin combines curated workflows for schema design, SQL optimization, transaction retries, migrations, operations, observability, and security with authenticated access to CockroachDB Cloud. Inspect clusters, databases, tables, schemas, query plans, and running queries; run bounded read queries; and perform supported database, table, and row-creation workflows through the hosted MCP server. Actions remain subject to the authenticated user's CockroachDB Cloud permissions.
Tools
create_table
ChatGPTCreate a new table in a database using a CREATE TABLE DDL statement. Only CREATE TABLE statements are allowed. Supports CREATE TABLE AS SELECT for creating tables from query results.
explain_query
ChatGPTShow query execution plan without executing the query
get_cluster
ChatGPTGet detailed information for the CockroachDB cluster
get_table_schema
ChatGPTGet detailed schema information for a table including columns and indexes
insert_rows
ChatGPTInsert rows into an existing table. Only INSERT statements are allowed, including INSERT INTO ... VALUES and INSERT INTO ... SELECT.
list_clusters
ChatGPTList all CockroachDB clusters accessible to the authorized user
list_databases
ChatGPTList all databases in the CockroachDB cluster.
list_tables
ChatGPTList all tables in a database.
select_query
ChatGPTExecute a read-only SELECT query on the CockroachDB cluster. Automatically adds LIMIT 25 if not specified. Maximum LIMIT is 10000. Use LIMIT with OFFSET for pagination (e.g., LIMIT 100 OFFSET 200).
show_running_queries
ChatGPTList currently executing queries on the cluster
show_statement
ChatGPTExecute a SHOW statement for introspection (e.g., SHOW SCHEMAS, SHOW INDEXES, SHOW REGIONS, SHOW CONSTRAINTS). Results are limited to 100 rows by default. Prefer list_databases, list_tables, or get_table_schema for those operations.
Capabilities
Writes
Example Prompts
Click any prompt to copy it.
