SuMiaoALi_mysql-mcp-server
If you are the rightful owner of SuMiaoALi_mysql-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol (MCP) server that provides secure MySQL database operations for AI assistants and other MCP clients.
The MySQL MCP Server is a specialized server designed to facilitate secure and efficient interactions with MySQL databases through the Model Context Protocol (MCP). It is tailored for AI assistants and other MCP clients, ensuring that database operations are conducted safely and efficiently. The server supports a range of operations, including executing queries, retrieving table information, and inserting data, all while maintaining a strong focus on security. It employs parameterized queries to protect against SQL injection attacks and automatically adds LIMIT clauses to SELECT queries to prevent large data dumps. Additionally, the server manages database connections efficiently through connection pooling, ensuring optimal performance even under heavy load. The server is easy to install and configure, with support for environment variables to customize its operation according to user needs.
Features
- Secure MySQL database operations for AI assistants
- Supports SELECT, INSERT, SHOW, and DESCRIBE operations
- SQL Injection Protection with parameterized queries
- Automatic LIMIT clauses for SELECT queries
- Efficient connection pooling for optimal performance
Tools
execute_query
Execute safe SQL queries (SELECT, INSERT, SHOW, DESCRIBE)
get_table_info
Get detailed table structure information
insert_data
Convenient data insertion with automatic parameterization
list_tables
List all tables in the database