Full support for MariaDB databases with the same capabilities as MySQL, including multi-connection, querying, schema exploration, stored procedures, scripts, and sandbox testing.
Feature-rich MCP server for MySQL with multi-connection support, allowing querying, schema management, stored procedures, scripts, and administrative tools across multiple MySQL instances.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@mysql-mcp list tables in the sales database"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Feature-rich MCP server for MySQL and MariaDB with multi-connection support. Connect many instances at once — query schemas, run scripts, test stored procedures with sandbox rollback.
npm: @raviraj87/mysql-mcp
Runs locally via stdio (any MCP-compatible client)
Supports MySQL 5.7+, 8.x, MariaDB 10.x–11.x, InnoDB/Aria/MyISAM
Connect to the MySQL server — no database required in the URI. Use list_databases, then pass database on each tool call (or set default_database in config).
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": ["-y", "@raviraj87/mysql-mcp"],
"env": {
"MYSQL_URI": "mysql://user:pass@localhost:3306"
}
}
}
}Typical workflow
list_databases — discover databases on the server
Pick a database (agent asks, or you pass it explicitly)
list_tables, query, etc. with "database": "myapp"
Optional: set default_database in YAML so tools skip the database param for that connection.
Multiple connections — copy config.example.yaml → ~/.mysql-mcp.yaml:
default_connection: local
connections:
local:
uri_env: MYSQL_URI
default_database: myapp # optional — omit to choose per tool call
staging:
uri_env: MYSQL_URI_STAGING
prod:
uri_env: MYSQL_URI_PROD
read_only: trueSet URIs in MCP env. Every tool accepts optional connection: "staging".
Extra connections via env:
MYSQL_EXTRA_CONNECTIONS=staging:MYSQL_URI_STAGING,prod:MYSQL_URI_PRODLevel | Config | Example |
Server |
|
|
Default DB |
|
|
Per tool |
|
|
Tools like ping, list_databases, and server_info work without a database. Schema/query tools require database or default_database.
Related MCP server: mcp-server-sqlite
Connection: list_connections, ping, server_info, connect
Metadata: list_databases, list_tables, describe_table, show_create_table, list_indexes, list_foreign_keys, table_stats, list_views, list_triggers, list_events
Read: query, query_one, explain, count, sample_rows, distinct_values, export_query
Write: execute, execute_batch, insert_rows, delete_rows, truncate_table
Routines: list_procedures, list_functions, describe_procedure, show_create_procedure, show_create_function, call_procedure, call_function, test_procedure, create_procedure, drop_procedure, routine_overview
Scripts: split_script, validate_script, run_script, test_script, load_script_file, run_script_with_vars
Admin: execute_ddl, create_database, drop_database, create_index, drop_index, show_grants
Diagnostics: processlist, status, variables, innodb_status, replication_status, kill_query, health_check
Composite: explore_table, database_overview, analyze_query, compare_tables, index_health
Test a procedure (rollback by default):
{
"tool": "test_procedure",
"arguments": {
"database": "myapp",
"procedure": "sp_create_order",
"params": { "p_customer_id": 42, "p_amount": 99.99 },
"setup_sql": ["INSERT INTO customers (id) VALUES (42)"]
}
}Test a SQL script:
{
"tool": "test_script",
"arguments": {
"database": "myapp",
"script": "DELIMITER $$\nCREATE PROCEDURE ...\nEND$$\nDELIMITER ;\nCALL my_proc(1);"
}
}split_script handles DELIMITER changes. Sandbox rollback requires InnoDB/Aria unless compatibility.allow_myisam_sandbox: true.
Global or per-connection read_only
max_rows auto-LIMIT on SELECT
query_timeout_ms via session max_execution_time / max_statement_time
explain_check — reject full table scans
confirmation_required_tools — destructive ops need confirmed: true
test_sandbox_default: true — scripts/SP tests roll back unless committed
allowed_databases per connection
Blocks INTO OUTFILE, LOAD DATA, SHUTDOWN
cd mysql-mcp
npm install
npm run build{
"command": "node",
"args": ["/path/to/mysql-mcp/dist/index.js"]
}Copyright © 2026 Ravi Raj. Licensed under the MIT License.
Composite: EXPLAIN with human-readable summary.
Inputs: sql (required), params, database, connection.
Call a stored function with positional params.
Inputs: function (required), params, database, connection.
Call a stored procedure with JSON params; captures result sets and OUT parameters.
Inputs: procedure (required), params, database, connection.
Compare column definitions between two tables (same or different connections).
Inputs: table (required), other_table (required), database, connection, +2 more.
Add or replace a runtime connection by URI. Use a unique name.
Inputs: name (required), connectionString (required), readOnly, description, +1 more.
COUNT rows in a table with optional WHERE clause.
Inputs: table (required), where, params, database, +1 more.
Create a database.
Inputs: database (required), charset, collation, confirmed, +1 more.
Create an index on a table.
Inputs: table (required), columns (required), index_name (required), unique, +2 more.
Deploy a stored procedure from SQL (CREATE PROCEDURE body).
Inputs: sql (required), database, confirmed, connection, +1 more.
Composite: all tables with row estimates, engine, and sizes.
Inputs: database, connection.
DELETE rows with a required WHERE clause.
Inputs: table (required), where (required), params, database, +2 more.
Parameter list and metadata for a stored procedure.
Inputs: procedure (required), database, connection.
Column definitions for a table (information_schema + SHOW FULL COLUMNS).
Inputs: table (required), database, connection.
Distinct values for a column (capped).
Inputs: table (required), column (required), limit, database, +1 more.
Drop a database. Requires confirmed=true.
Inputs: database (required), confirmed, connection.
Drop an index from a table.
Inputs: table (required), index_name (required), database, confirmed, +1 more.
Drop a stored procedure.
Inputs: procedure (required), database, confirmed, connection.
Execute a single DML statement (INSERT/UPDATE/DELETE) with ? placeholders.
Inputs: sql (required), params, database, connection.
Execute multiple DML statements in a single transaction.
Inputs: statements (required), database, confirmed, connection.
Execute a DDL statement (CREATE/ALTER/DROP). Requires confirmed=true.
Inputs: sql (required), database, confirmed, connection.
EXPLAIN a SELECT query (JSON format when supported).
Inputs: sql (required), params, analyze, database, +1 more.
Composite: columns, indexes, foreign keys, stats, and sample rows.
Inputs: table (required), database, connection, sampleSize.
Run a SELECT and return truncated JSON for large results.
Inputs: sql (required), params, database, maxChars, +1 more.
Composite health: ping, version, engine, replication snippet.
Inputs: connection.
List indexes with cardinality and flag possible duplicates.
Inputs: table, database, connection.
SHOW ENGINE INNODB STATUS (InnoDB only).
Inputs: connection.
Bulk insert rows from a JSON array of objects (column keys must match).
Inputs: rows (required), table (required), database, connection.
Kill a query by connection id.
Inputs: id (required), confirmed, connection.
List all configured MySQL/MariaDB connections (names only, no URIs).
Inputs: no named parameters.
List databases on the server (respects allowed_databases).
Inputs: connection.
List scheduled events in a database.
Inputs: database, connection.
List foreign key constraints for a table.
Inputs: table, database, connection.
List stored functions in a database.
Inputs: database, connection.
List indexes for a table.
Inputs: table (required), database, connection.
List stored procedures in a database.
Inputs: database, connection.
List tables and views in a database.
Inputs: engine, database, connection.
List triggers in a database.
Inputs: table, database, connection.
List views in a database.
Inputs: database, connection.
Read a SQL file from disk and optionally execute it (sandbox by default).
Inputs: path (required), execute, sandbox, database, +2 more.
Ping a MySQL/MariaDB connection (SELECT 1).
Inputs: connection.
SHOW FULL PROCESSLIST — active connections and queries.
Inputs: connection.
Run a parameterized SELECT query. Use ? placeholders for params.
Inputs: sql (required), limit, params, database, +1 more.
Run a SELECT and return the first row only.
Inputs: sql (required), params, database, connection.
Replication status (SHOW REPLICA/SLAVE STATUS).
Inputs: connection.
List all procedures and functions with parameter summaries.
Inputs: database, connection.
Execute a multi-statement SQL script. Use confirmed=true to commit writes.
Inputs: script (required), sandbox, database, confirmed, +2 more.
Prepend SET @var statements then run a script.
Inputs: script (required), variables (required), sandbox, database, +1 more.
Sample rows from a table.
Inputs: table (required), limit, where, params, +2 more.
Server version, vendor, capabilities, and host metadata.
Inputs: connection.
Return CREATE FUNCTION DDL.
Inputs: function (required), database, connection.
Return CREATE PROCEDURE DDL.
Inputs: procedure (required), database, connection.
Return CREATE TABLE DDL.
Inputs: table (required), database, connection.
Show grants for the current user.
Inputs: connection.
Parse a SQL script into individual statements (DELIMITER-aware). Does not execute.
Inputs: script (required), delimiter.
Key global status variables.
Inputs: pattern, connection.
Table size and row estimates from information_schema.
Inputs: table (required), database, connection.
Test a stored procedure in a sandbox transaction (ROLLBACK by default).
Inputs: procedure (required), params, sandbox, database, +5 more.
Execute a script inside a sandbox transaction (ROLLBACK by default).
Inputs: script (required), sandbox, database, delimiter, +1 more.
TRUNCATE a table (requires confirmed=true).
Inputs: table (required), database, confirmed, connection.
Parse and classify script statements without executing.
Inputs: script (required), delimiter.
Server system variables.
Inputs: pattern, connection.
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Scored across 61 tools
Most tools have clear, distinct purposes, but a few overlap (e.g., analyze_query and explain both explain queries; describe_table and explore_table have overlapping functionality). This could cause some misselection.
All tools use lowercase snake_case with a consistent verb_noun pattern (e.g., create_database, list_tables). Even single-word names like ping and count are stylistically aligned.
With 61 tools, the surface is very large. While comprehensive, it exceeds the typical well-scoped range of 3-15 tools, making it unwieldy for an agent to navigate efficiently.
The tool set covers almost all common MySQL operations: CRUD for objects, querying, scripting, procedures, replication, health checks, and schema inspection. Minor gaps exist (e.g., user management) but do not significantly hinder typical workflows.
Hosted MySQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
2,000+ MCP servers read at source level. Know what one does before you connect. Free, no key.
