rahulcrl/cockroachdb-mcp-server
If you are the rightful owner of cockroachdb-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
A Model Context Protocol (MCP) server for interacting with CockroachDB, enabling AI assistants to perform database operations and monitor cluster health.
Tools
Functions exposed to the LLM to take actions
connect_to_cockroachdb
Connect to a CockroachDB instance using a connection string.
get_connection_status
Get the current database connection status and information.
list_databases
List all databases in the CockroachDB cluster.
create_database
Create a new database.
switch_database
Switch to a different database.
list_tables
List all tables in the current database.
create_table
Create a new table with specified columns.
describe_table
Get detailed information about a table including columns, types, and constraints.
list_columns
List all columns for a specific table.
list_indexes
List all indexes for a specific table.
execute_query
Execute a SQL query and return the results.
explain_query
Get the execution plan for a SQL query.
get_query_history
Retrieve recent query execution history.
get_cluster_status
Get detailed status information for all nodes in the cluster.
show_running_queries
Show currently running queries in the cluster.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client