Provides tools for querying MySQL databases with read-only capabilities, allowing access to table data, schema information, and database structure through SQL queries (SELECT, SHOW, EXPLAIN, DESCRIBE).
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 Servershow me the top 10 customers by total orders"
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 MCP Server
This project implements an MCP (Model Context Protocol) server for working with MySQL database.
Repository
This project is available on GitHub: https://github.com/vitalyDV/mysql-mcp
Clone the repository
Related MCP server: MySQL Database Access
add config to mcp.json
Environment Variables
MYSQL_HOST- MySQL server hostMYSQL_PORT- MySQL server portMYSQL_USER- MySQL usernameMYSQL_PASS- MySQL passwordMYSQL_DB- MySQL database name
Available MCP tools
query- execute SQL queries (only SELECT, SHOW, EXPLAIN, DESCRIBE)table-schema- get table structurelist-tables- get list of all tables in the database
Available MCP resources
table://{name}- get data from the specified table (up to 100 rows)