MySQL MCP Server

This is a Model Context Protocol (MCP) server that provides access to a MySQL database. It allows agent to execute SQL queries against a MySQL database.

Features

Execute SQL queries against a MySQL database:
- Read data (SELECT statements)
- Create tables (CREATE TABLE statements)
- Insert data (INSERT INTO statements)
- Update data (UPDATE statements)
- Delete data (DELETE FROM statements)
Returns query results in JSON format
Configurable database connection settings
Transaction logging with unique IDs

Prerequisites

Node.js (v14 or higher)
MySQL server
MCP SDK

Installation

Clone or download this repository
Install dependencies:

cd mysql-mcp-server npm install

Build the server:

npm run build

Configuration

The MySQL MCP server uses the following environment variables for configuration:

MYSQL_HOST: MySQL server hostname (default: 'localhost')
MYSQL_PORT: MySQL server port (default: 3306)
MYSQL_USER: MySQL username (default: 'mcp101')
MYSQL_PASSWORD: MySQL password (default: '123qwe')
MYSQL_DATABASE: MySQL database name (default: 'mcpdb')

Database Setup

Create a MySQL database:

CREATE DATABASE mcpdb;

Create a MySQL user with access to the database:

CREATE USER 'mcp101'@'localhost' IDENTIFIED BY '123qwe'; GRANT ALL PRIVILEGES ON mcpdb.* TO 'mcp101'@'localhost'; FLUSH PRIVILEGES;

Create a test table with sample data:

USE mcpdb; CREATE TABLE test_users ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), email VARCHAR(100), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); INSERT INTO test_users (name, email) VALUES ('John Doe', 'john@example.com'), ('Jane Smith', 'jane@example.com'), ('Bob Johnson', 'bob@example.com');

MCP Configuration

Add the MySQL MCP server to your MCP settings file:

VSCode (Claude Extension)

File: ~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json

Change the args according your MySQL configuruation

{ "mcpServers": { "mysql-mcp-server": { "autoApprove": [], "disabled": false, "timeout": 60, "command": "node", "args": [ "/path/to/mysql-mcp-server/build/index.js" ], "env": { "MYSQL_HOST": "localhost", "MYSQL_PORT": "3306", "MYSQL_USER": "mcp101", "MYSQL_PASSWORD": "123qwe", "MYSQL_DATABASE": "mcpdb" }, "transportType": "stdio" } } }

Claude Desktop App

File: ~/Library/Application Support/Claude/claude_desktop_config.json

Usage

Once configured, you can use the MySQL MCP server in your conversations with Claude. For example:

"Can you show me all the users in the test_users table?"

Claude will use the run_sql_query tool to execute:

SELECT * FROM test_users

Available Tools

run_sql_query

Executes a read-only SQL query (SELECT statements only) against the MySQL database.

Parameters:

query: The SQL SELECT query to execute.

Example:

{ "query": "SELECT * FROM test_users" }

create_table

Creates a new table in the MySQL database.

Parameters:

query: The SQL CREATE TABLE query to execute.

Example:

{ "query": "CREATE TABLE products (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), price DECIMAL(10,2))" }

insert_data

Inserts data into a table in the MySQL database.

Parameters:

query: The SQL INSERT INTO query to execute.

Example:

{ "query": "INSERT INTO products (name, price) VALUES ('Laptop', 999.99), ('Smartphone', 499.99)" }

update_data

Updates data in a table in the MySQL database.

Parameters:

query: The SQL UPDATE query to execute.

Example:

{ "query": "UPDATE products SET price = 899.99 WHERE name = 'Laptop'" }

delete_data

Deletes data from a table in the MySQL database.

Parameters:

query: The SQL DELETE FROM query to execute.

Example:

{ "query": "DELETE FROM products WHERE name = 'Smartphone'" }

Security Considerations

Use a dedicated MySQL user with appropriate privileges for the MCP server
Consider using read-only privileges if you only need to query data
Store sensitive information like database credentials securely
All operations are logged with unique transaction IDs for auditing

Deploy Server

security – no known vulnerabilities

license - not found

quality - confirmed to work

How are these scores calculated?

Related Resources

Need Help?

Report Issue

Tools

Related MCP Servers

MCP MySQL Server
Atomzzm
A
security
A
license
A
quality
A Model Context Protocol server that enables AI models to interact with MySQL databases, providing tools for querying, executing statements, listing tables, and describing table structures.
Last updated -
5
380
MIT License
MCP MySQL Server
kevinbin
A
security
F
license
A
quality
A Model Context Protocol server that enables AI models to interact with MySQL databases through a standardized interface, providing tools for querying, executing commands, and managing database schemas.
Last updated -
7
MySQL MCP Server
caicongyang
-
security
F
license
-
quality
A Model Context Protocol server that enables AI models to interact with MySQL databases through natural language, supporting SQL queries, table creation, and schema exploration.
Last updated -
3
MCP MySQL Server
Malove86
A
security
A
license
A
quality
A server based on Model Context Protocol that enables AI models to interact with MySQL databases through a standardized interface, supporting features like query execution, table listing, and automated connection management.
Last updated -
4
20
9
MIT License

View all related MCP servers

MySQL MCP Server

MySQL MCP Server

Features

Prerequisites

Installation

Configuration

Database Setup

MCP Configuration

VSCode (Claude Extension)

Claude Desktop App

Usage

Available Tools

run_sql_query

create_table

insert_data

update_data

delete_data

Security Considerations

Related Resources

Tools

Related MCP Servers

MCP MySQL Server

MCP MySQL Server

MySQL MCP Server

MCP MySQL Server

Appeared in Searches

New MCP Servers

MCP directory API