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 henry@mcphub.com.
CockroachDB MCP Server allows interaction with CockroachDB databases using the Model Context Protocol (MCP) specification.
The CockroachDB MCP Server is designed to facilitate seamless interaction with CockroachDB databases through the Model Context Protocol (MCP). It provides a robust interface for executing SQL queries, retrieving database structures, and managing connections. The server is equipped with features such as automatic reconnection, connection keep-alive, and detailed logging to ensure stable and efficient database operations. It supports manual disconnection and graceful process exit handling, making it a reliable tool for database management. The server also offers SQL query templates and database status resources to assist users in writing queries and monitoring connection status. Special character handling in usernames and passwords is managed automatically, ensuring secure and correct database connections.
Features
- Connect to CockroachDB database
- Execute SQL queries and retrieve table structures
- Automatic reconnection and connection keep-alive mechanisms
- Detailed logging for troubleshooting
- Manual disconnection and graceful process exit handling
Tools
connect_database
Connect to the CockroachDB database
initialize_connection
Initialize database connection
disconnect_database
Manually disconnect the database
get_tables
Get all tables in the database
get_table_schema
Get the structure information of the specified table
execute_query
Execute SQL query