Which integrations are available for this server?

Provides tools for managing MariaDB databases, covering the full lifecycle of database administration, development, and operations including schema management, data operations, user management, monitoring, and query analysis. Provides tools for managing MySQL databases, covering the full lifecycle of database administration, development, and operations including schema management, data operations, user management, monitoring, and query analysis.

How do I use mysql-mcp-server?

1. Click on "Deploy Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@mysql-mcp-server list all tables in database mydb" 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.

MySQL/MariaDB MCP Server

Complete MCP server for MySQL and MariaDB. 50 tools covering the full lifecycle of database administration, development, and operations.

Quick Start (Docker)

cp .env.example .env
# Edit .env with your settings
docker compose up -d

MCP server: http://localhost:4000/mcp Health: http://localhost:4000/health MariaDB: localhost:3307

Related MCP server: MySQL MCP Server Pro

Configuration

Variable	Default	Description
`MYSQL_HOST`	`localhost`	MySQL host
`MYSQL_PORT`	`3306`	MySQL port
`MYSQL_USER`	`mcpuser`	MySQL user
`MYSQL_PASSWORD`	`mcppassword`	MySQL password
`MYSQL_DATABASE`	`mcpdb`	Default database
`MYSQL_ROOT_PASSWORD`	`rootpassword`	Root password (Docker only)
`TRANSPORT`	`stdio`	`stdio` or `http`
`PORT`	`3000`	HTTP server port
`MYSQL_EXPOSE_PORT`	`3306`	Host port for MySQL container
`MCP_PORT`	`3000`	Host port for MCP container

Claude Desktop / Claude Code Integration

HTTP Transport

{
  "mcpServers": {
    "mysql": {
      "url": "http://localhost:4000/mcp"
    }
  }
}

stdio Transport (local)

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": ["/path/to/mcp-mysql/dist/index.js"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "password"
      }
    }
  }
}

Tools (50 total)

Databases (5)

Tool	Description
`mysql_list_databases`	List all databases
`mysql_create_database`	Create a database
`mysql_drop_database`	Drop a database
`mysql_show_create_database`	Show CREATE DATABASE statement
`mysql_server_info`	Server version, uptime, config

Tables (8)

Tool	Description
`mysql_list_tables`	List tables with stats
`mysql_describe_table`	Column definitions (SHOW FULL COLUMNS)
`mysql_show_create_table`	Full CREATE TABLE DDL
`mysql_create_table`	Create table from SQL
`mysql_drop_table`	Drop one or more tables
`mysql_truncate_table`	Remove all rows
`mysql_rename_table`	Rename / move between databases
`mysql_get_table_stats`	Size, rows, engine, collation

Columns (4)

Tool	Description
`mysql_add_column`	ALTER TABLE ADD COLUMN
`mysql_drop_column`	ALTER TABLE DROP COLUMN
`mysql_modify_column`	ALTER TABLE MODIFY COLUMN
`mysql_rename_column`	RENAME COLUMN (MySQL 8+/MariaDB 10.5+)

Indexes (3)

Tool	Description
`mysql_list_indexes`	All indexes with cardinality
`mysql_create_index`	Create BTREE/HASH/FULLTEXT/SPATIAL index
`mysql_drop_index`	Drop an index

Foreign Keys (3)

Tool	Description
`mysql_list_foreign_keys`	List FK constraints
`mysql_add_foreign_key`	Add FK with ON UPDATE/DELETE rules
`mysql_drop_foreign_key`	Drop FK constraint

Data Operations (7)

Tool	Description
`mysql_query`	SELECT with pagination and parameterized values
`mysql_execute`	Execute any SQL (DDL/DML)
`mysql_insert`	Insert single row
`mysql_update`	Update rows by WHERE condition
`mysql_delete`	Delete rows by WHERE condition
`mysql_bulk_insert`	Batch insert up to 5000 rows
`mysql_execute_transaction`	Atomic multi-statement transaction

User Management (7)

