mysql-mcp-server
If you are the rightful owner of 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.
MCP MySQL Server is a MySQL tool service based on the Model Context Protocol SDK, designed for AI agents and automation tools.
MCP MySQL Server is a robust and efficient MySQL tool service built on the Model Context Protocol SDK. It is designed to facilitate SQL operations, database structure retrieval, and connection status checks, making it an ideal solution for AI agents and automation tools. The server ensures secure and efficient database interactions by implementing SQL and parameter validation to prevent dangerous operations and SQL injection attacks. With a focus on seamless integration and ease of use, MCP MySQL Server supports graceful service startup and shutdown, ensuring minimal disruption during maintenance or updates. The architecture is modular, with separate components for server management, database operations, configuration, and security validation, allowing for easy customization and scalability. The service is compatible with various platforms, including Windows, Linux, and MacOS, and can be configured using environment variables or a .env file for flexibility in different deployment environments.
Features
- Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)
- Retrieve database table structure information
- Check database connection status
- SQL statement and parameter security validation
- Graceful service startup and shutdown
Tools
execute_sql
Execute SQL queries
get_tables_info
Retrieve all tables and field structures
get_connection_status
Check database connection status