How to add Apache Doris MCP Server to Claude Desktop

Query, explore, and govern Apache Doris databases via MCP — NL2SQL, metadata, and analytics tools. Paste the config into ~/Library/Application Support/Claude/claude_desktop_config.json and restart Claude Desktop.

Last updated June 14, 2026 · 306★ · stdio · no auth

Claude Desktop config for Apache Doris MCP Server

pip install doris-mcp-server

{
  "mcpServers": {
    "apache-doris-mcp-server": {
      "command": "doris-mcp-server",
      "args": [
        "--transport",
        "stdio"
      ],
      "env": {
        "DORIS_HOST": "127.0.0.1",
        "DORIS_PORT": "9030",
        "DORIS_USER": "root",
        "DORIS_PASSWORD": "your_db_password"
      }
    }
  }
}

Setup steps

1Open Claude Desktop → Settings → Developer → Edit Config (this opens ~/Library/Application Support/Claude/claude_desktop_config.json).
2Paste the Apache Doris MCP Server config below under the top-level "mcpServers" key.
3Fill in any placeholder secrets (API keys, paths) in the snippet.
4Save the file, then fully quit and reopen Claude Desktop.
5Open a chat and confirm Apache Doris MCP Server's tools appear under the 🔌 tools menu.

Before you start

Python 3.12+
An Apache Doris database (host, port, user, password, database)
doris-mcp-server installed (pip install doris-mcp-server)

What Apache Doris MCP Server can do in Claude Desktop

exec_query

Execute a SQL query and return results (supports db_name, catalog_name, max_rows, timeout).

get_table_schema

Get detailed table structure information.

get_db_table_list

Get the list of all table names in a specified database.

get_db_list

Get the list of all database names.

get_table_comment

Get table comment information.

get_table_column_comments

Get comment information for all columns in a table.

get_table_indexes

Get index information for a specified table.

get_recent_audit_logs

Get audit log records for a recent period.

Security

Connects to a live Apache Doris database with full credentials. SQL security validation is enabled by default (ENABLE_SECURITY_CHECK=true) and blocks DDL/DML/DCL and dangerous keywords (DROP, DELETE, TRUNCATE, ALTER, CREATE, INSERT, UPDATE, GRANT, REVOKE, EXEC, etc.), with SQL injection protection and data masking. For multi-tenant/HTTP deployments, enterprise Token/JWT/OAuth auth and token-bound database configuration are available; the web-based token management dashboard is localhost-only and requires TOKEN_MANAGEMENT_ADMIN_TOKEN. Doris-backed OAuth routes tool calls through per-user Doris connection pools so Doris RBAC is the final data authorization boundary.

Apache Doris MCP Server + Claude Desktop FAQ

Where is the Claude Desktop config file?

Claude Desktop reads MCP servers from ~/Library/Application Support/Claude/claude_desktop_config.json. Paste the Apache Doris MCP Server config there under the "mcpServers" key and restart the client.

Is Apache Doris MCP Server safe to use with Claude Desktop?

Which transports are supported?

Stdio (recommended for clients like Cursor and Kiro) and Streamable HTTP. The HTTP service exposes a unified MCP endpoint at http://<host>:<port>/mcp and a health check at /health.

How do I configure the database connection?

Via env vars in the client config (DORIS_HOST, DORIS_PORT, DORIS_USER, DORIS_PASSWORD, DORIS_DATABASE), command-line flags (--db-host, --db-port, --db-user, --db-password), or a .env file.

Is it safe against destructive SQL?

Yes. SQL security validation is on by default and blocks DDL/DML/DCL operations and dangerous keywords, with SQL injection protection and configurable data masking. Blocked keywords are customizable via BLOCKED_KEYWORDS.

View repo Full Apache Doris MCP Server page