MySQL

version: '3.8' services: mcp-mysql: image: lclpedro/mcp-mysql:latest container_name: mcp-mysql ports: - "3002:3002" environment: - MYSQL_DATABASE_HOST=mysql-db - MYSQL_DATABASE_PORT=3306 - MYSQL_DATABASE_USER=test - MYSQL_DATABASE_PASSWORD=root - MYSQL_DATABASE_NAME=testdb depends_on: - testdb volumes: - poetry-cache:/root/.cache/pypoetry your-database-mysql: image: mysql:8.0 environment: - MYSQL_DATABASE=couponsdbx - MYSQL_USER=test - MYSQL_PASSWORD=root - MYSQL_ROOT_PASSWORD=root ports: - "3306:3306" volumes: - mysql_data:/var/lib/mysql volumes: your-database-mysql:

- Run docker-compose up -d
- Configure MCP Server in this IDE:

{ "mcpServers": { "mysqlManaging":{ "serverUrl": "http://localhost:3002/sse" } } }

If your running only MCP server, you can run it with:

> git clone https://github.com/lclpedro/mcp-mysql.git > cd mcp-mysql > cp .env.example .env > poetry install > poetry run python main.py

- health_check
- list_tables
- get_table_schema
- execute_query
- show_indexes_table
- show_explain_query
- Fork it
- Create your feature branch (git checkout -b feature/AmazingFeature)
- Commit your changes (git commit -m 'Add some AmazingFeature')
- Push to the branch (git push origin feature/AmazingFeature)
- Open a Pull Request

Multi-database agent access (PostgreSQL, SQLite, MySQL, Oracle, SQL Server) with batch queries, pre-configured connections, and SQLGlot-enforced read-only safety

A read-only MCP server for MySQL, enabling LLMs to query live data using the CData JDBC Driver.

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite

A single-binary MCP server for MySQL, MariaDB, PostgreSQL, and SQLite

A Model Context Protocol (MCP) server that provides multi-database query execution capabilities with support for SQLite, PostgreSQL, and MySQL databases. Includes a built-in Web UI for managing database connections.

Allows Claude AI to interact directly with MySQL databases.

Update various databases (PostgreSQL, MySQL, MongoDB, SQLite) using data from CSV and Excel files.

Enables AI assistants to interact with various databases through JDBC connections.

An MCP server for retrieving data from a MariaDB database.

Access and manage MariaDB or MySQL databases using an MCP server.