Tool	Description
`mysql_list_users`	List all MySQL accounts
`mysql_create_user`	Create user with password
`mysql_drop_user`	Drop user
`mysql_grant_privileges`	Grant privileges
`mysql_revoke_privileges`	Revoke privileges
`mysql_show_grants`	Show GRANT statements
`mysql_change_password`	Change user password

Server Monitoring (6)

Tool	Description
`mysql_show_status`	Global/session status variables
`mysql_show_variables`	Global/session config variables
`mysql_show_processlist`	Active connections and queries
`mysql_kill_process`	Kill connection or query
`mysql_show_warnings`	Last statement warnings
`mysql_flush_privileges`	Reload grant tables

Query Analysis & Maintenance (5)

Tool	Description
`mysql_explain_query`	EXPLAIN with traditional/JSON/TREE format
`mysql_analyze_table`	Update optimizer statistics
`mysql_optimize_table`	Defragment and reclaim space
`mysql_check_table`	Check for corruption
`mysql_repair_table`	Repair MyISAM/ARCHIVE tables

Export & Import (2)

Tool	Description
`mysql_export_table`	Export as JSON, CSV, or SQL INSERTs
`mysql_import_sql`	Execute SQL script

Development

npm install
npm run dev       # Development with auto-reload
npm run build     # Production build

Switch to MySQL 8.4

Edit docker-compose.yml:

mysql:
  image: mysql:8.4   # was mariadb:11.4
  environment:
    MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD:-rootpassword}
    MYSQL_DATABASE: ${MYSQL_DATABASE:-mcpdb}
    MYSQL_USER: ${MYSQL_USER:-mcpuser}
    MYSQL_PASSWORD: ${MYSQL_PASSWORD:-mcppassword}

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive

ResponsivenessNo issues

Resources

Need Help?

Related Servers

Related MCP Connectors

Cayra Decision IntelligenceOAuth
io.cayra
Ask questions in plain language, get answers from your business database. No SQL required.
Databases Search
1
Vibe BI MCPOAuth
ai.vibe-bi
Ask business questions in plain English. Get instant answers from your database, no SQL needed.
Databases Search
2
AI2SQLOAuth
io.ai2sql
Generate, fix, explain and run read-only SQL on PostgreSQL, MySQL and SQL Server
Databases Developer Tools
1
Dot - AI Data AnalystOAuth
io.github.zurferr
Ask data questions in natural language. Get SQL, insights, and charts from your databases.
Search Databases Data Visualization
2

Related MCP Servers

MySQL MCP Server
Databases Shell Access
pickstar-2002
A
license
B
quality
D
maintenance
Enables AI assistants to manage MySQL databases through natural language commands. Supports database operations, table management, data queries, and import/export functionality with built-in security features.
Updated a year ago (2025-08-21 12:48 UTC)
15
19 npm
1
MIT
MySQL MCP Server Pro
Databases Developer Tools Code Analysis
xucodeboy
A
license
B
quality
D
maintenance
Provides comprehensive MySQL database operations including CRUD, performance optimization, health analysis, and anomaly detection. Supports multiple connection modes, OAuth2.0 authentication, and role-based permissions for database management through natural language.
Updated a year ago (2025-10-21 00:30 UTC)
9
1
MIT
MySQL MCP Server
Databases Developer Tools RAG Systems
QiPanTanYi
A
license
Not graded
quality
D
maintenance
Enables natural language database operations on MySQL databases with AI integration, supporting CRUD operations, schema inspection, and audit logging with built-in security features including SQL injection protection and permission controls.
Updated a year ago (2025-11-06 07:17 UTC)
362 npm
MIT
mysql-mcp-server
Databases Monitoring
lrferr
A
license
C
quality
D
maintenance
Enables monitoring and administration of MySQL databases through natural language, supporting multiple simultaneous connections, health checks, and full DDL/DML/DCL operations.
Updated a year ago (2025-09-23 12:40 UTC)
39
26 npm
MIT