Connects agents to Apache Doris, an MPP real-time data warehouse, to run SQL queries and manage metadata.
接入配置
选择客户端,复制配置,再按项目文档补齐环境变量。
claude mcp add apache-doris --env DB_HOST='<DB_HOST>' --env DB_PORT='<DB_PORT>' --env DB_USER='<DB_USER>' --env DB_PASSWORD='<DB_PASSWORD>' --env DB_DATABASE='<DB_DATABASE>' -- uv --project /path/to/your/doris-mcp-server run doris-mcp-server~/.codex/config.toml
[mcp_servers.apache-doris]
command = "uv"
args = ["--project", "/path/to/your/doris-mcp-server", "run", "doris-mcp-server"]
env = { DB_HOST = "<DB_HOST>", DB_PORT = "<DB_PORT>", DB_USER = "<DB_USER>", DB_PASSWORD = "<DB_PASSWORD>", DB_DATABASE = "<DB_DATABASE>" }
# codex mcp add apache-doris --env DB_HOST='<DB_HOST>' --env DB_PORT='<DB_PORT>' --env DB_USER='<DB_USER>' --env DB_PASSWORD='<DB_PASSWORD>' --env DB_DATABASE='<DB_DATABASE>' -- uv --project /path/to/your/doris-mcp-server run doris-mcp-server~/.cursor/mcp.json
{
"mcpServers": {
"apache-doris": {
"command": "uv",
"args": [
"--project",
"/path/to/your/doris-mcp-server",
"run",
"doris-mcp-server"
],
"env": {
"DB_HOST": "<DB_HOST>",
"DB_PORT": "<DB_PORT>",
"DB_USER": "<DB_USER>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_DATABASE": "<DB_DATABASE>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"apache-doris": {
"type": "stdio",
"command": "uv",
"args": [
"--project",
"/path/to/your/doris-mcp-server",
"run",
"doris-mcp-server"
],
"env": {
"DB_HOST": "<DB_HOST>",
"DB_PORT": "<DB_PORT>",
"DB_USER": "<DB_USER>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_DATABASE": "<DB_DATABASE>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"apache-doris": {
"command": "uv",
"args": [
"--project",
"/path/to/your/doris-mcp-server",
"run",
"doris-mcp-server"
],
"env": {
"DB_HOST": "<DB_HOST>",
"DB_PORT": "<DB_PORT>",
"DB_USER": "<DB_USER>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_DATABASE": "<DB_DATABASE>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"apache-doris": {
"command": "uv",
"args": [
"--project",
"/path/to/your/doris-mcp-server",
"run",
"doris-mcp-server"
],
"env": {
"DB_HOST": "<DB_HOST>",
"DB_PORT": "<DB_PORT>",
"DB_USER": "<DB_USER>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_DATABASE": "<DB_DATABASE>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"apache-doris": {
"command": "uv",
"args": [
"--project",
"/path/to/your/doris-mcp-server",
"run",
"doris-mcp-server"
],
"env": {
"DB_HOST": "<DB_HOST>",
"DB_PORT": "<DB_PORT>",
"DB_USER": "<DB_USER>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_DATABASE": "<DB_DATABASE>"
}
}
}
}需要的环境变量
DB_HOSTDB_PORTDB_USERDB_PASSWORDDB_DATABASE
把占位值换成你自己的密钥;不要把密钥提交到代码仓库。