cockroachdb-mcp-server
3
The CockroachDB MCP Server is a tool designed to interact with CockroachDB databases, providing resources for database schemas and query execution. It facilitates integration with desktop applications like Claude and includes features for query analysis.
CockroachDB MCP Server
This project is an MCP server that interfaces with a CockroachDB instance to provide access to database and table schemas, execute SQL queries, and perform query analysis.
Features
- Access specific database information and table schemas
- Obtain cluster metadata, such as node information
- Execute SQL queries with options for execution plan analysis
Installation
- Clone the repository
- Install dependencies using pnpm
- Build the project with tsc
Configuration
- The server requires a database URL and optionally an auth token to access admin UI endpoints
Usage
It can be integrated with applications like Claude for Desktop by configuring the MCP server settings.
Security Considerations
- Use a read-only user for database access
- Keep the auth token secure when accessing the admin UI API
Troubleshooting
- Verify database credentials and network accessibility
- Check server logs for SQL errors
- Ensure proper configuration and server path to troubleshoot connectivity issues