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
Flyworks MCP is a free and fast zeroshot lipsync tool that allows users to create lipsynced videos using digital avatars. It provides a convenient interface for interacting with the Flyworks API, enabling the generation of videos that animate avatars to speak in sync with audio or text input.
aiwen geoip MCP Server is a server that provides high-precision real-time IP location services, allowing users to retrieve detailed information about an IP address, including its geographical location and ISP details.
JumpServer MCP Server is a component of the JumpServer project that facilitates secure access and management of cloud resources.
Linear MCP Server is a robust, production-tested Model Context Protocol (MCP) server designed for managing Linear issue tracking and project management. It allows users to create, update, and manage issues, cycles, projects, and other Linear resources seamlessly.
The Morelogin MCP Server is an implementation of the Model Context Protocol (MCP) server designed for Morelogin. It provides tools that interact with the Morelogin API, allowing AI assistants to manage repositories, issues, pull requests, and more.
AGI-MCP-Agent is an open-source intelligent agent framework designed to explore and implement advanced agent capabilities through a Master Control Program (MCP) architecture, inspired by Manus, with ChatGPT-style LLM integration and task control.
The gpt-image-1-mcp is a Model Context Protocol (MCP) server designed for generating and editing images using the OpenAI gpt-image-1 model.
The Trade Agent MCP Server provides a conversational trading interface for agents. It enables natural-language interaction with stock and crypto brokerages—agents can execute trades, query portfolio performance, and surface market insights by sending plain-English requests through the MCP protocol. This server is remote-only—you don't need to run anything locally to connect. Just point your MCP-compatible agent platform to the URL above.
MonkDB MCP Server is a Model Context Protocol (MCP) server that acts as a bridge between large language models (LLMs) and databases like MonkDB, enabling advanced database operations through natural language instructions.