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.
Click on "Install 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-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.
Complete MCP server for MySQL and MariaDB. 50 tools covering the full lifecycle of database administration, development, and operations.
cp .env.example .env
# Edit .env with your settings
docker compose up -dMCP server: http://localhost:4000/mcp
Health: http://localhost:4000/health
MariaDB: localhost:3307
Related MCP server: MySQL MCP Server Pro
Variable | Default | Description |
|
| MySQL host |
|
| MySQL port |
|
| MySQL user |
|
| MySQL password |
|
| Default database |
|
| Root password (Docker only) |
|
|
|
|
| HTTP server port |
|
| Host port for MySQL container |
|
| Host port for MCP container |
{
"mcpServers": {
"mysql": {
"url": "http://localhost:4000/mcp"
}
}
}{
"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"
}
}
}
}Tool | Description |
| List all databases |
| Create a database |
| Drop a database |
| Show CREATE DATABASE statement |
| Server version, uptime, config |
Tool | Description |
| List tables with stats |
| Column definitions (SHOW FULL COLUMNS) |
| Full CREATE TABLE DDL |
| Create table from SQL |
| Drop one or more tables |
| Remove all rows |
| Rename / move between databases |
| Size, rows, engine, collation |
Tool | Description |
| ALTER TABLE ADD COLUMN |
| ALTER TABLE DROP COLUMN |
| ALTER TABLE MODIFY COLUMN |
| RENAME COLUMN (MySQL 8+/MariaDB 10.5+) |
Tool | Description |
| All indexes with cardinality |
| Create BTREE/HASH/FULLTEXT/SPATIAL index |
| Drop an index |
Tool | Description |
| List FK constraints |
| Add FK with ON UPDATE/DELETE rules |
| Drop FK constraint |
Tool | Description |
| SELECT with pagination and parameterized values |
| Execute any SQL (DDL/DML) |
| Insert single row |
| Update rows by WHERE condition |
| Delete rows by WHERE condition |
| Batch insert up to 5000 rows |
| Atomic multi-statement transaction |
Tool | Description |
| List all MySQL accounts |
| Create user with password |
| Drop user |
| Grant privileges |
| Revoke privileges |
| Show GRANT statements |
| Change user password |
Tool | Description |
| Global/session status variables |
| Global/session config variables |
| Active connections and queries |
| Kill connection or query |
| Last statement warnings |
| Reload grant tables |
Tool | Description |
| EXPLAIN with traditional/JSON/TREE format |
| Update optimizer statistics |
| Defragment and reclaim space |
| Check for corruption |
| Repair MyISAM/ARCHIVE tables |
Tool | Description |
| Export as JSON, CSV, or SQL INSERTs |
| Execute SQL script |
npm install
npm run dev # Development with auto-reload
npm run build # Production buildEdit 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 installed
Unclaimed servers have limited discoverability.
If you are the server author, to access and configure the admin panel.
GibsonAI MCP server: manage your databases with natural language
Query PostgreSQL databases in plain English — LLM-generated, safety-validated SQL.
Manage projects, tasks, time tracking, and team collaboration through natural language.
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/jordiHikefoxter/mcp-mysql'
If you have feedback or need assistance with the MCP directory API, please join our Discord server