广告合作
MCP.so
登录

Doris MCP Server

@apache

代码仓库主页

基本信息

分类

其他

许可证

Apache-2.0

传输方式

stdio

作者

apache

关于 Doris MCP Server

Apache Doris MCP Server

#doris#warehouse

Doris MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "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 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,直接连接服务器端点实时获取工具列表。

概览

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

常见问题

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

评论

其他 分类下的更多 MCP 服务器

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

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

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

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

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

广告合作