Skip to content
Back to search

universal-db-mcp

通用数据库 MCP 连接器:支持 MySQL、PostgreSQL、Oracle、MongoDB 等 17 种数据库,支持 Claude Desktop、Cursor、Windsurf、VS Code、ChatGPT 等 50+ 平台,用自然语言查询和分析数据

Safety scan

A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.

Checked today
Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/anarkh-lee--universal-db-mcp/badge.svg)](/listings/anarkh-lee--universal-db-mcp)

HTML

<a href="/listings/anarkh-lee--universal-db-mcp"><img src="/api/listings/anarkh-lee--universal-db-mcp/badge.svg" alt="findsafeskills safety rating" /></a>

Install

i

Install instructions from the README

As written by the repo's author. findsafeskills has not verified these steps.

Installation

npm install -g universal-db-mcp

MCP Mode (Claude Desktop)

Add to your Claude Desktop configuration file:

- **macOS**: `~/Library/Application Support/Claude/claude_desktop_config.json` - **Windows**: `%APPDATA%\Claude\claude_desktop_config.json`

{
  "mcpServers": {
    "my-database": {
      "command": "npx",
      "args": [
        "universal-db-mcp",
        "--type", "mysql",
        "--host", "localhost",
        "--port", "3306",
        "--user", "root",
        "--password", "your_password",
        "--database", "your_database"
      ]
    }
  }
}

Restart Claude Desktop and start asking questions:

- *"Show me the structure of the users table"* - *"Count orders from the last 7 days"* - *"Find the top 5 products by sales"*

HTTP API Mode

# Set environment variables
export MODE=http
export HTTP_PORT=3000
export API_KEYS=your-secret-key

# Start the server
npx universal-db-mcp
# Test the API
curl http://localhost:3000/api/health

MCP SSE Mode (Dify and Remote Access)

When running in HTTP mode, the server also exposes MCP protocol endpoints via SSE (Server-Sent Events) and Streamable HTTP. This allows platforms like Dify to connect using the MCP protocol directly.

**SSE Endpoint (Legacy):**

GET http://localhost:3000/sse?type=mysql&host=localhost&port=3306&user=root&password=xxx&database=mydb

**Streamable HTTP Endpoint (MCP 2025 Spec, Recommended):**

POST http://localhost:3000/mcp
Headers:
  X-DB-Type: mysql
  X-DB-Host: localhost
  X-DB-Port: 3306
  X-DB-User: root
  X-DB-Password: your_password
  X-DB-Database: your_database
Body: MCP JSON-RPC request

| Endpoint | Method | Description | |----------|--------|-------------| | `/sse` | GET | Establish SSE connection (legacy) | | `/sse/message` | POST | Send message to SSE session | | `/mcp` | POST | Streamable HTTP endpoint (recommended) | | `/mcp` | GET | SSE stream for Streamable HTTP | | `/mcp` | DELETE | Close session |

See [Dify Integration Guide](./docs/integrations/DIFY.md) for detailed setup instructions.

What was scanned

The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.

README.md · README · 530 lines

