Mysql Database Server

An MCP service that provides MySQL database operations, supporting AI models to interact with MySQL databases through a standardized interface, including tools for querying, executing, and table management.

Database Developer tools #MySQL service #Database operations #AI interaction Local .TypeScript

rating : 2 points

downloads : 11

update time : 2025-04-23

What is MCP MySQL Server?

MCP MySQL Server is a middleware service that provides AI models with the ability to interact with MySQL databases. Through a standardized interface, AI can perform database operations such as querying and modifying data structures without directly handling database connection details.

How to use MCP MySQL Server?

You can set up the server through the installation package or manual installation, and then perform database operations through simple commands or API calls. The server supports multiple connection configuration methods, including environment variables and direct parameter passing.

Use cases

Suitable for scenarios where AI models need to access structured data, such as data analysis, content management, and user information query. It is particularly suitable for quickly integrating database functions in development environments such as Cursor IDE.

Main features

Database connection managementSupports multiple connection configuration methods, including URL, environment variables, and direct parameters, and automatically manages the connection lifecycle.

Secure query executionProvides query and execute tools to handle query and modification operations respectively, and supports parameterized queries to prevent SQL injection.

Data table structure managementCan perform structure change operations such as viewing table structures, creating new tables, and adding columns.

Workspace integrationAutomatically detects the project workspace and uses the.env file in the project to configure the database connection.

Advantages and limitations

Advantages

The standardized interface simplifies the interaction between AI and databases

Multiple security protection mechanisms prevent SQL injection

Flexible connection configuration options

Automated connection management reduces the risk of resource leakage

Limitations

Currently only supports MySQL databases

Requires a Node.js environment to run

Limited ability to handle complex transactions

How to use

Install the server

You can automatically install it through Smithery or manually clone and build the project.

Configure the database connection

Set DATABASE_URL or individual parameters in the.env file, or directly connect through the connect_db tool.

Add the server in Cursor IDE

Add the MCP server through the command panel and specify the name and startup command.

Usage examples

Query user informationRetrieve user data with a specific ID from the user table

Create a product tableCreate a new product data table for the e-commerce system

Frequently Asked Questions

How to solve the connection failure problem?

Which MySQL versions are supported?

Does it support transaction operations?

Related resources

GitHub repository

Project source code and issue tracking

Smithery installation page

One-click installation service

Model Context Protocol documentation

Official documentation of the MCP protocol

🚀 @enemyrr/mcp-mysql-server

A Model Context Protocol server that provides MySQL database operations. This server enables AI models to interact with MySQL databases through a standardized interface.

🚀 Quick Start

📦 Installation and Setup in Cursor IDE

Installation via Smithery

To automatically install the MySQL database server for Claude Desktop via Smithery:

npx -y @smithery/cli install @enemyrr/mcp-mysql-server --client claude

Manual Installation

Clone and build the project:

git clone https://github.com/enemyrr/mcp-mysql-server.git
cd mcp-mysql-server
npm install
npm run build

Add the server in Cursor IDE settings:
- Open the command palette (Cmd/Ctrl + Shift + P).
- Search for "MCP: Add Server".
- Fill in the information:
  - Name: mysql
  - Type: command
  - Command: node /absolute/path/to/mcp-mysql-server/build/index.js

⚠️ Important Note

Replace /absolute/path/to/ with the actual path where you cloned and built the project.

🛠️ Database Configuration

You can configure the database connection in three ways:

Database URL in .env (recommended):

DATABASE_URL = mysql://username:password@host:port/database

Set DB parameters individually:

DB_HOST = host
DB_USER = username
DB_PASSWORD = password
DB_NAME = database
DB_PORT = port

Connect directly through a tool and provide detailed information.

💻 Usage Examples

Available Tools

connect_db: Used to establish a database connection.
query: Execute queries, supporting prepared statements.
execute: Execute non-query operations.
list_tables: List all tables.
get_columns: Get column information for a specified table.
execute_query: Execute custom queries.
insert_data: Insert data.
update_data: Update data.
delete_data: Delete data.

✨ Features

Support multiple connection methods (URL, workspace, direct).
Provide secure connection handling and automatic cleanup.
Support prepared statements to prevent SQL injection.
Provide Schema management tools.
Have comprehensive error handling and validation.
Support TypeScript.
Automatically detect the workspace.

🔒 Security

Use prepared statements to prevent SQL injection.
Support secure password handling through environment variables.
Validate queries before execution.
Automatically close connections.

🐞 Error Handling

The server provides detailed error information for the following situations:

Connection failure.
Invalid queries or parameters.
Missing configuration.
Database errors.
Schema validation errors.

🤝 Contribution

Contributions are welcome! Please feel free to submit a Pull Request to https://github.com/enemyrr/mcp-mysql-server

📄 License

MIT

Featured MCP Services

Notion Api MCP

Certified

A Python-based MCP Server that provides advanced to-do list management and content organization functions through the Notion API, enabling seamless integration between AI models and Notion.

The GitLab MCP server is a project based on the Model Context Protocol that provides a comprehensive toolset for interacting with GitLab accounts, including code review, merge request management, CI/CD configuration, and other functions.

TypeScript

4.3 points

Markdownify MCP

Markdownify is a multi-functional file conversion service that supports converting multiple formats such as PDFs, images, audio, and web page content into Markdown format.

TypeScript

1.7K

5 points

Duckduckgo MCP Server

Certified

The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.

Framelink Figma MCP Server is a server that provides access to Figma design data for AI programming tools (such as Cursor). By simplifying the Figma API response, it helps AI more accurately achieve one - click conversion from design to code.

UnityMCP is a Unity editor plugin that implements the Model Context Protocol (MCP), providing seamless integration between Unity and AI assistants, including real - time state monitoring, remote command execution, and log functions.

567

5 points

Minimax MCP Server

The MiniMax Model Context Protocol (MCP) is an official server that supports interaction with powerful text-to-speech, video/image generation APIs, and is suitable for various client tools such as Claude Desktop and Cursor.

A Gmail automatic authentication MCP server designed for Claude Desktop, supporting Gmail management through natural language interaction, including complete functions such as sending emails, label management, and batch operations.

TypeScript

284

4.5 points

Zhiqi Future, Your AI Solution Think Tank

English 简体中文繁體中文にほんご