%20--%3e%3cdefs%3e%3cstyle%3e%20.st0%20{%20fill:%20%23061b40;%20}%20.st1%20{%20fill:%20%23306af1;%20}%20.st2%20{%20fill:%20%235ce5cf;%20}%20%3c/style%3e%3c/defs%3e%3cg%3e%3cpath%20class='st0'%20d='M55,10.5h9v3h-9v9h12V7.5h-12v3ZM64,19.5h-6v-3h6v3Z'/%3e%3cpolygon%20class='st0'%20points='69%2016.5%2078%2016.5%2078%2019.5%2069%2019.5%2069%2022.5%2081%2022.5%2081%2013.5%2072%2013.5%2072%2010.5%2081%2010.5%2081%207.5%2069%207.5%2069%2016.5'/%3e%3cpolygon%20class='st0'%20points='95%2010.5%2095%207.5%2083%207.5%2083%2022.5%2095%2022.5%2095%2019.5%2086%2019.5%2086%2016.5%2095%2016.5%2095%2013.5%2086%2013.5%2086%2010.5%2095%2010.5'/%3e%3cpath%20class='st0'%20d='M40,1.5v21h11.6l1.4-1.4v-7.6h0c0,0-1.4-1.5-1.4-1.5l1.4-1.4V2.9l-1.4-1.4h-11.6ZM50,19.5h-7v-6h7v6ZM50,10.5h-7v-6h7v6Z'/%3e%3c/g%3e%3cpath%20class='st1'%20d='M23.1,24L14.7,4.8l-4.9,11.2h3.8l-1.8,4H3.3L12.1,0H2C.9,0,0,.9,0,2v20c0,1.1.9,2,2,2h21.1Z'/%3e%3cpath%20class='st2'%20d='M34,0h-16.8l10.6,24h6.2c1.1,0,2-.9,2-2V2C36,.9,35.1,0,34,0ZM32.5,20h-4V4h4v16Z'/%3e%3c/svg%3e)
MCP Server Mamp Mysql
An MCP server that provides access to MySQL databases, supporting table structure listing, read-only query execution, and secure connection management.
rating : 2 points
downloads : 22
What is the MySQL MCP Server?
The MySQL MCP Server is a server based on the Model Context Protocol (MCP) that allows users to access MySQL databases via a secure connection. You can easily view database tables and their structures and execute read-only SQL queries.How to use the MySQL MCP Server?
After installing and configuring the server, you can perform database operations through the MCP interface, such as listing tables and querying data.Application scenarios
Suitable for developers and enterprise users who need to quickly access MySQL databases, especially in application scenarios where efficient database management is required in a production environment.Main features
List database tablesDisplay all tables and their structural information in the specified database.
Execute read-only SQL queriesSupport the execution of read-only SQL statements and return query results.
Connection pool managementOptimize database connections through a connection pool to improve performance and stability.
Advantages and limitations
Advantages
Easy to use and can be quickly mastered without complex configuration.
Support read-only SQL queries to ensure data security.
Built-in connection pool function to improve concurrent processing capabilities.
Limitations
Only support read-only SQL queries and cannot perform write operations.
Performance may need further optimization in high-concurrency scenarios.
How to use
Clone the project repository
Use Git to clone this GitHub repository to your local environment.
%20--%3e%3cdefs%3e%3cstyle%3e%20.st0%20{%20fill:%20%230080ff;%20}%20%3c/style%3e%3c/defs%3e%3cpath%20class='st0'%20d='M16.2,11.1c.4.5.4,1.2,0,1.8l-4.7,7.1h-3.8l5.3-8L7.6,4h3.8l4.7,7.1Z'/%3e%3c/svg%3e)
Install dependencies
Run npm to install the required Node.js dependencies.
Build the project
Build the project to generate a runnable binary file.
Start the server
Start the MCP server after configuring environment variables.
Usage examples
List all tablesShow how to get the names and structures of all tables in the database.
Execute a read-only SQL queryDemonstrate how to execute a simple read-only SQL query.
Frequently Asked Questions
How to set MySQL connection information?
Does it support write operations?
How to monitor the server status?
Related resources
Official documentation
Detailed user manuals and technical documents.
GitHub repository
Source code and the latest version release address.
Community forum
A communication platform for developers.
Featured MCP Services
Gitlab MCP Server
Certified
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
85
4.3 points
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.
Python
140
4.5 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.
Python
829
4.3 points
Figma Context MCP
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.
TypeScript
6.7K
4.5 points
Unity
Certified
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.
C#
564
5 points
Gmail MCP Server
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
282
4.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.
Python
753
4.8 points