rolandohuber/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 comprehensive Model Context Protocol (MCP) server for MySQL database operations, compatible with Claude, Windsurf, WebStorm, and other MCP clients.
Tools
Functions exposed to the LLM to take actions
mysql.listTables
Lists all tables in the current database.
mysql.describeTable
Gets the schema of a specific table including columns, types, and constraints.
mysql.query
Executes any SQL query on the MySQL database.
mysql.generateTestData
Generates fake test data for a table, respecting foreign key relationships.
mysql.tableRelations
Gets foreign key relationships for a table (both outgoing and incoming).
mysql.listDatabases
Lists all databases accessible to the current MySQL user.
mysql.listIndexes
Lists all indexes for a specific table.
mysql.insert
Inserts data into a table.
mysql.update
Updates records in a table based on a WHERE clause.
mysql.delete
Deletes records from a table based on a WHERE clause.
mysql.ping
Tests the connection to the MySQL server.
mysql.version
Gets the version of the MySQL server.
mysql.explain
Returns the execution plan for a SQL query.
mysql.summarizeTable
Generates a summary of a table including row count and column statistics.
mysql.sampleData
Returns a sample of rows from a table.
mysql.generateSchemaDiagram
Generates a JSON structure representing the database schema for diagramming.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client