Doris-MCP Lite Server

Provides read-only data access, prompts, and resources for Apache Doris via MCP.

python

GitHub Stars

python

Language

5 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "nomotok-doris-mcp-lite": {
      "command": "python",
      "args": [
        "-m",
        "doris_mcp_lite.server",
        "doris://user:pass@localhost:9030/mydb"
      ],
      "env": {
        "DEBUG": "false",
        "DB_HOST": "your-doris-host",
        "DB_NAME": "your-database",
        "DB_PORT": "9030",
        "DB_USER": "your-username",
        "DB_PASSWORD": "your-password",
        "MCP_SERVER_NAME": "DorisAnalytics"
      }
    }
  }
}

Doris-MCP-Lite is a lightweight MCP server that lets you securely connect to Apache Doris or other MySQL-compatible databases. It exposes your database schema to LLMs, enables read-only SQL queries, and provides analytical prompts and resources to streamline data exploration and analysis.

How to use

Connect Doris-MCP-Lite to your LLM client using a standard MCP interface. After starting the server, your MCP client can discover available tools, prompts, and resources to explore the database schema, run read-only queries, and perform analytical tasks. Use the client’s run/server flow with the Doris connection string to begin.

How to install

Prerequisites you need before installing Doris-MCP-Lite: Python, a package manager for Python, and a local environment tool for running MCP servers.

# Prerequisites
- Python 3.x
- pip (Python package manager)
- uv (the MCP runner/utility)

Option 1. Install via shell script (recommended for personal/server deployment)

# Copy setup script to your machine
# Then make it executable and run it
chmod +x setup.sh
./setup.sh

Option 2. Install via pip (recommended for production usage)

pip install doris-mcp-lite

Option 3. Clone the source and install manually (for customization)

git clone https://github.com/YOUR_USERNAME/doris-mcp-lite.git
cd doris-mcp-lite

uv venv # Create a virtual environment
uv sync # Install dependencies

# Activate the virtual environment
source .venv/bin/activate  # On Windows: .venv\Scripts\activate

uv pip install

# Start the server with Doris connection
uv run server doris://user:pass@localhost:9030/mydb

Option 4. Install using uv directly (editable local install)

uv pip install 'git+https://github.com/NomotoK/doris-mcp-lite.git'
uv sync
source .venv/bin/activate  # On Windows: .venv\Scripts\activate

uv pip install -e .

uv run server doris://user:pass@localhost:9030/mydb

Additional setup and configuration

Post-install, you can configure a persistent database connection and MCP client to streamline startup and access. You can use an environment file or a client configuration to supply connection details.

Optionally, you can place your connection details in a hidden environment file for convenience.

Available tools

execute_read_only_sql

Execute read-only SQL queries against the Doris database to retrieve results without modifying data.

analyze_usage_data

Perform data analysis operations to retrieve yearly, monthly, and daily usage statistics.

query_metadata

Query metadata such as database schemas, table structures, and resource usage.

connection_pooling

Utilize connection pooling to manage Doris connections efficiently and improve performance.

async_execution

Support asynchronous query execution to improve responsiveness in long-running tasks.

Built by

VeilStrat

AI signals for GTM teams