dhartunian_cockroachdb-mcp-server

dhartunian_cockroachdb-mcp-server

0
databases

The CockroachDB MCP Server connects to a CockroachDB instance, allowing users to access database schemas and execute SQL queries with tools for query analysis. This server includes features for accessing cluster metadata and is designed for integration with platforms like Claude for Desktop and Cline.

CockroachDB MCP Server

This MCP server interfaces with a CockroachDB instance, allowing access to database and table schemas as resources, executing SQL queries, and providing query analysis prompts.

Features

  • Access specific database information and table schemas.
  • Retrieve cluster metadata, requiring an auth token.
  • Execute SQL queries with execution plan analysis.

Installation

  1. Clone the repository.
  2. Install dependencies.
  3. Build the project using tsc.

Configuration

  • Requires a database URL and optionally an auth token for admin UI endpoints access.

Instructions

  • Detailed setup provided for using with Claude for Desktop and Cline.

Example Queries

  • Various example queries are provided for demonstration.

Security Considerations

  • Secure database access configuration and handle auth tokens carefully.

Troubleshooting

  • Steps for addressing connection issues, SQL errors, and configuration file verification.