keevor-mysql-mcp-server
一个 MCP (Model Context Protocol) 服务器,用于连接 MySQL 数据库并执行常用操作。
功能
list_tables- 查询数据库中的所有表describe_table- 查询指定表的结构execute_sql- 执行 SQL 语句
使用方法
1. 安装 uv
# Windows (PowerShell)
irm https://astral.sh/uv/install.ps1 | iex
# macOS / Linux
curl -LsSf https://astral.sh/uv/install.sh | sh
2. 配置 MCP
在 AI 工具的 MCP 配置文件中添加:
{
"mcpServers": {
"keevor-mysql-mcp-server": {
"command": "uvx",
"args": ["keevor-mysql-mcp-server"],
"env": {
"DB_HOST": "localhost",
"DB_PORT": "3306",
"DB_USER": "root",
"DB_PASSWORD": "your_password",
"DB_NAME": "your_database"
}
}
}
}
3. 开始使用
配置完成后,AI 助手即可使用以下工具:
- 查询所有表:调用
list_tables - 查询表结构:调用
describe_table,传入表名 - 执行 SQL:调用
execute_sql,传入 SQL 语句
环境变量
| 变量 | 说明 | 默认值 |
|---|---|---|
| DB_HOST | 数据库主机地址 | localhost |
| DB_PORT | 数据库端口 | 3306 |
| DB_USER | 数据库用户名 | root |
| DB_PASSWORD | 数据库密码 | - |
| DB_NAME | 数据库名称 | - |
License
MIT
Metadata
Release files for keevor-mysql-mcp-server 1.0.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| keevor_mysql_mcp_server-1.0.0.tar.gz | 49.3 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| keevor_mysql_mcp_server-1.0.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 55.2 kB
Release files / keevor_mysql_mcp_server-1.0.0.tar.gz
| Download URL | keevor_mysql_mcp_server-1.0.0.tar.gz |
|---|---|
| Size | 49.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
100c368770915f046fa732ae7c88b6d4b1d5f31b4f95e0678d887e031ffbd461
|
|
BLAKE2b-256 checksum How to use checksums |
add129def5fc3e26b0c4215edde722955bc2fda8af2fa2a06d095bd51c3d1c90
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.9.7
|
Release files / keevor_mysql_mcp_server-1.0.0-py3-none-any.whl
| Download URL | keevor_mysql_mcp_server-1.0.0-py3-none-any.whl |
|---|---|
| Size | 5.9 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
516cbb052a0815f11fd4fe37381c5e1938052d8f58e376847cdcb68cdb4ef9b1
|
|
BLAKE2b-256 checksum How to use checksums |
307973dfe586e72da0fadf94f3b70e1728229b5da709e59ba9a89d561da36355
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.9.7
|
Security for keevor-mysql-mcp-server 1.0.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.