a year ago
research-and-dataA MCP server that supports Apache Doris for safe relational database queries (read-only)
Overview
What is Doris MCP Server?
Doris MCP Server is a lightweight server designed for connecting to Apache Doris or other MySQL compatible database schemas, enabling safe read-only SQL queries and providing tools for LLM applications.
How to use Doris MCP Server?
To use Doris MCP Server, install it via shell script or pip, configure the database connection in the .env file, and connect it to an MCP-compatible client. You can then run read-only SQL queries and utilize built-in analytical prompts.
Key features of Doris MCP Server?
- Execute read-only SQL queries against Doris databases.
- Perform data analysis operations and retrieve usage data.
- Query metadata such as database schemas and resource usage.
- Built-in prompt templates for analytics questions.
Use cases of Doris MCP Server?
- Connecting LLMs to relational databases for data analysis.
- Running read-only queries for reporting and analytics.
- Exploring database schemas and structures through a standardized interface.
FAQ from Doris MCP Server?
- Is Doris MCP Server free to use?
Yes! It is open-source and free to use. - What databases are supported?
It supports Apache Doris and other MySQL compatible databases. - How do I report issues?
You can report issues on the project's GitHub repository.