cockroachdb-mcp-server

cockroachdb-mcp-server

3.1

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

  1. connect_database

    Connect to the CockroachDB database

  2. initialize_connection

    Initialize database connection

  3. disconnect_database

    Manually disconnect the database

  4. get_tables

    Get all tables in the database

  5. get_table_schema

    Get the structure information of the specified table

  6. execute_query

    Execute SQL query