keevor-mysql-mcp-server
一个连接MySQL数据库的MCP服务器,支持列出表、描述表结构和执行SQL语句。
README
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
Recommended Servers
playwright-mcp
A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.
Magic Component Platform (MCP)
An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.
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.
VeyraX MCP
Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.
graphlit-mcp-server
The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.
Kagi MCP Server
An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.
E2B
Using MCP to run code via e2b.
Neon Database
MCP server for interacting with Neon Management API and databases
Exa Search
A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.
Qdrant Server
This repository is an example of how to create a MCP server for Qdrant, a vector search engine.