Doris MCP Lite

Example Use Cases

• 1

  Explore database schemas and field definitions of an Apache Doris or MySQL-compatible database to generate accurate SQL and contextual answers.

• 2

  Run safe, read-only SQL queries and retrieve analytics (daily/monthly/yearly usage) without embedding complex DB access logic in the agent.

• 3

  Prebuilt prompt templates and multi-role prompting to translate natural language analytics questions into structured SQL and results.

Description

Doris MCP Lite is a lightweight Model Context Protocol (MCP) server that connects to Apache Doris or other MySQL-compatible databases to expose schema resources, read-only SQL execution, and pre-built prompt templates for LLM-driven analytics. It provides connection pooling, asynchronous query execution, and tools to retrieve metadata, table structures, and usage analytics. The server enables LLMs and MCP clients to safely explore databases and generate contextual SQL and analysis; it is an early developer release and not the official Apache Doris MCP server.