Apache Doris MCP

Name: Apache Doris MCP
Author: Apache

by Apache

MPP-based real-time data warehouse with analytical SQL via MCP

database Python Intermediate Self-hostable

⭐ 200 stars 📅 Updated: 1mo ago

View on GitHub View package

Description

MCP server for Apache Doris, an MPP-based (Massively Parallel Processing) real-time data warehouse. Doris is designed for large-scale analytical workloads with sub-second query latency on petabyte-scale datasets. This server enables AI assistants to run analytical SQL queries, explore data warehouse schemas, and perform data exploration tasks directly on Doris. Built for scenarios where you need interactive analytics on massive datasets — from user behavior analysis and real-time dashboards to ad-hoc business intelligence queries. Apache Foundation project with strong community backing.

✅ Best for

Data engineering teams running large-scale analytical workloads who want AI-assisted query building and data exploration

⏭️ Skip if

You need a simple relational database for small transactional workloads

💡 Use cases

Running analytical queries on petabyte-scale data from AI assistants
Exploring data warehouse schemas and understanding table relationships
Building real-time dashboards and reports through natural language
Ad-hoc business intelligence analysis on large datasets

👍 Pros

✓ Apache Foundation project with active community and enterprise adoption
✓ Sub-second query performance on massive datasets via MPP architecture
✓ MySQL-compatible protocol makes it easy for LLMs to write valid queries
✓ Built for real-time analytics with streaming data ingestion

👎 Cons

✗ Requires an Apache Doris cluster deployment (not a simple local install)
✗ MPP architecture needs proper resource planning for optimal performance
✗ Focused on analytical workloads — not suited for heavy transactional OLTP use

🔧 Exposed tools (4 tools)

Tool	Category	Description
analyze_data	analysis	Run data profiling and statistical analysis on tables
list_databases	discovery	List all available databases in the Doris cluster
describe_table	discovery	Get schema details and column information for a table
execute_query	query	Execute an analytical SQL query on Apache Doris

⚡ Installation

Prerequisites:

• python v3.10+
• Apache Doris database credentials (host, port, user, password)
• API key required

Check Claude Code documentation to configure this MCP server.

💡 Tips & tricks

Doris uses MySQL-compatible protocol, so standard SQL syntax works for most queries. Use list_databases and describe_table first to understand the schema before running complex analytical queries. Large result sets may be truncated — add LIMIT clauses to your queries for faster responses.

🔄 Alternatives

StarRocks MCP

Sub-second analytics on fresh data with high concurrency via MCP

Similar functionality

bigquery-mcp

MCP server — editorial content pending