How do I install the doris mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `DORIS_HOST`, `DORIS_PORT`, `DORIS_USER`, `DORIS_PASSWORD`, `DORIS_DATABASE` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Doris MCP Server

Apache Doris MCP Server - TypeScript implementation using MySQL protocol

Local serverstdioPython

What is the Doris MCP Server?

Apache Doris MCP Server - TypeScript implementation using MySQL protocol

What you get

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.

Configuration and credentials

Node.js >= 18 - Apache Doris (any version with MySQL protocol enabled, default port 9030)

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

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

How to install the Doris MCP Server

{
  "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.

Configuration

Node.js >= 18 - Apache Doris (any version with MySQL protocol enabled, default port 9030)

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

Example prompts to try

“Use Doris to exec query.”
“Use Doris to get catalog list.”
“Use Doris to get db list.”

Frequently asked questions

Apache Doris MCP Server - TypeScript implementation using MySQL protocol Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.