广告合作
MCP.so
登录

Doris MCP Server

@NomotoK

代码仓库

基本信息

分类

其他

许可证

MIT license

传输方式

stdio

作者

NomotoK

关于 Doris MCP Server

A MCP server that supports Apache Doris for safe relational database queries (read-only)

Doris MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "doris-mcp-server-nomotok": {
      "command": "uv",
      "args": [
        "venv",
        "#",
        "Create",
        "a",
        "virtual",
        "environment"
      ]
    }
  }
}

Doris MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Doris Mcp Server?

Doris Mcp Server is a lightweight MCP server that connects LLMs and MCP clients to Apache Doris or MySQL-compatible databases. It exposes read-only SQL tools, database schema resources, and analytical prompt templates, enabling secure, standardized database interactions for AI applications.

How to use Doris Mcp Server?

Install via pip, setup.sh, or clone the source. Configure database connection in a .env file or directly in your MCP client’s configuration JSON. Launch the server with server doris://user:pass@localhost:9030/mydb (or python -m doris_mcp_server.server). Then connect with an MCP client like CherryStudio, Claude Desktop, or Cline to access tools and prompts.

Key features of Doris Mcp Server

  • Execute read-only SQL queries against Doris databases
  • Perform data analysis (yearly, monthly, daily)
  • Query database schemas, table structures, and resource usage
  • Built-in analytical prompt templates (general + user-defined)
  • Expose database schema as structured resources
  • Connection pooling and asynchronous execution

Use cases of Doris Mcp Server

  • Let an LLM explore a Doris schema to generate accurate queries
  • Build a chat interface that answers business analytics questions
  • Automate ad‑hoc data analysis reports via natural language
  • Enable secure, read‑only database access for AI assistants

常见问题

1

What dependencies does Doris Mcp Server require?

It requires Python, PyMySQL, and the MCP Python SDK. Installation via pip or uv handles these automatically.

2

Where does the server store data?

No data is stored locally. The server connects to your Doris/MySQL database; all data resides in that database.

3

What transport and authentication does it use?

It uses stdio transport (MCP default). Authentication is via a connection URL (`doris://user:pass@host:port/db`) or environment variables.

4

Is Doris Mcp Server production‑ready?

It is an early developer version. Some functions may have minor bugs. Use with caution in production.

5

What SQL operations are allowed?

Only read‑only queries are supported. Write operations (INSERT, UPDATE, DELETE, DDL) are not permitted.

评论

其他 分类下的更多 MCP 服务器

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K
广告合作