Apache Doris
Apache Doris MCP Server
What is Apache Doris?
Apache Doris is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to apache doris mcp server
Apache Doris MCP Server
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- Apache Doris MCP Server
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx dorisConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Apache Doris
The Apache Doris MCP Server is a Python-based backend service that implements the Model Context Protocol on top of Apache Doris, a high-performance real-time analytical database. It exposes Doris databases to AI models through a standard MCP interface, enabling natural language to SQL conversion, query execution, metadata inspection, and enterprise-grade data analytics from within any MCP-compatible client. The server supports both stdio mode for local MCP client integration and Streamable HTTP mode for scalable multi-client deployments, making it suitable for data analysts who want to query their Doris lakehouse using conversational AI.
Prerequisites
- Python 3.12 or higher installed on your system
- Apache Doris database instance running and accessible (host, port 9030, credentials)
- pip or pipx for Python package installation
- An MCP-compatible client such as Claude Desktop, Cursor, or Claude Code
- Network access from your machine to the Doris database host
Install the Doris MCP Server package
Install the official doris-mcp-server package from PyPI using pip. This provides both the HTTP and stdio transport modes.
pip install doris-mcp-serverVerify the installation
Confirm the server binary is available and check the available command-line options.
doris-mcp-server --helpSet database environment variables
Export your Apache Doris connection details as environment variables. These can also be passed as command-line flags.
export DORIS_HOST="127.0.0.1"
export DORIS_PORT="9030"
export DORIS_USER="root"
export DORIS_PASSWORD="your_password"Start the server in stdio mode (for MCP clients)
For integration with MCP clients like Cursor or Claude Desktop, run the server in stdio mode. The client will launch this command automatically.
doris-mcp-server --transport stdioConfigure your MCP client
Add the Doris MCP server to your MCP client's configuration file, pointing to the installed binary and supplying your database credentials as environment variables.
{
"mcpServers": {
"doris": {
"command": "doris-mcp-server",
"args": ["--transport", "stdio"],
"env": {
"DORIS_HOST": "127.0.0.1",
"DORIS_PORT": "9030",
"DORIS_USER": "root",
"DORIS_PASSWORD": "your_password"
}
}
}
}Start in HTTP mode for multi-client access (optional)
For team deployments where multiple clients need to connect, start the server in HTTP mode on a configurable port.
doris-mcp-server \
--transport http \
--host 0.0.0.0 \
--port 3000 \
--db-host 127.0.0.1 \
--db-port 9030 \
--db-user root \
--db-password your_passwordApache Doris Examples
Client configuration
Add this block to your claude_desktop_config.json or .mcp.json to connect Claude to your Apache Doris instance.
{
"mcpServers": {
"doris": {
"command": "doris-mcp-server",
"args": ["--transport", "stdio"],
"env": {
"DORIS_HOST": "your-doris-host",
"DORIS_PORT": "9030",
"DORIS_USER": "root",
"DORIS_PASSWORD": "your_password"
}
}
}
}Prompts to try
Use natural language to query and explore your Apache Doris data warehouse through Claude.
- "List all tables in the sales database and describe their schemas"
- "Show me the top 10 products by revenue for last month"
- "Explain the query execution plan for this SQL query"
- "Find any tables with data quality issues or missing values in key columns"
- "Generate a summary of daily active users over the past 30 days"Troubleshooting Apache Doris
Connection refused when the server tries to reach Doris
Verify that your Apache Doris instance is running and that DORIS_HOST and DORIS_PORT (default 9030) are correct. Test with `mysql -h your-host -P 9030 -u root -p` to confirm connectivity.
Python version error during installation
The doris-mcp-server package requires Python 3.12 or higher. Check your version with `python --version` and upgrade if needed. Consider using pyenv or conda to manage Python versions.
MCP client cannot find the doris-mcp-server command
Ensure the package is installed in the Python environment accessible to your MCP client. Use the full path to the binary in the `command` field, e.g., `/usr/local/bin/doris-mcp-server`, or install globally with `pip install --user doris-mcp-server` and ensure `~/.local/bin` is on your PATH.
Frequently Asked Questions about Apache Doris
What is Apache Doris?
Apache Doris is a Model Context Protocol (MCP) server that apache doris mcp server It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Apache Doris?
Follow the installation instructions on the Apache Doris GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Apache Doris?
Apache Doris works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Apache Doris free to use?
Yes, Apache Doris is open source and available under the Apache-2.0 license. You can use it freely in both personal and commercial projects.
Apache Doris Alternatives — Similar Databases Servers
Looking for alternatives to Apache Doris? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Apache Doris in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Apache Doris?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.