Doris MCP Server

What is Doris MCP Server?

Doris MCP Server is a Python and FastAPI backend that implements the Model Context Protocol (MCP) to connect Apache Doris databases with LLMs. It enables natural-language-to-SQL (NL2SQL) conversion, query execution, metadata management, and enterprise-grade security features such as token-based authentication and multi-tenant access control.

How to use Doris MCP Server?

Install via pip install doris-mcp-server, then start in HTTP mode with database connection parameters (--db-host, --db-port, --db-user, --db-password) or in stdio mode for direct integration with MCP clients like Cursor. Configure environment variables as an alternative to command-line arguments. A web-based token management dashboard is available for enterprise administration.

Key features of Doris MCP Server

• MCP protocol with HTTP (streamable) and stdio transports
• Enterprise authentication: Token, JWT, OAuth, and role-based access
• Hot‑reload configuration management with zero‑downtime updates
• SQL security validation, injection protection, and data masking
• Session caching and connection pooling (60% overhead reduction)
• Multi-worker horizontal scaling with stateless architecture

Use cases of Doris MCP Server

• Convert natural language questions into SQL queries against Apache Doris
• Execute and explain SQL statements with performance profiling
• Manage metadata across multi-catalog environments (Hive, MySQL, etc.)
• Provide secure, multi-tenant data access with token-bound database configuration
• Monitor and analyze Doris cluster health and query performance

FAQ from Doris MCP Server

What are the system requirements?

Python 3.12+ and an Apache Doris database connection (host, port, user, password, database).

How do I connect to a Doris database?

Provide connection details via command-line arguments (--db-host, --db-port, --db-user, --db-password) or environment variables (DORIS_HOST, DORIS_PORT, DORIS_USER, DORIS_PASSWORD).

What transport modes are supported?

Two modes: http for a web service (default) and stdio for direct integration with MCP clients like Cursor.

Is authentication available?

Yes. v0.6.0 introduces enterprise authentication with Token, JWT, and OAuth support, including a web-based token management dashboard restricted to localhost.

Where is the database configuration stored?

Database credentials can be provided at startup (CLI or environment variables) or bound to tokens for multi-tenant setups. Token configurations are persisted in tokens.json.