View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)

  1. <p align="center">
  2. <img src="assets/logo.png" alt="Universal DB MCP Logo" width="200">
  3. </p>
  4. <h1 align="center">Universal DB MCP</h1>
  5. <p align="center">
  6. <strong>Connect AI to Your Database with Natural Language</strong>
  7. </p>
  8. <p align="center">
  9. A universal database connector implementing the Model Context Protocol (MCP) and HTTP API, enabling AI assistants to query and analyze your databases using natural language. Works with Claude Desktop, Cursor, Windsurf, VS Code, ChatGPT, and 50+ other platforms.
  10. </p>
  11. <p align="center">
  12. <a href="https://www.npmjs.com/package/universal-db-mcp"><img src="https://img.shields.io/npm/v/universal-db-mcp.svg?style=flat-square&color=blue" alt="npm version"></a>
  13. <a href="https://www.npmjs.com/package/universal-db-mcp"><img src="https://img.shields.io/npm/dm/universal-db-mcp.svg?style=flat-square&color=green" alt="npm downloads"></a>
  14. <a href="https://opensource.org/licenses/MIT"><img src="https://img.shields.io/badge/License-MIT-yellow.svg?style=flat-square" alt="License: MIT"></a>
  15. <a href="https://nodejs.org/"><img src="https://img.shields.io/badge/node-%3E%3D20.0.0-brightgreen?style=flat-square" alt="Node.js Version"></a>
  16. <a href="https://github.com/Anarkh-Lee/universal-db-mcp/stargazers"><img src="https://img.shields.io/github/stars/Anarkh-Lee/universal-db-mcp?style=flat-square" alt="GitHub Stars"></a>
  17. </p>
  18. <p align="center">
  19. <a href="#-features">Features</a> •
  20. <a href="#-quick-start">Quick Start</a> •
  21. <a href="#-supported-databases">Databases</a> •
  22. <a href="#-documentation">Docs</a> •
  23. <a href="#-contributing">Contributing</a>
  24. </p>
  25. <p align="center">
  26. <a href="./README.md">English</a> | <a href="./README.zh-CN.md">中文文档</a>
  27. </p>
  28. ---
  29. ## Why Universal DB MCP?
  30. Imagine asking your AI assistant: *"Show me the top 10 customers by order value this month"* and getting instant results from your database - no SQL writing required. Universal DB MCP makes this possible by bridging AI assistants with your databases through the Model Context Protocol (MCP) and HTTP API.
  31. ```
  32. You: "What's the average order value for users who signed up in the last 30 days?"
  33. AI: Let me query that for you...
  34. ┌─────────────────────────────────────┐
  35. │ Average Order Value: $127.45 │
  36. │ Total New Users: 1,247 │
  37. │ Users with Orders: 892 (71.5%) │
  38. └─────────────────────────────────────┘
  39. ```
  40. ## ✨ Features
  41. - **17 Database Support** - MySQL, PostgreSQL, Redis, Oracle, SQL Server, MongoDB, SQLite, and 10 Chinese domestic databases
  42. - **55+ Platform Integrations** - Works with Claude Desktop, Cursor, VS Code, ChatGPT, Dify, and [50+ other platforms](#-supported-platforms)
  43. - **Flexible Architecture** - 2 startup modes (stdio/http) with 4 access methods: MCP stdio, MCP SSE, MCP Streamable HTTP, and REST API
  44. - **Security First** - Read-only mode by default prevents accidental data modifications
  45. - **Intelligent Caching** - Schema caching with configurable TTL for blazing-fast performance
  46. - **Batch Query Optimization** - Up to 100x faster schema retrieval for large databases
  47. - **Schema Enhancement** - Table comments, implicit relationship inference for better Text2SQL accuracy
  48. - **Multi-Schema Support** - Automatic discovery of all user schemas (PostgreSQL, SQL Server, Oracle, DM, and more)
  49. - **Data Masking** - Automatic sensitive data protection (phone, email, ID card, bank card, etc.)
  50. - **Connection Stability** - Connection pooling, TCP Keep-Alive, and automatic reconnection for long-running sessions
  51. ### Performance Improvements
  52. | Tables | Before | After | Improvement |
  53. |--------|--------|-------|-------------|
  54. | 50 tables | ~5s | ~200ms | **25x faster** |
  55. | 100 tables | ~10s | ~300ms | **33x faster** |
  56. | 500 tables | ~50s | ~500ms | **100x faster** |
  57. ## 🚀 Quick Start
  58. ### Installation
  59. ```bash
  60. npm install -g universal-db-mcp
  61. ```
  62. ### MCP Mode (Claude Desktop)
  63. Add to your Claude Desktop configuration file:
  64. - **macOS**: `~/Library/Application Support/Claude/claude_desktop_config.json`
  65. - **Windows**: `%APPDATA%\Claude\claude_desktop_config.json`
  66. ```json
  67. {
  68. "mcpServers": {
  69. "my-database": {
  70. "command": "npx",
  71. "args": [
  72. "universal-db-mcp",
  73. "--type", "mysql",
  74. "--host", "localhost",
  75. "--port", "3306",
  76. "--user", "root",
  77. "--password", "your_password",
  78. "--database", "your_database"
  79. ]
  80. }
  81. }
  82. }
  83. ```
  84. Restart Claude Desktop and start asking questions:
  85. - *"Show me the structure of the users table"*
  86. - *"Count orders from the last 7 days"*
  87. - *"Find the top 5 products by sales"*
  88. ### HTTP API Mode
  89. ```bash
  90. # Set environment variables
  91. export MODE=http
  92. export HTTP_PORT=3000
  93. export API_KEYS=your-secret-key
  94. # Start the server
  95. npx universal-db-mcp
  96. ```
  97. ```bash
  98. # Test the API
  99. curl http://localhost:3000/api/health
  100. ```
  101. ### MCP SSE Mode (Dify and Remote Access)
  102. When running in HTTP mode, the server also exposes MCP protocol endpoints via SSE (Server-Sent Events) and Streamable HTTP. This allows platforms like Dify to connect using the MCP protocol directly.
  103. **SSE Endpoint (Legacy):**
  104. ```
  105. GET http://localhost:3000/sse?type=mysql&host=localhost&port=3306&user=root&password=xxx&database=mydb
  106. ```
  107. **Streamable HTTP Endpoint (MCP 2025 Spec, Recommended):**
  108. ```
  109. POST http://localhost:3000/mcp
  110. Headers:
  111. X-DB-Type: mysql
  112. X-DB-Host: localhost
  113. X-DB-Port: 3306
  114. X-DB-User: root
  115. X-DB-Password: your_password
  116. X-DB-Database: your_database
  117. Body: MCP JSON-RPC request
  118. ```
  119. | Endpoint | Method | Description |
  120. |----------|--------|-------------|
  121. | `/sse` | GET | Establish SSE connection (legacy) |
  122. | `/sse/message` | POST | Send message to SSE session |
  123. | `/mcp` | POST | Streamable HTTP endpoint (recommended) |
  124. | `/mcp` | GET | SSE stream for Streamable HTTP |
  125. | `/mcp` | DELETE | Close session |
  126. See [Dify Integration Guide](./docs/integrations/DIFY.md) for detailed setup instructions.
  127. ## 📊 Supported Databases
  128. | Database | Type | Default Port | Category |
  129. |----------|------|--------------|----------|
  130. | MySQL | `mysql` | 3306 | Open Source |
  131. | PostgreSQL | `postgres` | 5432 | Open Source |
  132. | Redis | `redis` | 6379 | NoSQL |
  133. | Oracle | `oracle` | 1521 | Commercial |
  134. | SQL Server | `sqlserver` | 1433 | Commercial |
  135. | MongoDB | `mongodb` | 27017 | NoSQL |
  136. | SQLite | `sqlite` | - | Embedded |
  137. | Dameng (达梦) | `dm` | 5236 | Chinese |
  138. | KingbaseES | `kingbase` | 54321 | Chinese |
  139. | GaussDB | `gaussdb` | 5432 | Chinese (Huawei) |
  140. | OceanBase | `oceanbase` | 2881 | Chinese (Ant) |
  141. | TiDB | `tidb` | 4000 | Distributed |
  142. | ClickHouse | `clickhouse` | 8123 | OLAP |
  143. | PolarDB | `polardb` | 3306 | Cloud (Alibaba) |
  144. | Vastbase | `vastbase` | 5432 | Chinese |
  145. | HighGo | `highgo` | 5866 | Chinese |
  146. | GoldenDB | `goldendb` | 3306 | Chinese (ZTE) |
  147. ## 🏗️ Architecture
  148. ```
  149. ┌─────────────────────────────────────────────────────────────────────────┐
  150. │ Universal DB MCP │
  151. ├─────────────────────────────────────────────────────────────────────────┤
  152. │ │
  153. │ Startup Modes: │
  154. │ ┌────────────────────────────┬────────────────────────────────────┐ │
  155. │ │ stdio mode │ http mode │ │
  156. │ │ (npm run start:mcp) │ (npm run start:http) │ │
  157. │ └─────────────┬──────────────┴───────────────┬────────────────────┘ │
  158. │ │ │ │
  159. │ ▼ ▼ │
  160. │ ┌─────────────────────────┐ ┌───────────────────────────────────┐ │
  161. │ │ MCP Protocol │ │ HTTP Server │ │
  162. │ │ (stdio transport) │ │ │ │
  163. │ │ │ │ ┌─────────────────────────────┐ │ │
  164. │ │ Tools: │ │ │ MCP Protocol │ │ │
  165. │ │ • execute_query │ │ │ (SSE / Streamable HTTP) │ │ │
  166. │ │ • get_schema │ │ │ │ │ │
  167. │ │ • get_table_info │ │ │ Tools: (same as stdio) │ │ │
  168. │ │ • clear_cache │ │ │ • execute_query │ │ │
  169. │ │ • get_enum_values │ │ │ • get_schema │ │ │
  170. │ │ • get_sample_data │ │ │ • get_table_info │ │ │
  171. │ │ • connect_database │ │ │ • clear_cache │ │ │
  172. │ │ • disconnect_database │ │ │ • get_enum_values │ │ │
  173. │ │ • get_connection_status│ │ │ • get_sample_data │ │ │
  174. │ │ │ │ │ • connect_database │ │ │
  175. │ │ For: Claude Desktop, │ │ │ • disconnect_database │ │ │
  176. │ │ Cursor, etc. │ │ │ • get_connection_status │ │ │
  177. │ └─────────────┬───────────┘ │ │ │ │ │
  178. │ │ │ │ For: Dify, Remote Access │ │ │
  179. │ │ │ └──────────────┬──────────────┘ │ │
  180. │ │ │ │ │ │
  181. │ │ │ ┌──────────────┴──────────────┐ │ │
  182. │ │ │ │ REST API │ │ │
  183. │ │ │ │ │ │ │
  184. │ │ │ │ Endpoints: │ │ │
  185. │ │ │ │ • /api/connect │ │ │
  186. │ │ │ │ • /api/query │ │ │
  187. │ │ │ │ • /api/schema │ │ │
  188. │ │ │ │ • ... (10+ endpoints) │ │ │
  189. │ │ │ │ │ │ │
  190. │ │ │ │ For: Coze, n8n, Custom │ │ │
  191. │ │ │ └──────────────┬──────────────┘ │ │
  192. │ │ └─────────────────┼─────────────────┘ │
  193. │ │ │ │
  194. │ └──────────────────┬───────────────┘ │
  195. │ ▼ │
  196. │ ┌──────────────────────────────────────────────────────────────────┐ │
  197. │ │ Core Business Logic │ │
  198. │ │ • Query Execution • Schema Caching │ │
  199. │ │ • Safety Validation • Connection Management │ │
  200. │ └──────────────────────────────────┬───────────────────────────────┘ │
  201. │ ▼ │
  202. │ ┌──────────────────────────────────────────────────────────────────┐ │
  203. │ │ Database Adapter Layer │ │
  204. │ │ MySQL │ PostgreSQL │ Redis │ Oracle │ MongoDB │ SQLite │ ... │ │
  205. │ │ (Connection Pool + TCP Keep-Alive + Auto-Retry) │ │
  206. │ └──────────────────────────────────────────────────────────────────┘ │
  207. │ │
  208. └─────────────────────────────────────────────────────────────────────────┘
  209. ```
  210. ## 🔒 Security
  211. By default, Universal DB MCP runs in **read-only mode**, blocking all write operations (INSERT, UPDATE, DELETE, DROP, etc.).
  212. ### Permission Modes
  213. Fine-grained permission control is supported for flexible configuration:
  214. | Mode | Allowed Operations | Description |
  215. |------|-------------------|-------------|
  216. | `safe` (default) | SELECT | Read-only, safest |
  217. | `readwrite` | SELECT, INSERT, UPDATE | Read/write but no delete |
  218. | `full` | All operations | Full control (dangerous!) |
  219. | `custom` | Custom combination | Specify via `--permissions` |
  220. **Permission Types:**
  221. - `read` - SELECT queries (always included)
  222. - `insert` - INSERT, REPLACE
  223. - `update` - UPDATE
  224. - `delete` - DELETE, TRUNCATE
  225. - `ddl` - CREATE, ALTER, DROP, RENAME
  226. **Usage Examples:**
  227. ```bash
  228. # Read-only mode (default)
  229. npx universal-db-mcp --type mysql ...
  230. # Read/write but no delete
  231. npx universal-db-mcp --type mysql --permission-mode readwrite ...
  232. # Custom: only read and insert
  233. npx universal-db-mcp --type mysql --permissions read,insert ...
  234. # Full control (equivalent to --danger-allow-write)
  235. npx universal-db-mcp --type mysql --permission-mode full ...
  236. ```
  237. **Permission Configuration by Transport:**
  238. > ⚠️ Different transports use different parameter naming conventions!
  239. | Transport | Parameter Location | Permission Mode | Custom Permissions |
  240. |-----------|-------------------|-----------------|-------------------|
  241. | STDIO (Claude Desktop) | CLI args | `--permission-mode` | `--permissions` |
  242. | SSE (Dify, etc.) | URL Query | `permissionMode` | `permissions` |
  243. | Streamable HTTP | HTTP Header | `X-DB-Permission-Mode` | `X-DB-Permissions` |
  244. | REST API | JSON Body | `permissionMode` | `permissions` |
  245. **Best Practices:**
  246. - Never enable write mode in production
  247. - Use dedicated read-only database accounts
  248. - Connect through VPN or bastion hosts
  249. - Regularly audit query logs
  250. ## 🔌 Supported Platforms
  251. Universal DB MCP works with any platform that supports the MCP protocol or REST API. Here's a comprehensive list:
  252. ### AI-Powered Code Editors & IDEs
  253. | Platform | Access Method | Description | Guide |
  254. |----------|---------------|-------------|-------|
  255. | [Cursor](https://cursor.sh/) | MCP stdio | AI-powered code editor with built-in MCP support | [EN](./docs/integrations/CURSOR.md) / [中文](./docs/integrations/CURSOR.zh-CN.md) |
  256. | [Windsurf](https://codeium.com/windsurf) | MCP stdio | Codeium's AI IDE with Cascade agent | [EN](./docs/integrations/WINDSURF.md) / [中文](./docs/integrations/WINDSURF.zh-CN.md) |
  257. | [VS Code](https://code.visualstudio.com/) | MCP stdio / REST API | Via GitHub Copilot agent mode or Cline/Continue extensions | [EN](./docs/integrations/VSCODE.md) / [中文](./docs/integrations/VSCODE.zh-CN.md) |
  258. | [Zed](https://zed.dev/) | MCP stdio | High-performance open-source code editor | [EN](./docs/integrations/ZED.md) / [中文](./docs/integrations/ZED.zh-CN.md) |
  259. | [IntelliJ IDEA](https://www.jetbrains.com/idea/) | MCP stdio | JetBrains IDE with MCP support (2025.1+) | [EN](./docs/integrations/JETBRAINS.md) / [中文](./docs/integrations/JETBRAINS.zh-CN.md) |
  260. | [PyCharm](https://www.jetbrains.com/pycharm/) | MCP stdio | JetBrains Python IDE | [EN](./docs/integrations/JETBRAINS.md) / [中文](./docs/integrations/JETBRAINS.zh-CN.md) |
  261. | [WebStorm](https://www.jetbrains.com/webstorm/) | MCP stdio | JetBrains JavaScript IDE | [EN](./docs/integrations/JETBRAINS.md) / [中文](./docs/integrations/JETBRAINS.zh-CN.md) |
  262. | [Android Studio](https://developer.android.com/studio) | MCP stdio | Via JetBrains MCP plugin | [EN](./docs/integrations/JETBRAINS.md) / [中文](./docs/integrations/JETBRAINS.zh-CN.md) |
  263. | [Neovim](https://neovim.io/) | MCP stdio | Via MCPHub.nvim plugin | [EN](./docs/integrations/NEOVIM.md) / [中文](./docs/integrations/NEOVIM.zh-CN.md) |
  264. | [Emacs](https://www.gnu.org/software/emacs/) | MCP stdio | Via mcp.el package | [EN](./docs/integrations/EMACS.md) / [中文](./docs/integrations/EMACS.zh-CN.md) |
  265. ### AI Coding Assistants
  266. | Platform | Access Method | Description | Guide |
  267. |----------|---------------|-------------|-------|
  268. | [Claude Code](https://claude.ai/code) | MCP stdio | Anthropic's agentic coding tool | [EN](./docs/integrations/CLAUDE-CODE.md) / [中文](./docs/integrations/CLAUDE-CODE.zh-CN.md) |
  269. | [GitHub Copilot](https://github.com/features/copilot) | MCP stdio | Agent mode in VS Code/JetBrains | [EN](./docs/integrations/GITHUB-COPILOT.md) / [中文](./docs/integrations/GITHUB-COPILOT.zh-CN.md) |
  270. | [Cline](https://github.com/cline/cline) | MCP stdio / REST API | Autonomous coding agent for VS Code | [EN](./docs/integrations/CLINE.md) / [中文](./docs/integrations/CLINE.zh-CN.md) |
  271. | [Continue](https://continue.dev/) | MCP stdio | Open-source AI code assistant | [EN](./docs/integrations/CONTINUE.md) / [中文](./docs/integrations/CONTINUE.zh-CN.md) |
  272. | [Roo Code](https://github.com/roovet/roo-code) | MCP stdio | Fork of Cline for VS Code | [EN](./docs/integrations/ROO-CODE.md) / [中文](./docs/integrations/ROO-CODE.zh-CN.md) |
  273. | [Sourcegraph Cody](https://sourcegraph.com/cody) | MCP stdio | AI coding assistant | [EN](./docs/integrations/SOURCEGRAPH-CODY.md) / [中文](./docs/integrations/SOURCEGRAPH-CODY.zh-CN.md) |
  274. | [Amazon Q Developer](https://aws.amazon.com/q/developer/) | MCP stdio | AWS AI coding assistant | [EN](./docs/integrations/AMAZON-Q-DEVELOPER.md) / [中文](./docs/integrations/AMAZON-Q-DEVELOPER.zh-CN.md) |
  275. | [Devin](https://devin.ai/) | MCP stdio | AI software engineer | [EN](./docs/integrations/DEVIN.md) / [中文](./docs/integrations/DEVIN.zh-CN.md) |
  276. | [Goose](https://github.com/block/goose) | MCP stdio | Block's AI coding agent | [EN](./docs/integrations/GOOSE.md) / [中文](./docs/integrations/GOOSE.zh-CN.md) |
  277. | [Gemini CLI](https://github.com/google-gemini/gemini-cli) | MCP stdio | Google's command-line AI tool | [EN](./docs/integrations/GEMINI-CLI.md) / [中文](./docs/integrations/GEMINI-CLI.zh-CN.md) |
  278. ### Desktop AI Chat Applications
  279. | Platform | Access Method | Description | Guide |
  280. |----------|---------------|-------------|-------|
  281. | [Claude Desktop](https://claude.ai/download) | MCP stdio | Anthropic's official desktop app | [EN](./docs/integrations/CLAUDE-DESKTOP.md) / [中文](./docs/integrations/CLAUDE-DESKTOP.zh-CN.md) |
  282. | [ChatGPT Desktop](https://openai.com/chatgpt/desktop/) | MCP SSE/Streamable HTTP | OpenAI's desktop app with MCP connectors | [EN](./docs/integrations/CHATGPT.md) / [中文](./docs/integrations/CHATGPT.zh-CN.md) |
  283. | [Cherry Studio](https://github.com/kangfenmao/cherry-studio) | MCP stdio | Multi-model desktop chat app | [EN](./docs/integrations/CHERRY-STUDIO.md) / [中文](./docs/integrations/CHERRY-STUDIO.zh-CN.md) |
  284. | [LM Studio](https://lmstudio.ai/) | MCP stdio | Run local LLMs with MCP support | [EN](./docs/integrations/LM-STUDIO.md) / [中文](./docs/integrations/LM-STUDIO.zh-CN.md) |
  285. | [Jan](https://jan.ai/) | MCP stdio | Open-source ChatGPT alternative | [EN](./docs/integrations/JAN.md) / [中文](./docs/integrations/JAN.zh-CN.md) |
  286. | [Msty](https://msty.app/) | MCP stdio | Desktop AI chat application | [EN](./docs/integrations/MSTY.md) / [中文](./docs/integrations/MSTY.zh-CN.md) |
  287. | [LibreChat](https://github.com/danny-avila/LibreChat) | MCP stdio | Open-source chat interface | [EN](./docs/integrations/LIBRECHAT.md) / [中文](./docs/integrations/LIBRECHAT.zh-CN.md) |
  288. | [Witsy](https://witsy.app/) | MCP stdio | Desktop AI assistant | [EN](./docs/integrations/WITSY.md) / [中文](./docs/integrations/WITSY.zh-CN.md) |
  289. | [5ire](https://github.com/5ire-tech/5ire) | MCP stdio | Cross-platform AI chat | [EN](./docs/integrations/5IRE.md) / [中文](./docs/integrations/5IRE.zh-CN.md) |
  290. | [ChatMCP](https://github.com/daodao97/chatmcp) | MCP stdio | MCP-focused chat UI | [EN](./docs/integrations/CHATMCP.md) / [中文](./docs/integrations/CHATMCP.zh-CN.md) |
  291. | [HyperChat](https://github.com/BigSweetPotatoStudio/HyperChat) | MCP stdio | Multi-platform chat app | [EN](./docs/integrations/HYPERCHAT.md) / [中文](./docs/integrations/HYPERCHAT.zh-CN.md) |
  292. | [Tome](https://github.com/runebook/tome) | MCP stdio | macOS app for local LLMs | [EN](./docs/integrations/TOME.md) / [中文](./docs/integrations/TOME.zh-CN.md) |
  293. ### Web-Based AI Platforms
  294. | Platform | Access Method | Description | Guide |
  295. |----------|---------------|-------------|-------|
  296. | [Claude.ai](https://claude.ai/) | MCP SSE/Streamable HTTP | Anthropic's web interface | [EN](./docs/integrations/CLAUDE-AI.md) / [中文](./docs/integrations/CLAUDE-AI.zh-CN.md) |
  297. | [ChatGPT](https://chat.openai.com/) | MCP SSE/Streamable HTTP | Via custom connectors | [EN](./docs/integrations/CHATGPT.md) / [中文](./docs/integrations/CHATGPT.zh-CN.md) |
  298. | [Dify](https://dify.ai/) | MCP SSE/Streamable HTTP | LLM app development platform | [EN](./docs/integrations/DIFY.md) / [中文](./docs/integrations/DIFY.zh-CN.md) |
  299. | [Coze](https://www.coze.com/) | REST API | ByteDance's AI bot platform | [EN](./docs/integrations/COZE.md) / [中文](./docs/integrations/COZE.zh-CN.md) |
  300. | [n8n](https://n8n.io/) | REST API / MCP | Workflow automation platform | [EN](./docs/integrations/N8N.md) / [中文](./docs/integrations/N8N.zh-CN.md) |
  301. | [Replit](https://replit.com/) | MCP stdio | Online IDE with AI agent | [EN](./docs/integrations/REPLIT.md) / [中文](./docs/integrations/REPLIT.zh-CN.md) |
  302. | [MindPal](https://mindpal.io/) | MCP SSE/Streamable HTTP | No-code AI agent builder | [EN](./docs/integrations/MINDPAL.md) / [中文](./docs/integrations/MINDPAL.zh-CN.md) |
  303. ### Agent Frameworks & SDKs
  304. | Platform | Access Method | Description | Guide |
  305. |----------|---------------|-------------|-------|
  306. | [LangChain](https://langchain.com/) | MCP stdio | Popular LLM framework | [EN](./docs/integrations/LANGCHAIN.md) / [中文](./docs/integrations/LANGCHAIN.zh-CN.md) |
  307. | [Smolagents](https://github.com/huggingface/smolagents) | MCP stdio | Hugging Face agent library | [EN](./docs/integrations/SMOLAGENTS.md) / [中文](./docs/integrations/SMOLAGENTS.zh-CN.md) |
  308. | [OpenAI Agents SDK](https://platform.openai.com/) | MCP SSE/Streamable HTTP | OpenAI's agent framework | [EN](./docs/integrations/OPENAI-AGENTS-SDK.md) / [中文](./docs/integrations/OPENAI-AGENTS-SDK.zh-CN.md) |
  309. | [Amazon Bedrock Agents](https://aws.amazon.com/bedrock/) | MCP SSE/Streamable HTTP | AWS AI agent service | [EN](./docs/integrations/AMAZON-BEDROCK-AGENTS.md) / [中文](./docs/integrations/AMAZON-BEDROCK-AGENTS.zh-CN.md) |
  310. | [Google ADK](https://cloud.google.com/) | MCP stdio | Google's Agent Development Kit | [EN](./docs/integrations/GOOGLE-ADK.md) / [中文](./docs/integrations/GOOGLE-ADK.zh-CN.md) |
  311. | [Vercel AI SDK](https://sdk.vercel.ai/) | MCP stdio | Vercel's AI development kit | [EN](./docs/integrations/VERCEL-AI-SDK.md) / [中文](./docs/integrations/VERCEL-AI-SDK.zh-CN.md) |
  312. | [Spring AI](https://spring.io/projects/spring-ai) | MCP stdio | Java/Spring AI framework | [EN](./docs/integrations/SPRING-AI.md) / [中文](./docs/integrations/SPRING-AI.zh-CN.md) |
  313. ### CLI Tools & Terminal
  314. | Platform | Access Method | Description | Guide |
  315. |----------|---------------|-------------|-------|
  316. | [Claude Code CLI](https://claude.ai/code) | MCP stdio | Terminal-based coding agent | [EN](./docs/integrations/CLAUDE-CODE.md) / [中文](./docs/integrations/CLAUDE-CODE.zh-CN.md) |
  317. | [Warp](https://www.warp.dev/) | MCP stdio | AI-powered terminal | [EN](./docs/integrations/WARP.md) / [中文](./docs/integrations/WARP.zh-CN.md) |
  318. | [Oterm](https://github.com/ggozad/oterm) | MCP stdio | Chat with Ollama via CLI | [EN](./docs/integrations/OTERM.md) / [中文](./docs/integrations/OTERM.zh-CN.md) |
  319. | [MCPHost](https://github.com/mark3labs/mcphost) | MCP stdio | CLI chat with LLMs | [EN](./docs/integrations/MCPHOST.md) / [中文](./docs/integrations/MCPHOST.zh-CN.md) |
  320. ### Productivity & Automation
  321. | Platform | Access Method | Description | Guide |
  322. |----------|---------------|-------------|-------|
  323. | [Raycast](https://raycast.com/) | MCP stdio | macOS productivity launcher | [EN](./docs/integrations/RAYCAST.md) / [中文](./docs/integrations/RAYCAST.zh-CN.md) |
  324. | [Notion](https://notion.so/) | MCP SSE/Streamable HTTP | Workspace with AI integration | [EN](./docs/integrations/NOTION.md) / [中文](./docs/integrations/NOTION.zh-CN.md) |
  325. | [Obsidian](https://obsidian.md/) | MCP stdio | Via MCP Tools plugin | [EN](./docs/integrations/OBSIDIAN.md) / [中文](./docs/integrations/OBSIDIAN.zh-CN.md) |
  326. | [Home Assistant](https://www.home-assistant.io/) | MCP stdio | Home automation platform | [EN](./docs/integrations/HOME-ASSISTANT.md) / [中文](./docs/integrations/HOME-ASSISTANT.zh-CN.md) |
  327. ### Messaging Platform Integrations
  328. | Platform | Access Method | Description | Guide |
  329. |----------|---------------|-------------|-------|
  330. | [Slack](https://slack.com/) | MCP stdio / REST API | Via Slack MCP bots | [EN](./docs/integrations/SLACK.md) / [中文](./docs/integrations/SLACK.zh-CN.md) |
  331. | [Discord](https://discord.com/) | MCP stdio / REST API | Via Discord MCP bots | [EN](./docs/integrations/DISCORD.md) / [中文](./docs/integrations/DISCORD.zh-CN.md) |
  332. | [Mattermost](https://mattermost.com/) | MCP stdio | Open-source messaging | [EN](./docs/integrations/MATTERMOST.md) / [中文](./docs/integrations/MATTERMOST.zh-CN.md) |
  333. ### Local LLM Runners
  334. | Platform | Access Method | Description | Guide |
  335. |----------|---------------|-------------|-------|
  336. | [Ollama](https://ollama.ai/) | MCP stdio | Run local LLMs | [EN](./docs/integrations/OLLAMA.md) / [中文](./docs/integrations/OLLAMA.zh-CN.md) |
  337. | [LM Studio](https://lmstudio.ai/) | MCP stdio | Local LLM desktop app | [EN](./docs/integrations/LM-STUDIO.md) / [中文](./docs/integrations/LM-STUDIO.zh-CN.md) |
  338. | [Jan](https://jan.ai/) | MCP stdio | Offline ChatGPT alternative | [EN](./docs/integrations/JAN.md) / [中文](./docs/integrations/JAN.zh-CN.md) |
  339. ### Development & Testing Tools
  340. | Platform | Access Method | Description | Guide |
  341. |----------|---------------|-------------|-------|
  342. | [MCP Inspector](https://github.com/modelcontextprotocol/inspector) | MCP stdio | Official MCP debugging tool | [EN](./docs/integrations/MCP-INSPECTOR.md) / [中文](./docs/integrations/MCP-INSPECTOR.zh-CN.md) |
  343. | [Postman](https://postman.com/) | REST API / MCP | API testing platform | [EN](./docs/integrations/POSTMAN.md) / [中文](./docs/integrations/POSTMAN.zh-CN.md) |
  344. > **Note**: Any MCP-compatible client can connect via stdio (local) or SSE/Streamable HTTP (remote). Any HTTP client can use the REST API.
  345. ## 📚 Documentation
  346. ### Getting Started
  347. - [Installation Guide](./docs/getting-started/installation.md)
  348. - [Quick Start](./docs/getting-started/quick-start.md)
  349. - [Configuration](./docs/getting-started/configuration.md)
  350. - [Usage Examples](./docs/getting-started/examples.md)
  351. ### Deployment
  352. - [Deployment Overview](./docs/deployment/README.md)
  353. - [Local Deployment](./docs/deployment/local.md)
  354. - [Docker Deployment](./docs/deployment/docker.md)
  355. - [Cloud Deployment](./docs/deployment/cloud/)
  356. ### Database Guides
  357. - [Database Support Overview](./docs/databases/README.md)
  358. - [MySQL](./docs/databases/mysql.md)
  359. - [PostgreSQL](./docs/databases/postgresql.md)
  360. - [More databases...](./docs/databases/)
  361. ### HTTP API
  362. - [API Reference](./docs/http-api/API_REFERENCE.md)
  363. - [Deployment Guide](./docs/http-api/DEPLOYMENT.md)
  364. ### Integrations
  365. **AI Editors & IDEs:**
  366. [Cursor](./docs/integrations/CURSOR.md) |
  367. [VS Code](./docs/integrations/VSCODE.md) |
  368. [JetBrains](./docs/integrations/JETBRAINS.md) |
  369. [Windsurf](./docs/integrations/WINDSURF.md) |
  370. [Zed](./docs/integrations/ZED.md) |
  371. [Neovim](./docs/integrations/NEOVIM.md) |
  372. [Emacs](./docs/integrations/EMACS.md)
  373. **AI Assistants:**
  374. [Claude Desktop](./docs/integrations/CLAUDE-DESKTOP.md) |
  375. [Claude Code](./docs/integrations/CLAUDE-CODE.md) |
  376. [GitHub Copilot](./docs/integrations/GITHUB-COPILOT.md) |
  377. [Cline](./docs/integrations/CLINE.md) |
  378. [Continue](./docs/integrations/CONTINUE.md)
  379. **AI Platforms:**
  380. [Dify](./docs/integrations/DIFY.md) |
  381. [Coze](./docs/integrations/COZE.md) |
  382. [n8n](./docs/integrations/N8N.md) |
  383. [ChatGPT](./docs/integrations/CHATGPT.md) |
  384. [LangChain](./docs/integrations/LANGCHAIN.md)
  385. **Desktop Apps:**
  386. [Cherry Studio](./docs/integrations/CHERRY-STUDIO.md) |
  387. [LM Studio](./docs/integrations/LM-STUDIO.md) |
  388. [Jan](./docs/integrations/JAN.md) |
  389. [Ollama](./docs/integrations/OLLAMA.md)
  390. **Messaging:**
  391. [Slack](./docs/integrations/SLACK.md) |
  392. [Discord](./docs/integrations/DISCORD.md)
  393. **Tools:**
  394. [MCP Inspector](./docs/integrations/MCP-INSPECTOR.md) |
  395. [Postman](./docs/integrations/POSTMAN.md)
  396. > 📁 [View all 55 integration guides](./docs/integrations/) | 中文版本请在对应文档名后加 `.zh-CN`
  397. ### Advanced
  398. - [Security Guide](./docs/guides/security.md)
  399. - [Multi-tenant Guide](./docs/guides/multi-tenant.md)
  400. - [Architecture](./docs/development/architecture.md)
  401. - [Troubleshooting](./docs/operations/troubleshooting.md)
  402. ## 🤝 Contributing
  403. Contributions are welcome! Please read our [Contributing Guide](./CONTRIBUTING.md) before submitting a Pull Request.
  404. ```bash
  405. # Clone the repository
  406. git clone https://github.com/Anarkh-Lee/universal-db-mcp.git
  407. # Install dependencies
  408. npm install
  409. # Build
  410. npm run build
  411. # Run tests
  412. npm test
  413. ```
  414. ## 📄 License
  415. This project is licensed under the [MIT License](./LICENSE).
  416. ## 🌟 Star History
  417. If you find this project useful, please consider giving it a star! Your support helps us continue improving Universal DB MCP.
  418. [![Star History Chart](https://api.star-history.com/svg?repos=Anarkh-Lee/universal-db-mcp&type=Date)](https://star-history.com/#Anarkh-Lee/universal-db-mcp&Date)
  419. ## 📝 Changelog
  420. See [CHANGELOG.md](./CHANGELOG.md) for a detailed version history.
  421. ---
  422. <p align="center">
  423. Made with ❤️ by <a href="https://github.com/Anarkh-Lee">Anarkh-Lee</a>
  424. </p>

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.