Mcp Mysql Server
@huangfeng19820712
About Mcp Mysql Server
一个提供MySQL数据库操作的模型上下文协议服务器。该服务器使AI模型能够通过标准化接口与MySQL数据库进行交互。支持对数据库的所有操作。
Basic information
Category
Databases
License
MIT
Runtime
node
Transports
stdio
Publisher
huangfeng19820712
Submitted by
huangfeng19820712
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@fhuang/mcp-mysql-server"
],
"env": {
"MYSQL_HOST": "IP",
"MYSQL_USER": "USER",
"MYSQL_PORT": "PORT",
"MYSQL_PASSWORD": "password",
"MYSQL_DATABASE": "DATABASE"
}
}
}
}Tools
7Connect to MySQL database
Execute a SELECT query,can not get table structure,use describe_table tool to get table structure
Execute an INSERT, UPDATE, or DELETE query
List all tables in the database
Get table structure
Execute a SHOW statement (e.g., SHOW STATUS, SHOW VARIABLES)
Analyze SQL query performance using EXPLAIN
Overview
What is Mcp Mysql Server?
A Model Context Protocol server that provides MySQL database operations. It enables AI models to interact with MySQL databases through a standardized interface.
How to use Mcp Mysql Server?
Install via Smithery (npx -y @smithery/cli install @fhuang/mcp-mysql-server --client claude) or manually (npx @fhuang/mcp-mysql-server). Configure with a connection string or environment variables (MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE). Use tools like connect_db, query, execute, list_tables, describe_table, show_statement, and explain.
Key features of Mcp Mysql Server
- Secure connection handling with automatic cleanup
- Prepared statement support to prevent SQL injection
- Comprehensive error handling and validation
- TypeScript support
- Automatic connection management
- Tools for querying, executing DML, and schema inspection
Use cases of Mcp Mysql Server
- AI assistants querying MySQL databases for information retrieval
- Executing INSERT, UPDATE, or DELETE operations via natural language
- Listing and describing database tables for schema exploration
- Analyzing query performance using EXPLAIN
- Running administrative SHOW statements
FAQ from Mcp Mysql Server
How does Mcp Mysql Server prevent SQL injection?
It uses prepared statements for all parameterized queries, ensuring user input is safely escaped.
What runtime dependencies does Mcp Mysql Server require?
Node.js and npx are required. The server is distributed as an npm package and runs via npx.
How are database credentials handled?
Credentials can be passed via a connection string (e.g., mysql://user:password@localhost:port/database) or through environment variables (MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE).
What happens if a query fails?
The server returns detailed error messages for connection failures, invalid queries, missing parameters, and database errors.
Does Mcp Mysql Server support transactions?
The README does not mention explicit transaction support; it provides execute for DML statements but no commit/rollback tools.
More Databases MCP servers
Neon MCP Server
neondatabaseMCP server for interacting with Neon Management API and databases
PostgreSQL Model Context Protocol (PG-MCP) Server
stuzero
Meilisearch MCP Server
meilisearchA Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.
Multi Database MCP Server
FreePeakA powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.
MCP Alchemy
runekaagaardA MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.
Comments