mcp-mysql-server
If you are the rightful owner of mcp-mysql-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 server that provides MySQL database operations, enabling AI models to interact with MySQL databases through a standardized interface.
The @f4ww4z/mcp-mysql-server is a Model Context Protocol (MCP) server designed to facilitate interactions between AI models and MySQL databases. It provides a standardized interface for executing database operations such as connecting to a database, executing queries, and managing tables. The server supports secure connection handling, prepared statements, and comprehensive error handling, making it a robust solution for database interactions. It is compatible with TypeScript and can be installed via Smithery or manually. The server requires specific environment variables for configuration, ensuring secure and efficient database operations.
Features
- Secure connection handling with automatic cleanup
- Prepared statement support for query parameters
- Comprehensive error handling and validation
- TypeScript support
- Automatic connection management
Tools
connect_db
Use the provided credentials to establish a connection to the MySQL database
query
Execute SELECT query, support preprocessing statements with parameters
execute
Execute INSERT, UPDATE, or DELETE queries, and support preprocessing statements with parameters
list_tables
List all tables in the connection database
describe_table
Get the structure of a specific table
