CnosDB

An MCP server for CnosDB.

python

1

GitHub Stars

python

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cnosdb-cnosdb-mcp-server": {
      "command": "uv",
      "args": [
        "--directory",
        "REPO_PATH/cnosdb-mcp-server",
        "run",
        "server.py"
      ],
      "env": {
        "REPO_PATH": "/Users/me/cnosdb-mcp-server",
        "CNOSDB_HOST": "127.0.0.1",
        "CNOSDB_PORT": "8902",
        "CNOSDB_PASSWORD": "CnosDB#!",
        "CNOSDB_USERNAME": "root"
      }
    }
  }
}

You run an MCP server that exposes essential commands to interact with CnosDB, enabling you to execute queries, inspect databases and tables, and view table schemas from a single, consistent interface.

How to use

Connect your MCP client to the CnosDB MCP server using the local host and port you configured. Your client will expose commands that map to MCP endpoints such as querying data, listing databases, listing tables, and describing table schemas. Use the client’s standard MCP workflow to send requests and receive structured results from the server. Ensure your client is configured to point at CNOSDB_HOST and CNOSDB_PORT and provides authentication if required by your setup.

How to install

Prerequisites you need installed on your machine before you begin.

# Clone the repository
git clone https://github.com/cnosdb/cnosdb-mcp-server.git
cd cnosdb-mcp-server

# Create virtual environment
uv .venv
source .venv/bin/activate  # or `venv\Scripts\activate` on Windows

# Install development dependencies
pip install -r requirements.txt

Run the MCP server locally

Once dependencies are installed, start the MCP server using the runtime command shown below. This runs the server as a local stdio process that your MCP client can connect to.

uv --directory REPO_PATH/cnosdb-mcp-server run server.py

Configuration file for Claude Desktop (local MCP client)

You can configure Claude Desktop to run the MCP server locally with these settings. Adjust REPO_PATH to the path where you cloned the MCP server.

{
  "name": "CnosDB",
  "key": "CnosDBMCPServer",
  "command": "uv",
  "args": [
    "--directory",
    "REPO_PATH/cnosdb-mcp-server",
    "run",
    "server.py"
  ],
  "env": {
    "CNOSDB_HOST": "127.0.0.1",
    "CNOSDB_PORT": "8902",
    "CNOSDB_USERNAME": "root",
    "CNOSDB_PASSWORD": "CnosDB#!"
  }
}

Additional notes

Environment variables shown above configure the local CnosDB connection. You can adapt CNOSDB_HOST, CNOSDB_PORT, CNOSDB_USERNAME, and CNOSDB_PASSWORD to your actual CnosDB setup. When your MCP client connects, you will be able to run the supported actions against CnosDB without embedding MCP-specific logic in your application.

Available tools

query

Execute a query against CnosDB; MCP automatically identifies the SQL dialect and executes the request.

list_databases

Return a list of all databases available in the CnosDB instance.

list_tables

Return a list of tables within a selected database.

describe_table

Display the schema for a specified table, including column names and types.