Jewei Mysql Mcp Server
About
Jewei Mysql Mcp Server is a MySQL database query server that executes SQL queries (only SELECT statements), retrieves table structure information (columns, primary keys, foreign keys, indexes), and lists all tables in a database. It is designed for developers who need to…
Details
- Author
- jeweis
- Downloads
- 356
- Categories
- Database
Jump to
- Execute SQL queries and return result sets (SELECT only)
- Get detailed table structure including columns, keys, and indexes
- List all tables in the specified database
- Supports MCP integration with Windsurf, Cursor, Claude, and Cline
- Run via uvx for easy installation and execution
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Jewei Mysql Mcp ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install dependencies with pip install -r requirements.txt, create a .env file with the environment variables DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, and DB_NAME, then run using uvx --from jewei-mysql-mcp-server jewei-mysql-mcp-server (recommended) or from source with python -m jewei_mysql_mcp_server.server. Configure the server in MCP config files for supported clients, replacing placeholder values with your actual database connection info.
query_sql
执行SQL查询并返回结果集（仅支持SELECT语句） Args: sql: SQL查询语句（必须是SELECT语句） Returns: 包含查询结果的字典，格式为： { "columns": [列名列表], "rows": [行数据列表], "row_count": 结果行数 }
get_table_structure
获取指定表的结构信息 Args: table_name: 表名 schema: 数据库名，默认为当前数据库 Returns: 包含表结构信息的字典，格式为： { "columns": [列信息列表], "primary_keys": [主键列表], "foreign_keys": [外键信息列表], "indexes": [索引信息列表] }
list_tables
列出数据库中的所有表 Args: schema: 数据库名，默认为当前数据库 Returns: 包含表列表的字典，格式为： { "tables": [表信息列表], "count": 表数量 }
get_db_info
获取数据库基本信息 Returns: 包含数据库信息的字典，格式为： { "database_name": 当前数据库名, "version": 数据库版本, "schemas": [数据库列表], "connection": { "host": 主机名, "port": 端口, "database": 数据库名, "user": 用户名 } }
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"jewei mysql mcp server": {
"jewei-mysql": {
"disabled": false,
"command": "uvx",
"args": [
"jewei-mysql-mcp-server"
],
"env": {
"DB_HOST": "your_db_host",
"DB_USER": "your_db_user",
"DB_PASSWORD": "your_db_password",
"DB_NAME": "your_db_name",
"DB_PORT": "your_db_port"
}
}
}
}
}McpServers
{
"jewei-mysql": {
"disabled": false,
"command": "uvx",
"args": [
"jewei-mysql-mcp-server"
],
"env": {
"DB_HOST": "your_db_host",
"DB_USER": "your_db_user",
"DB_PASSWORD": "your_db_password",
"DB_NAME": "your_db_name",
"DB_PORT": "your_db_port"
}
}
}MySQL MCP Server
这是一个MySQL数据库查询服务器，提供了以下功能： - 执行SQL查询（仅支持SELECT语句） - 获取表结构信息 - 列出数据库中的所有表MCP 配置
本项目支持通过多种客户端配置 MCP 服务器，以便与各种 IDE 或工具集成。以下是一些常见客户端的配置示例：Windsurf / Cursor / Claude
对于基于 Windsurf 框架的客户端（如 Cursor 和 Claude），您可以在~/.codeium/windsurf/mcp_config.json 文件中配置 MCP 服务器。以下是一个示例配置：
``json
{
"mcpServers": {
"jewei-mysql": {
"disabled": false,
"command": "uvx",
"args": [
"jewei-mysql-mcp-server"
],
"env": {
"DB_HOST": "your_db_host",
"DB_USER": "your_db_user",
"DB_PASSWORD": "your_db_password",
"DB_NAME": "your_db_name",
"DB_PORT": "your_db_port"
}
}
}
}
`
请将 your_db_host, your_db_user, your_db_password, 和 your_db_name 替换为您的实际数据库连接信息。
Cline
对于 Cline 客户端，您可以在其配置文件中添加类似的 MCP 服务器配置。具体的配置方式请参考 Cline 的官方文档。通常，您需要指定服务器的名称、命令、参数和环境变量。
`json
// Cline 配置文件示例 (具体格式请参考 Cline 文档)
{
"mcpServers": {
"jewei-mysql": {
"command": "uvx",
"args": [
"jewei-mysql-mcp-server"
],
"env": {
"DB_HOST": "your_db_host",
"DB_USER": "your_db_user",
"DB_PASSWORD": "your_db_password",
"DB_NAME": "your_db_name",
"DB_PORT": "your_db_port"
}
}
}
}
`
请将示例中的占位符替换为您的实际数据库连接信息，并根据 Cline 的具体配置格式进行调整。
安装
1. 克隆仓库
2. 安装依赖：pip install -r requirements.txt
3. 配置环境变量（参见下文）
配置
在项目根目录创建.env文件，包含以下环境变量：
`
DB_HOST=localhost
DB_PORT=3306
DB_USER=root
DB_PASSWORD=your_password
DB_NAME=your_database
`
运行
使用uvx安装并运行（推荐）
`bash
uvx --from jewei-mysql-mcp-server jewei-mysql-mcp-server
`
或者从源码运行
`bash
python -m jewei_mysql_mcp_server.server
``
功能
执行SQL查询
执行SQL查询并返回结果集（仅支持SELECT语句）。获取表结构信息
获取指定表的结构信息，包括列信息、主键、外键和索引。列出数据库中的所有表
列出指定数据库中的所有表。Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
