CockroachDB
Enable AI agents to manage, monitor, and query CockroachDB using natural language. Perform complex database operations, cluster management, and query execution seamlessly through AI-driven workflows. Integrate effortlessly with MCP clients for scalable and high-performance data operations.
668
29 Tools
Signed
Built by Docker
Requires Secrets
Add to Docker Desktop
Version 4.43 or later needs to be installed to add the server automatically
Tools
| Name | Description |
|---|---|
analyze_performance | Analyze query performance statistics for a given query or time range. |
analyze_schema | Analyze the schema and provide a summary of tables, views, and relationships. |
bulk_import | Bulk import data into a table from a file (CSV or Avro) stored in cloud or web storage. Supports S3, Azure Blob, Google Storage, HTTP/HTTPS URLs. |
connect | Connect to the default CockroachDB database and create a connection pool. Returns: A success message or an error message. |
connect_database | Connect to a CockroachDB database and create a connection pool. |
create_database | Enable the creation of new databases. |
create_index | Create a new index on a specified table to improve query performance. This tool allows users to define indexes on one or more columns, enabling faster data retrieval and optimized execution plans for read-heavy workloads. |
create_table | Enable the creation of new tables in the current database. You can instruct the AI to define table names, columns, and their types, streamlining database setup and schema evolution directly through natural language. |
create_view | Create a view from a specific query. |
describe_table | Provide detailed schema information, column definitions, data types, and other metadata for a specified table. This allows the AI to accurately interpret table structures and formulate precise queries or data manipulation commands. |
drop_database | Drop an existing database. |
drop_index | Drop an existing index. |
drop_table | Facilitate the deletion of existing tables from the database. This tool is useful for cleaning up test environments or managing schema changes, always with the necessary confirmations for security. |
drop_view | Drop an existing view. |
execute_query | Execute a SQL query with optional parameters and formatting. |
execute_transaction | Execute a list of SQL queries as a single transaction. |
explain_query | Return CockroachDB's statement plan for a preparable statement. You can use this information to optimize the query. If you run it with Analyze, it executes the SQL query and generates a statement plan with execution statistics. |
get_active_connections | List active connections/sessions to the current database. Returns: Active sessions on the cluster. |
get_cluster_status | Get cluster health and node distribution. |
get_connection_status | Get the current connection status and details. Returns: The connection status or an error message. |
get_database_settings | Retrieve current database or cluster settings. Returns: All cluster settings. |
get_query_history | Get the history of executed queries. |
get_replication_status | Get replication and distribution status for a table or the whole database. |
get_table_relationships | Get foreign key relationships for a table or all tables. |
list_databases | List all databases in the CockroachDB cluster. Returns: A list of databases with row count or an error message. |
list_tables | List all tables present in the connected Cockroach database instance. This is invaluable for AI to understand the database’s landscape and identify relevant data sources for a given query. |
list_views | List all views in a schema. |
show_running_queries | Show currently running queries on the cluster. |
switch_database | Switch the connection to a different database. |
Manual installation
You can install the MCP server using:
Installation for