doris-mcp-server
Doris-MCP-Server is a lightweight MCP server that connects to Apache Doris or MySQL compatible databases. It allows LLM applications to explore database schemas and run SQL queries, enhancing their data interaction capabilities. The server is equipped with efficient tools, including query execution and connection management, as well as prebuilt analytics prompts.
📖 Doris-MCP-Server
A lightweight MCP server designed for connecting to Apache Doris or other MySQL compatible database schemas. This server provides tools and prompts for LLM applications to explore database schemas and run read-only SQL queries.
🚀 Features
- Execute read-only SQL queries.
- Perform data analysis operations.
- Query metadata such as database schemas.
- Efficient connection management with pooling.
- Asynchronous query execution.
- Built-in prompt templates for analytics questions.
- User-defined SQL analysis prompts.
📦 Installation Options
Various installation methods including shell script, pip, or cloning the source for manual installation. Detailed steps are provided for each method.
⚙️ Post-Installation Setup
Detailed instructions on configuring the environment and MCP client settings.
🖥️ Usage
Methods for testing the MCP server and database connection.
📚 Project Structure Overview
A breakdown of the directory structure, illustrating how the code is organized.