Advertise
MCP.so
Sign In

Doris MCP Server

@apache

RepositoryHomepage

Basic information

Category

Other

License

Apache-2.0

Transports

stdio

Author

apache

About Doris MCP Server

Apache Doris MCP Server

#doris#warehouse

Doris MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "doris-mcp": {
      "command": "uv",
      "args": [
        "--project",
        "/path/to/your/doris-mcp-server",
        "run",
        "doris-mcp-server"
      ],
      "env": {
        "DB_HOST": "FE_HOST",
        "DB_PORT": "9030",
        "DB_USER": "root",
        "DB_PASSWORD": ""
      }
    },
    "doris-http": {
      "url": "http://127.0.0.1:3000/mcp"
    }
  }
}

Doris MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list directly from this server's endpoint using the button above.

Overview

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

Frequently asked questions

1

What are the system requirements?

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

2

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`).

3

What transport modes are supported?

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

4

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.

5

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`.

Comments

More Other MCP servers

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K
Advertise