Doris MCP Server

@NomotoK

Basic information

About Doris MCP Server

A MCP server that supports Apache Doris for safe relational database queries (read-only)

Doris MCP Server config

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

{
  "mcpServers": {
    "doris-mcp-server-nomotok": {
      "command": "uv",
      "args": [
        "venv",
        "#",
        "Create",
        "a",
        "virtual",
        "environment"
      ]
    }
  }
}

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.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Doris Mcp Server?

Doris Mcp Server is a lightweight MCP server that connects LLMs and MCP clients to Apache Doris or MySQL-compatible databases. It exposes read-only SQL tools, database schema resources, and analytical prompt templates, enabling secure, standardized database interactions for AI applications.

How to use Doris Mcp Server?

Install via pip, setup.sh, or clone the source. Configure database connection in a .env file or directly in your MCP client’s configuration JSON. Launch the server with server doris://user:pass@localhost:9030/mydb (or python -m doris_mcp_server.server). Then connect with an MCP client like CherryStudio, Claude Desktop, or Cline to access tools and prompts.

Key features of Doris Mcp Server

Execute read-only SQL queries against Doris databases
Perform data analysis (yearly, monthly, daily)
Query database schemas, table structures, and resource usage
Built-in analytical prompt templates (general + user-defined)
Expose database schema as structured resources
Connection pooling and asynchronous execution

Use cases of Doris Mcp Server

Let an LLM explore a Doris schema to generate accurate queries
Build a chat interface that answers business analytics questions
Automate ad‑hoc data analysis reports via natural language
Enable secure, read‑only database access for AI assistants

Frequently asked questions

What dependencies does Doris Mcp Server require?

It requires Python, PyMySQL, and the MCP Python SDK. Installation via pip or uv handles these automatically.

Where does the server store data?

No data is stored locally. The server connects to your Doris/MySQL database; all data resides in that database.

What transport and authentication does it use?

It uses stdio transport (MCP default). Authentication is via a connection URL (`doris://user:pass@host:port/db`) or environment variables.

Is Doris Mcp Server production‑ready?

It is an early developer version. Some functions may have minor bugs. Use with caution in production.

What SQL operations are allowed?

Only read‑only queries are supported. Write operations (INSERT, UPDATE, DELETE, DDL) are not permitted.

Comments

More Other MCP servers

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

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

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K