mcp-doris-xues87 0.2.0

MCP server for Apache Doris database - connect AI clients to Doris

MCP-Doris

MCP server for Apache Doris database. Lets AI clients (Claude Desktop, Cursor, etc.) query and manage Doris databases through the Model Context Protocol.

Install

git clone <repo-url>
cd mcp-doris
pip install -e .

Usage

Claude Desktop

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "doris": {
      "command": "uv",
      "args": [
        "run",
        "--directory", "/path/to/mcp-doris",
        "python", "-m", "mcp_doris",
        "--host", "192.168.1.100",
        "--port", "9030"
      ],
      "env": {
        "DORIS_USER": "admin",
        "DORIS_PASSWORD": "your_password"
      }
    }
  }
}

You can also configure via environment variables only (no CLI args):

Variable	Default
DORIS_HOST	127.0.0.1
DORIS_PORT	9030
DORIS_USER	root
DORIS_PASSWORD	(empty)
DORIS_CHARSET	utf8mb4
DORIS_DATABASE	(none)
DORIS_TIMEOUT	30

Tools

Tool	Description
list_databases	List all databases
list_tables	List all tables in a database
describe_table	Show CREATE TABLE statement with Doris specifics
execute_query	Execute SELECT queries (default limit: 100 rows)
execute_statement	Execute DDL/DML (INSERT, UPDATE, DELETE, CREATE)

Resources

Resource	Description
schema://{database}/{table}	Table schema info