MCP Server Mysql

An MCP server for MySQL databases based on NodeJS, providing database schema checking and SQL query execution capabilities for LLMs.

Database Developer tools #MySQL Connection #Database Query #LLM Integration #Permission Management Local .TypeScript

rating : 4 points

downloads : 471

update time : 2025-04-28

What is the MCP MySQL Server?

The MCP MySQL Server is a tool that allows large language models (LLMs) to access MySQL databases through SQL queries. It provides visual display of table structures, secure SQL execution, and multi - database support.

How to use the MCP MySQL Server?

Through simple configuration, you can integrate the MCP MySQL Server into your development environment and allow LLMs to easily execute SQL queries.

Applicable Scenarios

Suitable for application scenarios that require quick access to MySQL databases and generation of SQL queries, such as data analysis and automated report generation.

Main Features

Table Structure VisualizationAutomatically parse database table structures, including column names, data types, indexes and other information.

Secure SQL ExecutionPrevent SQL injection through prepared statements and support transaction management.

Multi - database SupportSupport multi - database mode when no database is specified, and the database needs to be explicitly specified.

Permission ManagementSupport table - level permission control, allowing more fine - grained permission allocation.

Advantages and Limitations

Advantages

Simplify the interaction between LLMs and MySQL databases.

Support multiple permission management and security features.

Be compatible with multi - database environments.

Have real - time performance monitoring and debugging capabilities.

Limitations

Require appropriate MySQL permission settings.

Some advanced features may require additional configuration.

Write operations are disabled by default and need to be manually enabled.

How to Use

Install the MCP MySQL Server

Install the server via npm, pnpm or MCP Get.

Configure Environment Variables

Set MySQL connection information, such as host, port, username and password.

Start the Server

Run the server to listen for MySQL connections.

Usage Examples

Example 1: Query User DataQuery user table data through the MCP MySQL Server.

Example 2: Update Product PriceUpdate the price of a specific product.

Frequently Asked Questions

How to ensure data security?

How to enable write operations?

Does it support multi - database mode?

Related Resources

Official Documentation

Detailed installation and configuration guide.

GitHub Code Repository

Open - source code repository.

MCP Get

Centralized registration platform for MCP servers.

🚀 MCP Server - MySQL Version

This guide provides detailed instructions on installing and using the MCP Server - MySQL version, helping you quickly get started with this powerful server.

🚀 Quick Start

📦 Installation

Using npm

You can easily install mcp-server-mysql using the following command:

npm install -y @benborla29/mcp-server-mysql dotenv

Using pnpm

Alternatively, you can use pnpm:

pnpm add -g @benborla29/mcp-server-mysql dotenv

Using Docker (Recommended)

If you prefer using Docker, you can refer to the following commands:

Pull the image:

docker pull benborla29/mcp-server-mysql:latest

Start the container:

docker run -d --name mcp-mysql -p 3001:3001 -e MYSQL_HOST=127.0.0.1 -e MYSQL_PORT=3306 -e MYSQL_USER=root -e MYSQL_PASS=your_password -e MYSQL_DB=your_database benborla29/mcp-server-mysql:latest

⚙️ Configuration

Create a Configuration File

Create a .env file in the root directory of your project with the following content:

MYSQL_HOST=127.0.0.1
MYSQL_PORT=3306
MYSQL_USER=root
MYSQL_PASS=your_password
MYSQL_DB=your_database

Start the Server

Run the following command to start the MCP server:

node index.js

✨ Features

Support for Multiple Database Operations: Including querying, inserting, updating, and deleting.
High Availability Design: Built - in connection pool to improve performance and stability.
Security Protection: Provides access control and logging functions.

📚 Documentation

🤔 Frequently Asked Questions

1. Connection Issues

Ensure that the MySQL service is started and running properly.
Check that the provided credentials are correct.
Verify the SSL/TLS configuration if it is enabled.
Try to connect using a MySQL client tool to confirm the access rights.

2. Performance Issues

Adjust the connection pool size parameter.
Set an appropriate query timeout value.
Enable the query cache function if necessary.
Monitor the server resource utilization.

3. Security Restrictions

Review the rate - limiting configuration.
Check the query whitelist and blacklist settings.
Ensure that the SSL/TLS configuration is correct.
Confirm that the MySQL user has appropriate permissions.

🤝 Contribution Guide

Community contributions are welcome! Please visit the GitHub repository to submit a Pull Request.

Set Up the Development Environment

Clone the repository:

git clone https://github.com/benborla/mcp-server-mysql.git

Install the dependencies:

pnpm install

Build the project:

pnpm run build

Run the tests:

pnpm test

🗺️ Project Roadmap

We are actively developing the MCP server. The following are the planned feature updates for the future:

Support for advanced query functions with prepared statements.
Provide more powerful security features.
Implement performance optimization.
Enhance monitoring functions.
Expand schema information support.

If you want to contribute or discuss new features, please submit Issues or Pull Requests in the GitHub repository.

We hope this guide will help you successfully install and use the MCP Server - MySQL version. If you have any questions, feel free to contact the project maintainers!