easy-mysql-mcp
High performance MySQL MCP Server using mysql2
Versions
1.2.2latest1.2.01.1.21.1.11.1.0+ show 4 moreshow less
1.0.41.0.31.0.11.0.0Tools 17
mysql_manual Return the MySQL MCP manual. Use this first when you are unsure how to use mysql_query, mysql_execute, mysql_batch_execute, or when an operation fails and you need the safe usage rules, parameter rules, or SQL composition guidance.
mysql_query Execute a read-only SQL query (e.g., SELECT). Use this for data retrieval.
mysql_execute Execute a data modification SQL statement (e.g., INSERT, UPDATE, DELETE).
mysql_batch_execute Execute one data modification SQL statement repeatedly with multiple parameter sets.
mysql_import_csv Import a UTF-8 CSV file into a table using the header row as column names.
mysql_schema_execute Execute an advanced schema modification SQL statement, such as CREATE TABLE, ALTER TABLE, DROP VIEW, CREATE TRIGGER, or CREATE INDEX.
mysql_run_approved_command Run a pending command after the host has obtained user approval.
mysql_list_pending_approvals List pending commands waiting for approval.
mysql_cancel_approval Cancel a pending approval request.
mysql_export_csv Export all rows from a table to a UTF-8 CSV file.
explain_query Run EXPLAIN on a SQL query to analyze its execution plan and performance.
list_tables List all base tables in the current database with row counts and comments.
list_views List all views in the current database.
describe_table Show the schema/structure of one or more specific tables.
describe_index Show indexes for a specific table.
list_triggers List all triggers in the current database.
get_current_privileges Check the permissions and grants of the current database user. Useful for debugging access issues.
Permissions 4
network medium filesystem low shell high env_vars low Scan Findings 0
No scan findings.