Apache Doris MCP Server - TypeScript implementation using MySQL protocol
Doris MCP server is a locally run integration for AI assistants that speak the Model Context Protocol. Apache Doris MCP Server - TypeScript implementation using MySQL protocol.
Connects to Apache Doris via the MySQL-compatible protocol (port 9030) and exposes the same tool interface as the official apache/doris-mcp-server, with zero Python dependencies.
The server ships on npm as doris-mcp-server, so your MCP client can launch it on demand — there is no separate build step. Add the server block to your client's configuration, restart it, and the tools register themselves.
Once Doris is connected, these are the calls the assistant has available:
exec_query — Execute a SQL query and return results as JSONget_catalog_list — List all catalogsget_db_list — List all databasesget_db_table_list — List all tables in a databaseget_table_schema — Get column definitions for a tableget_table_comment — Get the table-level commentget_table_column_comments — Get comments for all columns in a tableget_table_indexes — Get index information for a tableget_recent_audit_logs — Query recent audit log recordsget_sql_explain — Get the execution plan for a SQL queryget_table_data_size — Get data size information for a table or databaseYou will need 5 environment variables: DORIS_HOST, DORIS_PORT, DORIS_USER, DORIS_PASSWORD, DORIS_DATABASE. Keep credentials in your client's env block or a secrets manager rather than in a file you might commit.
Plenty of database access servers cover similar ground. The differences that matter in practice are scope of access and how much setup stands between you and a working tool call. Doris's toolset — exec_query, get_catalog_list, get_db_list and 8 more — is a fair guide to whether it matches your workflow. It is maintained by iakuf; worth a glance at recent repository activity before you build anything load-bearing on it.
We check each listing at SyncDev against the project's documentation before it goes live — if something here drifts out of date, it is a bug worth reporting.
| Tool | What it does |
|---|---|
| exec_query | Execute a SQL query and return results as JSON |
| get_catalog_list | List all catalogs |
| get_db_list | List all databases |
| get_db_table_list | List all tables in a database |
| get_table_schema | Get column definitions for a table |
| get_table_comment | Get the table-level comment |
| get_table_column_comments | Get comments for all columns in a table |
| get_table_indexes | Get index information for a table |
| get_recent_audit_logs | Query recent audit log records |
| get_sql_explain | Get the execution plan for a SQL query |
| get_table_data_size | Get data size information for a table or database |
{
"mcpServers": {
"doris": {
"command": "doris-mcp-server",
"args": [
"--db-host", "127.0.0.1",
"--db-port", "9030",
"--db-user", "root",
"--db-password", "your_password"
]
}
}
}Configuration as documented by the project. Restart the client after saving.
| Variable | Description | Required |
|---|---|---|
| DORIS_HOST | Endpoint or connection string the server talks to. | Optional |
| DORIS_PORT | Configuration value read at startup. | Optional |
| DORIS_USER | Configuration value read at startup. | Optional |
| DORIS_PASSWORD | Configuration value read at startup. | Optional |
| DORIS_DATABASE | Configuration value read at startup. | Optional |
Read-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.