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.
A Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
The MySQL MCP Server is designed to facilitate read-only interactions with MySQL databases through a Model Context Protocol. It allows Language Model Machines (LLMs) to access and inspect database schemas and execute read-only SQL queries. The server supports MySQL authentication via a database URL, ensuring secure access to the database. It is particularly useful for applications that require database schema inspection and data retrieval without the risk of data modification. The server automatically handles authentication and executes all queries within a read-only transaction, ensuring data integrity and security. Additionally, it provides JSON schema information for each table, including column names and data types, which are automatically discovered from the database metadata.
Features
- Read-only access to MySQL databases
- Automatic authentication using database URL
- Execution of SQL queries within a READ ONLY transaction
- Provision of JSON schema information for each table
- Secure handling of credentials
