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.
The MySQL MCP Server is a Model Context Protocol server that facilitates interaction with a MySQL database, allowing agents to execute SQL queries.
The MySQL MCP Server is designed to provide seamless access to a MySQL database through the Model Context Protocol. It enables agents to perform various SQL operations such as reading, creating, inserting, updating, and deleting data within a MySQL database. The server returns query results in JSON format, making it easy to integrate with other systems. It also supports configurable database connection settings and logs transactions with unique IDs for auditing purposes. The server requires Node.js, a MySQL server, and the MCP SDK to function. It can be configured using environment variables and is compatible with platforms like VSCode and the Claude Desktop App.
Features
- Execute SQL queries against a MySQL database: Read, Create, Insert, Update, Delete
- Returns query results in JSON format
- Configurable database connection settings
- Transaction logging with unique IDs
Tools
run_sql_query
Executes a read-only SQL query (SELECT statements only) against the MySQL database.
create_table
Creates a new table in the MySQL database.
insert_data
Inserts data into a table in the MySQL database.
update_data
Updates data in a table in the MySQL database.
delete_data
Deletes data from a table in the MySQL database.
