Awesome MCP › Databases

apache/doris-mcp-server

⭐ 344 Python added to this list on 2025-10-21 repository created 2025-05-06

Apache Doris MCP Server is a backend service designed to implement the Model Context Protocol (MCP) for seamless interaction between clients and Apache Doris databases. Built with Python and FastAPI, this server facilitates advanced database management and query execution, leveraging Large Language Models (LLMs) for natural language to SQL conversion (NL2SQL), metadata management, and data analysis. The project emphasizes enterprise-grade features such as a revolutionary token-bound database configuration system with comprehensive authentication support including Token, JWT, and OAuth, enabling secure multi-tenant access with granular control and robust security defaults. The server offers immediate database validation at connection time, eliminating query-time failures and providing instant feedback on configuration issues. It supports zero-downtime configuration updates through hot reload capabilities, automatic token revalidation, and error handling with rollback mechanisms. The architecture is optimized for performance with session caching, connection pool optimization, and a stateless multi-worker design for true horizontal scalability and efficient load distribution. Security is a core focus, with comprehensive access control, SQL security validation, role-based permissions, and enhanced injection detection. The configuration system is unified and streamlined for cross-platform deployment, Docker compatibility, and command-line precedence. A web-based management interface provides secure localhost-only token administration with real-time operations and enterprise-grade access controls. Additional features include advanced data analytics tools for quality analysis, lineage tracking, and performance monitoring, high-performance Apache Arrow Flight SQL integration, and a robust logging system. The server supports catalog federation, allowing integration with multiple data sources like Hive and MySQL alongside Doris internal tables. Core components include a Tools Manager for centralized tool registration, enhanced monitoring tools, query information tools, resource and prompt managers, and advanced database features such as query execution, security management, metadata extraction, and performance analysis. The system requires Python 3.12+ and connection details for Apache Doris. Installation is straightforward via PyPI, and the server can be started in streamable HTTP mode for optimal performance and reliability.

https://github.com/apache/doris-mcp-server

access-controlaiapache-arrow-flight-sqlapache-dorisbackend-servicecatalog-federationconfiguration-managementconnection-pooldata-analysisdata-analyticsdatabase-validationdockerenterprise-authenticationfastapihot-reloadinjection-detectionjwtlakehousellmloggingmcpmetadata-extractionmetadata-managementmodel-context-protocolmulti-tenant-accessmulti-worker-scalabilitynatural-language-to-sqlnl2sqloautholapperformance-analysispythonquery-enginequery-executionreal-timesecurity-managementsession-cachingsql-securitytokentoken-administrationtoken-bound-database-configurationtools-managerweb-based-management