Labsco
MCP SERVER

Doris-MCP-Lite

by NomotoK ↗

Point an assistant at Apache Doris or any MySQL-compatible database and let it explore the schema and run read-only SQL, with analytics prompts included.

Relational SQL Databases
Summary
It hands over the schema before asking for a query.

Text-to-SQL fails on table and column names more than on logic, which is why exposing the schema as resources matters more than the query tool itself. Read-only is the other structural choice: point it at a warehouse and the worst outcome is an expensive SELECT. The project is candid about being early and about the official Apache server existing, which is worth weighing — this one is small, easy to install and MySQL-compatible generally, not only Doris.

What it is

A lightweight MCP server for Apache Doris and other MySQL-compatible databases. It exposes the schema as structured resources so a model can see what tables and fields exist before writing anything, runs read-only queries, and ships prompt templates aimed at analytical questions rather than raw SQL.

What you get
  • Read-only SQL executed against your database, with connection pooling and asynchronous execution behind it
  • Metadata queries covering database schemas, table structures and resource usage
  • Data analysis operations over yearly, monthly and daily usage figures
  • The schema exposed as structured resources, so the model has table and field definitions in context rather than guessing at names
  • Built-in prompt templates for analytics questions, including multi-role prompting and both general-purpose and user-defined SQL analysis prompts
Requirements

A Doris or MySQL-compatible database and credentials on it. Connection details go in either as a URL argument in the client config — `doris://user:pass@localhost:9030/mydb` — or in a `.env` file holding `DB_HOST`, `DB_PORT`, `DB_USER`, `DB_PASSWORD` and `DB_NAME`, alongside `MCP_SERVER_NAME` and a debug flag. Install with `pip install doris-mcp-lite`, which provides the `server` command; a setup script walks the configuration for you, and uv-based and editable installs are documented too. Client config examples are given for CherryStudio and for pip and source installs. The project describes itself as an early developer version with some rough edges, and points at the official Apache Doris MCP server as the alternative.

Setup effort

One command plus a key — pip install doris-mcp-lite, then supply credentials