doris-mcp-server

doris-mcp-server

31
databases

Doris MCP Server is a backend service facilitating interactions with Apache Doris databases via the Model Control Panel protocol. It supports converting natural language queries into SQL, executing queries, and managing metadata through a tool-based interface. Built with Python and FastAPI, it offers multiple communication modes and is highly configurable.

Doris MCP Server

Doris MCP Server is a Python-based backend service employing FastAPI for implementing the Model Control Panel (MCP) protocol. It enables clients to interact with Apache Doris databases through various tools designed for converting natural language to SQL, executing queries, and handling metadata management. Key features include:

  • Implementation of MCP Protocol for tool calls and resource management.
  • Communication modes via SSE, Streamable HTTP, and optional Stdio.
  • Tool-based interfaces for SQL execution, database listing, and metadata retrieval.
  • Flexible configuration using a .env file supporting database and LLM integrations.

Core Features

  • MCP Protocol Implementation: Standard interfaces supporting tool calls and resource management.
  • Multiple Communication Modes: Supports SSE, HTTP streaming, and optionally Stdio.
  • Tool-Based Interface: Tools for SQL execution, database interaction, and metadata retrieval.
  • Database Interaction: Connects to Apache Doris for querying and operations.

System Requirements

  • Python 3.12+
  • Details for database connection (Doris host, port, user, password).

Usage

Requires an MCP Client to connect with the server via SSE or HTTP endpoints and interact according to MCP specifications.