広告掲載
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.

コメント

「その他」の他のコンテンツ

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

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

広告掲載