f4ww4z_mcp-mysql-server
If you are the rightful owner of f4ww4z_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 management in AI applications. It is compatible with various platforms and can be installed via Smithery or manually. The server is open-source and contributions are welcome.
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
Establish a connection to the MySQL database
query
Execute SELECT query, support parameterized query
execute
Perform INSERT, UPDATE, DELETE and other operations
list_tables
List all tables in the database
describe_table
Get the structure information of the specified table
