Overview
what is MySQL MCP Server?
MySQL MCP Server is an implementation of a Model Context Protocol (MCP) server designed for interacting with MySQL databases.
how to use MySQL MCP Server?
To use the MySQL MCP Server, clone the repository from GitHub, install the necessary dependencies, and configure the mcp.json file with your MySQL database credentials.
key features of MySQL MCP Server?
- Execute SQL queries (only SELECT, SHOW, EXPLAIN, DESCRIBE)
- Retrieve table structures and list all tables in the database
- Access data from specified tables (up to 100 rows)
use cases of MySQL MCP Server?
- Simplifying database interactions for applications using MySQL.
- Providing a structured way to execute queries and retrieve data.
- Facilitating database management tasks through MCP tools.
FAQ from MySQL MCP Server?
- What is the purpose of the MySQL MCP Server?
It serves as a protocol server to facilitate interactions with MySQL databases using the Model Context Protocol.
- How do I configure the server?
You need to add your MySQL connection details in the
mcp.jsonconfiguration file.
- What types of queries can I execute?
You can execute SELECT, SHOW, EXPLAIN, and DESCRIBE queries.
Content
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
git clone https://github.com/vitalyDV/mysql-mcp.git
cd mysql-mcp
npm install
add config to mcp.json
{
"mcpServers": {
"mysql_mcp_readonly": {
"command": "node",
"args": [
"./mysql-mcp/index.js"
],
"env": {
"MYSQL_HOST": "127.0.0.1",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASS": "",
"MYSQL_DB": "db",
}
}
}
}
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)
No tools information available.
