doris-mcp-lite
If you are the rightful owner of doris-mcp-lite and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
Doris-MCP-Lite is a lightweight MCP server designed for connecting to Apache Doris or other MySQL compatible databases, providing tools and prompts for LLM applications.
Doris-MCP-Lite is a streamlined Model Context Protocol (MCP) server that facilitates seamless interaction between large language models (LLMs) and Apache Doris or other MySQL-compatible databases. This server is tailored to enable LLMs and MCP clients to explore database schemas, execute read-only SQL queries, and utilize pre-built analytical prompts through a standardized and secure MCP interface. As an early developer version, Doris-MCP-Lite offers a robust set of features aimed at optimizing database interactions and enhancing analytical capabilities. It supports efficient connection management through pooling, asynchronous query execution for improved responsiveness, and provides built-in prompt templates to assist LLMs in formulating analytics questions. Additionally, it allows for the exposure of database schemas as structured resources, enabling LLMs to access table and field definitions contextually, thereby improving query understanding. The server is designed to be easily installed and configured, with multiple installation options available, including shell script, pip, and manual source code setup.
Features
- Execute read-only SQL queries against Doris databases.
- Perform data analysis operations such as retrieving usage data.
- Query metadata like database schemas and table structures.
- Efficient connection management with pooling.
- Support for asynchronous query execution.
