Apache Doris Mcp Server
Description
Doris MCP (Model Control Panel) Server is a backend service built with Python and FastAPI. It implements the MCP (Model Control Panel) protocol, allowing clients to interact with it through defined "Tools". It's primarily designed to connect to Apache Doris databases, potentially leveraging Large Language Models (LLMs) for tasks like converting natural language queries to SQL (NL2SQL), executing queries, and performing metadata management and analysis
Features
- MCP Protocol Implementation: Provides standard MCP interfaces, supporting tool calls, resource management, and prompt interactions.
- Multiple Communication Modes:
- SSE (Server-Sent Events): Served via /sse (initialization) and /mcp/messages (communication) endpoints (src/sse_server.py).
- Streamable HTTP: Served via the unified /mcp endpoint, supporting request/response and streaming (src/streamable_server.py).
- (Optional) Stdio: Interaction possible via standard input/output (src/stdio_server.py), requires specific startup configuration.
- Tool-Based Interface: Core functionalities are encapsulated as MCP tools that clients can call as needed. Currently available key tools focus on direct database interaction:
- SQL Execution (mcp_doris_exec_query)
- Database and Table Listing (mcp_doris_get_db_list, mcp_doris_get_db_table_list)
- Metadata Retrieval (mcp_doris_get_table_schema, mcp_doris_get_table_comment, mcp_doris_get_table_column_comments, mcp_doris_get_table_indexes)
- Audit Log Retrieval (mcp_doris_get_recent_audit_logs) Note: Current tools primarily focus on direct DB operations.
- Database Interaction: Provides functionality to connect to Apache Doris (or other compatible databases) and execute queries (src/utils/db.py).
- Flexible Configuration: Configured via a .env file, supporting settings for database connections, LLM providers/models, API keys, logging levels, etc.
- Metadata Extraction: Capable of extracting database metadata information (src/utils/schema_extractor.py)
Links & Contact
Recommended Servers
Podbean MCP Server is a management tool that connects any MCP-compatible AI assistant to the Podbean API, allowing users to manage their podcasts, episodes, and analytics through natural conversation.
PayAI MCP Server is a Model Context Protocol server designed for the PayAI network, allowing integration with various platforms like Claude Desktop and Cursor IDE.
Yokai MCP Template is a server template based on the Yokai Go framework, designed to facilitate the development of Model Context Protocol (MCP) servers.
This project is a minimal implementation of a Model Context Protocol (MCP) server designed for deployment on Netlify, providing tools and resources for AI assistants through the Model Context Protocol.
Redshift MCP Server is a Model Context Protocol (MCP) server for Amazon Redshift that enables AI assistants to interact with Redshift databases, providing a set of tools for database management and query execution.
Codehooks.io MCP Server is a Model Context Protocol server that facilitates interaction with Codehooks.io projects through AI agents like Claude.
Zillow MCP Server is a Model Context Protocol server that provides real-time access to Zillow real estate data, built with Python and FastMCP.
Tecton MCP (Model Context Protocol) is a server that provides tools for interacting with Tecton, facilitating feature engineering in machine learning workflows.
Pangea MCP Proxy is a security tool designed to protect any MCP server from malicious entities and confidential Personally Identifiable Information (PII). It secures existing MCP stdio-based servers by integrating with the Pangea AI Guard service, which safeguards inputs and outputs from harmful content.