A
licenseNot graded
qualityD
maintenanceEnables natural language querying of Apache Doris databases via LLM-powered SQL generation, execution, and metadata management through the MCP protocol.
9
Apache 2.0
Apache Doris MCP Server
by fastmcp-me
Provides tools for interacting with Apache Doris, enabling SQL query execution and database management.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Apache Doris MCP Server describe the 'users' table schema"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Apache Doris MCP Server
An MCP server for Apache Doris.
Usage
Cursor
Name: doris
Type: command
Command: DORIS_HOST=<doris-host> DORIS_PORT=<port> DORIS_USER=<doris-user> DORIS_PASSWORD=<doris-pwd> uv run --with mcp-doris --python 3.13 mcp-dorisRelated MCP server: Legion Database MCP Server
Development
Prerequest
install uv
Run MCP Inspector
cd /path/to/mcp-doris
uv sync
source .venv/bin/activate
export PYTHONPATH=/path/to/mcp-doris:$PYTHONPATH
env DORIS_HOST=<doris-host> DORIS_PORT=<port> DORIS_USER=<doris-user> DORIS_PASSWORD=<doris-pwd> mcp dev mcp_doris/mcp_server.pyThen visit http://localhost:5173 in web browser.
Publish
uv build
uv publishAvailable Tools
3 toolsexecute_queryA
Run a SELECT query against Doris with timeout protection.
Args: query: The SQL query to execute
Returns: List[Dict]: The query results
Inputs: query (required).
show_databasesA
List all databases in the Doris instance.
Returns: List[str]: A list of database names
Inputs: no named parameters.
show_tablesA
List all tables in the specified database.
Args: database: The database name like: Optional pattern to filter table names
Returns: List[Dict]: A list of table information dictionaries
Inputs: database (required), like.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
A3.7/5.0
Scored across 3 tools
Disambiguation5/5
Each tool has a distinct purpose: executing SELECT queries, listing databases, and listing tables. No overlap in functionality.
Naming Consistency5/5
All tool names follow a consistent verb_noun pattern in snake_case (execute_query, show_databases, show_tables), making them predictable.
Tool Count3/5
Three tools is on the low side for a database server, but it's acceptable for a minimal read-only interface. The scope feels thin but not extreme.
Completeness2/5
The tool set lacks write operations (INSERT, UPDATE, DELETE), DDL commands (CREATE, DROP, ALTER), and metadata queries (DESCRIBE). Significant gaps for a database server.
Maintenance
ActivityInactive
ResponsivenessNo recent community issues
Related MCP Connectors
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
The BigQuery remote MCP server is a fully managed service that uses the Model Context Protocol to connect AI applications and LLMs to BigQuery data sources. It provides secure, standardized tools for AI agents to list datasets and tables, retrieve schemas, generate and execute SQL queries through natural language, and analyze data—enabling direct access to enterprise analytics data without requiring manual SQL coding.
MCP server for AI dialogue using various LLM models via AceDataCloud
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceA unified MCP server for querying and managing multiple database types (PostgreSQL, MySQL, SQL Server, etc.) via natural language through AI assistants.GPL 3.0
- AlicenseBqualityDmaintenanceMCP server for MaxCompute, enabling table listing, schema inspection, partition lookups, and SELECT queries via natural language.411Apache 2.0
- AlicenseNot gradedqualityDmaintenanceA comprehensive MCP server that enables database operations, schema management, and statistics via natural language through SQL queries and resources.21 npmMIT