MCP MySQL Server
Facilitates interaction with a local MySQL database via a RESTful API, supporting database queries and real-time updates with integration for Cursor MCP services.
TristanLib
README
MCP MySQL 本地数据库服务
MCP MySQL服务是一个轻量级的个人使用服务程序，用于连接和操作本地MySQL数据库。此服务可作为Cursor的MCP服务使用，通过API接口使Cursor能够轻松地执行各种数据库操作。
特性
- 连接本地MySQL数据库
- 提供RESTful API进行数据库操作
- 支持参数化查询防止SQL注入
- 支持SSE (Server-Sent Events) 推送能力
- 支持作为Cursor MCP服务集成
快速开始
前置条件
- Node.js (v14+)
- MySQL服务器
安装
- 克隆此仓库
- 安装依赖
npm install - 创建并配置
.env文件# 服务器配置 PORT=3000 NODE_ENV=development # MySQL数据库配置 DB_HOST=localhost DB_PORT=3306 DB_USER=你的用户名 DB_PASSWORD=你的密码 DB_NAME=你的数据库名 # API配置 API_KEY=你的API密钥
运行
npm start
开发模式（自动重启）:
npm run dev
API接口
获取所有数据库
GET /api/databases
获取数据库的所有表
GET /api/databases/:database/tables
获取表结构
GET /api/databases/:database/tables/:table/structure
执行查询
POST /api/query
Content-Type: application/json
{
"sql": "SELECT * FROM users WHERE age > ?",
"params": [18],
"limit": 10,
"offset": 0
}
SSE连接
GET /api/sse?apiKey=your-api-key
在Cursor中使用
SSE方式
{
"name": "MySQL数据库服务",
"url": "http://localhost:3000/api/sse",
"type": "sse"
}
Command方式
{
"name": "MySQL数据库服务",
"command": "node /path/to/mcp_server_mysql/src/app.js",
"type": "command"
}
安全性考虑
- 此服务仅限本地使用，不建议暴露到公网
- 使用API密钥保护接口
- 默认只允许执行SELECT查询
许可证
MIT
Recommended Servers
Audiense Insights MCP Server
Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.
Excel MCP Server
A Model Context Protocol server that enables AI assistants to read from and write to Microsoft Excel files, supporting formats like xlsx, xlsm, xltx, and xltm.
Playwright MCP Server
Provides a server utilizing Model Context Protocol to enable human-like browser automation with Playwright, allowing control over browser actions such as navigation, element interaction, and scrolling.
Claude Code MCP
An implementation of Claude Code as a Model Context Protocol server that enables using Claude's software engineering capabilities (code generation, editing, reviewing, and file operations) through the standardized MCP interface.
Apple MCP Server
Enables interaction with Apple apps like Messages, Notes, and Contacts through the MCP protocol to send messages, search, and open app content using natural language.
Supabase MCP Server
A Model Context Protocol (MCP) server that provides programmatic access to the Supabase Management API. This server allows AI models and other clients to manage Supabase projects and organizations through a standardized interface.
@kazuph/mcp-gmail-gas
Model Context Protocol server for Gmail integration. This allows Claude Desktop (or any MCP client) to interact with your Gmail account through Google Apps Script.
MCP DuckDB Knowledge Graph Memory Server
A memory server for Claude that stores and retrieves knowledge graph data in DuckDB, enhancing performance and query capabilities for conversations with persistent user information.
dbt Semantic Layer MCP Server
A server that enables querying the dbt Semantic Layer through natural language conversations with Claude Desktop and other AI assistants, allowing users to discover metrics, create queries, analyze data, and visualize results.
Metabase MCP Server
Enables AI assistants to interact with Metabase databases and dashboards, allowing users to list and execute queries, access data visualizations, and interact with database resources through natural language.