Atomzzm_mcp-mysql-server
If you are the rightful owner of Atomzzm_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 TypeScript and offers automatic connection management to ensure efficient resource utilization. The server can be installed via Smithery or manually, and it requires specific environment variables for configuration.
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 connection to MySQL database using provided credentials.
query
Execute SELECT queries with optional prepared statement parameters.
execute
Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.
list_tables
List all tables in the connected database.
describe_table
Get the structure of a specific table.
