mysql-mcp-server-modification
If you are the rightful owner of mysql-mcp-server-modification 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 provides read-only access to MySQL databases.
The MySQL MCP server is designed to facilitate read-only interactions with MySQL databases. It allows users to list available databases, enumerate tables within a database, describe the structure of tables, and execute read-only SQL queries. This server is particularly useful for applications that require database information without the need for data modification capabilities. The server is installed via NPM and requires specific environment variables for configuration, including database host, port, user credentials, and optionally, a default database name. Once configured, it can be integrated into an MCP setup to automate database interactions.
Features
- List available databases
- List tables within a database
- Describe table structure with field comments
- Execute read-only SQL queries
Tools
list_databases
Lists all accessible databases on the MySQL server.
list_tables
Lists all tables in a specified database.
describe_table
Displays detailed structure of a specified table.
execute_query
Executes a read-only SQL query.
