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

Related MCP server: MySQL Database Access

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 host
MYSQL_PORT - MySQL server port
MYSQL_USER - MySQL username
MYSQL_PASS - MySQL password
MYSQL_DB - MySQL database name

Available MCP tools

query - execute SQL queries (only SELECT, SHOW, EXPLAIN, DESCRIBE)
table-schema - get table structure
list-tables - get list of all tables in the database

Available MCP resources

table://{name} - get data from the specified table (up to 100 rows)

This server cannot be installed

-

security - not tested

F

license - not found

-

quality - not tested

How are these scores calculated?

Resources

Need Help?

Report Issue

Related Servers

MySQL MCP Server

MySQL MCP Server

Repository

Clone the repository

add config to mcp.json

Environment Variables

Available MCP tools

Available MCP resources

Resources

Appeared in Searches

New MCP Servers

MCP directory API