cnosdb-mcp-server
Execute SQL queries, manage CnosDB databases, and inspect table schemas through an MCP interface. Streamline database interactions with tools for listing databases and tables.
Author

cnosdb
Quick Info
Actions
Tags
CnosDB MCP Server
An MCP server for CnosDB.
Features
-
query
Execute query (automatically identifies SQL)
-
list_databases
List all databases
-
list_tables
List tables in database
-
describe_table
Display table schema for [table_name]
Development
# 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
Configuration
For alternative MCP clients, see: https://github.com/punkpeye/awesome-mcp-clients
-
Open the Claude Desktop configuration file located at:
-
On macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
-
On Windows: %APPDATA%/Claude/claude_desktop_config.json
-
Add the following:
{
"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#!"
}
}
Update the environment variables to point to your own CnosDB service.
