Doris

概要

Doris provides a backend service, built with Python and FastAPI, designed to connect to Apache Doris databases using the MCP protocol. It allows clients to interact with the database via defined tools, leveraging capabilities like converting natural language queries to SQL (NL2SQL), executing queries, and managing database metadata.

主な機能

• Offers tool-based interface for SQL execution, database listing, and metadata retrieval.
• Configurable via .env file for database connections and logging.
• Implements the MCP protocol with SSE and Streamable HTTP communication modes.
• 27 GitHub stars
• Extracts database metadata information.
• Connects to Apache Doris databases and executes queries.

ユースケース

• Integrating with LLMs for NL2SQL tasks.
• Executing SQL queries against a Doris database via an MCP client.
• Retrieving database and table metadata.