Doris MCP Server

What is Doris MCP Server?

Doris MCP Server is a backend service built with Python and FastAPI that implements the Model Context Protocol (MCP). It connects to Apache Doris databases and can leverage Large Language Models (LLMs) for tasks like converting natural language queries to SQL (NL2SQL), executing queries, and performing metadata management and analysis.

How to use Doris MCP Server?

Install via pip install doris-mcp-server. Start the server in Streamable HTTP mode with database connection details (e.g., doris-mcp-server --transport http --db-host 127.0.0.1 --db-port 9030 --db-user root --db-password your_password) or in Stdio mode for direct integration with MCP clients like Cursor (doris-mcp-server --transport stdio). Configuration can also be set via environment variables.

Key features of Doris MCP Server

• MCP protocol implementation with tool calls, resources, and prompts
• Streamable HTTP and Stdio communication modes
• Enterprise authentication with Token, JWT, and OAuth support
• Web-based token management dashboard (localhost only)
• Catalog federation support for multi-catalog environments
• Enhanced SQL security validation and injection protection

Use cases of Doris MCP Server

• Natural language to SQL conversion using LLMs over Doris data
• Secure multi-tenant access to Apache Doris with token-bound database configuration
• Metadata extraction and analysis across internal and external catalogs
• Performance monitoring and query profiling with advanced analytics
• Enterprise data governance with quality analysis, lineage tracking, and compliance

FAQ from Doris MCP Server

What transport modes are supported?

The server supports two modes: Streamable HTTP (unified HTTP endpoint for both request/response and streaming) and Stdio (standard input/output for direct integration with MCP clients).

How is authentication handled?

Authentication can use Token, JWT, or OAuth mechanisms. A web-based token management dashboard (restricted to localhost) allows creation, revocation, and database binding of tokens.

What database does Doris MCP Server require?

It connects to an Apache Doris instance. Connection details (host, port, user, password, database) are required either via command-line arguments or environment variables.

What are the system requirements?

Python 3.12+ and an accessible Apache Doris database. The server is built on FastAPI and uses optional ADBC (Apache Arrow Flight SQL) for high‑performance data retrieval.

Can I use the token management interface remotely?

No. The token management dashboard is intentionally restricted to localhost (127.0.0.1 and ::1) for maximum security.