Doris
Backend service implementing the Model Control Panel protocol that connects to Apache Doris databases, allowing users to execute SQL queries, manage metadata, and potentially leverage LLMs for tasks like natural language to SQL conversion.
What is Doris?
Doris is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to backend service implementing the model control panel protocol that connects to apache doris databases, allowing users to execute sql queries, manage metadata, and potentially leverage llms for tasks l...
Backend service implementing the Model Control Panel protocol that connects to Apache Doris databases, allowing users to execute SQL queries, manage metadata, and potentially leverage LLMs for tasks like natural language to SQL conversion.
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- Backend service implementing the Model Control Panel protoco
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx doris-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Doris
The Apache Doris MCP Server connects AI models to Apache Doris, a high-performance real-time OLAP database, through the Model Context Protocol. It enables natural language to SQL workflows, direct query execution, schema and metadata browsing, and enterprise data analytics features including query profiling, data quality analysis, and lineage tracking. The server supports both stdio transport for local MCP client integration and Streamable HTTP mode for scalable, multi-worker deployments, making it ideal for data teams who want to query a Doris lakehouse or analytical warehouse using conversational AI.
Prerequisites
- Python 3.12 or higher installed on your system
- Apache Doris database instance running and accessible (host, MySQL port 9030, user credentials)
- pip package manager for Python
- An MCP-compatible client such as Claude Desktop, Cursor, or Claude Code
- Network connectivity between your client machine and the Doris database
Install doris-mcp-server from PyPI
Install the official package. Both the `doris-mcp-server` command will be available after installation.
pip install doris-mcp-serverVerify the installation
Run the help command to confirm the binary is available and review all configuration options.
doris-mcp-server --helpConfigure environment variables
Set your Apache Doris connection details as environment variables. These are used by the server when it starts.
export DORIS_HOST="127.0.0.1"
export DORIS_PORT="9030"
export DORIS_USER="root"
export DORIS_PASSWORD="your_password"Add the server to your MCP client configuration
Edit your MCP client's config file to register the Doris MCP server. Use stdio transport for direct client integration.
{
"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"
}
}
}
}Restart your MCP client
Restart Claude Desktop or your chosen MCP client so it picks up the new server configuration. The Doris tools should appear in the available tool list.
Doris Examples
Client configuration
Add this to your claude_desktop_config.json (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json) to connect to your 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
These prompts demonstrate natural language querying and analytics on Apache Doris through the MCP server.
- "Show all databases and tables in my Doris cluster"
- "Query the orders table to find total revenue grouped by region for Q1"
- "Analyze data quality in the customer table and flag any anomalies"
- "Convert this natural language question to SQL: what were our top-selling products last week?"
- "Show me the query execution profile for the slowest query in the past hour"Troubleshooting Doris
Server fails to start with a database connection error
Check that your Doris instance is running and listening on port 9030. Test the connection with `mysql -h $DORIS_HOST -P 9030 -u $DORIS_USER -p`. Verify firewall rules allow the connection from your machine.
pip install fails because Python version is below 3.12
The server requires Python 3.12+. Use `python --version` to check. Install Python 3.12 via pyenv (`pyenv install 3.12.0`) or download from python.org, then re-run pip install in the correct environment.
SQL security validation blocks a legitimate query
The server has built-in SQL injection protection that may reject queries with certain patterns. Review the blocked keywords in the security configuration, and ensure you are using parameterized queries rather than string interpolation when constructing SQL.
Frequently Asked Questions about Doris
What is Doris?
Doris is a Model Context Protocol (MCP) server that backend service implementing the model control panel protocol that connects to apache doris databases, allowing users to execute sql queries, manage metadata, and potentially leverage llms for tasks like natural language to sql conversion. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Doris?
Follow the installation instructions on the Doris GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Doris?
Doris works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Doris free to use?
Yes, Doris is open source and available under the Apache 2.0 license. You can use it freely in both personal and commercial projects.
Doris Alternatives — Similar Databases Servers
Looking for alternatives to 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 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 Doris?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.