Apache Doris Mcp Server

@Doris

6 months ago

Doris MCP (Model Control Panel) Server is a backend service built with Python and FastAPI. It implements the MCP (Model Control Panel) protocol, allowing clients to interact with it through defined "Tools". It's primarily designed to connect to Apache Doris databases, potentially leveraging Large Language Models (LLMs) for tasks like converting natural language queries to SQL (NL2SQL), executing queries, and performing metadata management and analysis.

Overview Tools Comments

Overview

What is Apache Doris MCP Server?

Apache Doris MCP Server is a backend service built with Python and FastAPI that implements the Model Control Panel (MCP) protocol, allowing clients to interact with it through defined tools. It is primarily designed to connect to Apache Doris databases and can leverage Large Language Models (LLMs) for tasks such as converting natural language queries to SQL (NL2SQL), executing queries, and performing metadata management and analysis.

How to use Apache Doris MCP Server?

To use the Apache Doris MCP Server, clone the repository, install the dependencies, configure the environment variables, and run the service. Clients can connect to the server's SSE or Streamable HTTP endpoints to send requests and invoke the server's tools.

Key features of Apache Doris MCP Server?

Implements the MCP protocol with standard interfaces for tool calls and resource management.
Supports multiple communication modes: SSE, Streamable HTTP, and optional Stdio.
Provides a tool-based interface for database interaction, including SQL execution and metadata retrieval.
Flexible configuration via a .env file for database connections and server settings.
Capable of extracting database metadata information.

Use cases of Apache Doris MCP Server?

Executing SQL queries directly against Apache Doris databases.
Retrieving metadata about databases and tables.
Managing and analyzing database resources through a standardized interface.

FAQ from Apache Doris MCP Server?

Can the MCP Server connect to other databases?
Yes, it is designed to connect primarily to Apache Doris but can be adapted for other compatible databases.
Is there a graphical interface for the MCP Server?
No, the MCP Server is designed for programmatic access through its API endpoints.
How do I configure the server?
Configuration is done through a .env file where you can set database connection details and server parameters.

Try in Playground

Server Config

{
  "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"
    }
  }
}

Build with ShipAny.