Skip to main content

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)

Source distribution for keevor-mysql-mcp-server 1.0.0
File Size Uploaded Provenance
keevor_mysql_mcp_server-1.0.0.tar.gz 49.3 kB Without provenance Details

Built distribution (wheel)

Table of built distributions (wheels) for keevor-mysql-mcp-server 1.0.0
File Interpreter ABI Platform
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.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page