This is an automated email from the ASF dual-hosted git repository.
freeoneplus pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-mcp-server.git
The following commit(s) were added to refs/heads/master by this push:
new c777905 fix the cofig of doris-mcp-server (#6)
c777905 is described below
commit c777905bd342115676a0598cbf40abe3c4cbcc21
Author: haijun huang <[email protected]>
AuthorDate: Wed Jul 2 18:29:28 2025 +0800
fix the cofig of doris-mcp-server (#6)
---
examples/cursor/README.md | 12 ++--
examples/dify/dify_demo.md | 156 ---------------------------------------------
2 files changed, 6 insertions(+), 162 deletions(-)
diff --git a/examples/cursor/README.md b/examples/cursor/README.md
index ecaebbc..61137e7 100644
--- a/examples/cursor/README.md
+++ b/examples/cursor/README.md
@@ -87,14 +87,14 @@ The necessary dependencies are listed in `requirements.txt`
and will be managed
"run",
"--project",
"/path/to/your/doris-mcp-server",
- "mcp-doris-server"
+ "doris-mcp-server"
],
"env": {
- "DB_HOST": "your_doris_fe_host",
- "DB_PORT": "9030",
- "DB_USER": "your_username",
- "DB_PASSWORD": "your_password",
- "DB_DATABASE": "ssb"
+ "DORIS_HOST": "your_doris_fe_host",
+ "DORIS_PORT": "9030",
+ "DORIS_USER": "your_username",
+ "DORIS_PASSWORD": "your_password",
+ "DORIS_DATABASE": "ssb"
}
}
}
diff --git a/examples/dify/dify_demo.md b/examples/dify/dify_demo.md
deleted file mode 100644
index cbd2ea9..0000000
--- a/examples/dify/dify_demo.md
+++ /dev/null
@@ -1,156 +0,0 @@
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-
-# Dify Example: Integrating Doris MCP Server
-
-This document demonstrates how to integrate and use `doris-mcp-server` in Dify
to perform Doris SQL calls via MCP.
-
-## Table of Contents
-
-- [Prerequisites](#prerequisites)
-- [Starting the MCP Server](#starting-the-mcp-server)
-- [Ngrok Tunnel (Optional)](#ngrok-tunnel-optional)
-- [Installing & Configuring the Plugin in
Dify](#installing--configuring-the-plugin-in-dify)
-- [Creating a Dify App](#creating-a-dify-app)
-- [Adding MCP Tools](#adding-mcp-tools)
-- [Example Calls](#example-calls)
-
-
------
-
-### Prerequisites
-
-First, install `mcp-doris-server`:
-
-```bash
-pip install mcp-doris-server
-```
-
-## Starting the MCP Server
-
-Run the startup script:
-
-```bash
-# Full configuration with database connection
-doris-mcp-server \
- --transport http \
- --host 0.0.0.0 \
- --port 3000 \
- --db-host 127.0.0.1 \
- --db-port 9030 \
- --db-user root \
- --db-password your_password
-```
-
-If successful, you'll see logs similar to this:
-
-
-
------
-
-## Ngrok Tunnel (Optional)
-
-If your Dify deployment requires a publicly accessible endpoint, you can use
the **ngrok** tool. Ngrok is a third-party service that securely exposes local
servers to the internet.
-
-
------
-
-## Installing & Configuring the Plugin in Dify
-
-1. In the Dify console, go to **Plugin Marketplace**, search for, and install
**MCP‑SSE / StreamableHTTP**:
- 
-
-2. After installation, click **Configure** and set the URL to your public or
local address. For example, if you're using `ngrok`, this should be the public
URL `ngrok` provides, in the format `https://<your-domain>/mcp`. If Dify can
directly access your local server, use `http://localhost:3000/mcp`.
-
- ```json
- {
- "doris_mcp_server": {
- "transport": "streamable_http",
- "url": "https://<your-domain>/mcp"
- }
- }
- ```
- 
-
-3. Click **Save**. If configured correctly, you'll see a green **Authorized**
indicator:
-
- 
-
------
-
-## Creating a Dify App
-
-1. In the Dify console, click **New App** → **Blank App**.
-
-
-2. Select **Agent** as the template and set the **App Name** (e.g., `Doris
ChatBI`).
-
-
-
-3. Import from DSL,[dify_doris_dsl.yml](dify_doris_dsl.yml)
-
------
-
-## Instructions & Tool Configuration
-
-### Instruction Block
-
-Paste the following into the **Instruction** field:
-
-```
-<instruction>
-Use MCP tools to complete tasks as much as possible. Carefully read the
annotations, method names, and parameter descriptions of each tool. Please
follow these steps:
-1. Analyze the user's question and match the most appropriate tool.
-2. Use tool names and parameters exactly as defined; do not invent new ones.
-3. Pass parameters in the required JSON format.
-4. When calling tools, use:
- {"mcp_sse_call_tool": {"tool_name": "<tool_name>", "arguments": "{}"}}
-5. Output plain text only—no XML tags.
-<input>
-User question: user_query
-</input>
-<output>
-Return tool results or a final answer, including analysis.
-</output>
-</instruction>
-```
-
-### Adding MCP Tools
-
-In the **Tools** pane, click **Add** twice to add two entries, both named
`mcp_sse` (they will inherit the transport and URL from the plugin):
-
-
------
-
-## Example Calls
-
-### List Tables in Database
-
- * **User**: What tables are in the database?
-
- * **Result**: Dify will call the MCP tool to run `SHOW TABLES` and return
the list.
- 
-
-### Sales Trend Over Ten Years
-
- * **User**: What has been the sales trend over the past ten years in the ssb
database, and which year had the fastest growth?
-
- * **Result**: The tool will execute the SQL, calculate growth rates, and
return data.
- 
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
