M

Mysql MCP

The MySQL MCP Server is an MCP server implementation integrated with a MySQL database, providing secure database access capabilities for LLMs, supporting read and write operations, and security controls.
2.5 points
22

What is the MySQL MCP Server?

The MySQL MCP Server is a database middleware specifically designed for large language models (LLMs). It allows LLMs to securely access and operate on MySQL databases while providing comprehensive security controls and performance monitoring.

How to use the MySQL MCP Server?

You can easily configure and start the MySQL MCP Server through the Dive Desktop graphical interface or manually start it using command - line tools. After the server starts, the LLM can interact with the database through the standardized MCP protocol.

Use cases

Suitable for scenarios where LLMs need to access structured database data, such as data analysis, content management, user information query, etc. It is particularly suitable for enterprise knowledge bases and intelligent customer service systems.

Main features

Read operationsSupports executing SELECT queries, viewing table structures, and database schema information.
Write operationsSupports data modification operations such as INSERT/UPDATE/DELETE and provides transaction support.
Security featuresBuilt - in query length limit, result size limit, and performance monitoring to ensure database security.
Dive integrationSeamlessly integrated with Dive Desktop, providing a graphical configuration interface.

Advantages and limitations

Advantages
Provides a secure database access layer to prevent SQL injection
Automatic transaction management to ensure data consistency
Perfectly integrated with the LLM ecosystem, simplifying the development process
Detailed performance monitoring and logging
Limitations
Only supports MySQL databases
The number of query result rows is limited to 1000
Requires a Node.js 18+ runtime environment

How to use

Install the MySQL MCP Server
Globally install the MySQL MCP Server package using npm.
Configure Dive Desktop
Add MCP server configuration in Dive Desktop.
Start the server
After saving the configuration, Dive Desktop will automatically start the MCP server.

Usage examples

Query user dataQuery active user information from the user table
Add a new orderInsert a new record into the order table
View the table structureUnderstand the structure information of a specific table

Frequently Asked Questions

How to solve the problem of failed database connection?
Why does my query return an empty result?
How to improve query performance?

Related resources

Dive Desktop GitHub repository
The official code repository of Dive Desktop
MySQL official documentation
The official documentation of the MySQL database
MCP protocol specification
The specification document of the Model Context Protocol
Installation
Copy the following command to your Client for configuration
{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@kevinwatt/mysql-mcp"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "",
        "MYSQL_DB": "your_database"
      }
    }
  }
}
Note: Your key is sensitive information, do not share it with anyone.
S
Search1api
The Search1API MCP Server is a server based on the Model Context Protocol (MCP), providing search and crawling functions, and supporting multiple search services and tools.
TypeScript
336
4 points
D
Duckduckgo MCP Server
Certified
The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.
Python
823
4.3 points
M
MCP Alchemy
Certified
MCP Alchemy is a tool that connects Claude Desktop to multiple databases, supporting SQL queries, database structure analysis, and data report generation.
Python
317
4.2 points
P
Postgresql MCP
A PostgreSQL database MCP service based on the FastMCP library, providing CRUD operations, schema inspection, and custom SQL query functions for specified tables.
Python
105
4 points
M
MCP Scan
MCP-Scan is a security scanning tool for MCP servers, used to detect common security vulnerabilities such as prompt injection, tool poisoning, and cross-domain escalation.
Python
609
5 points
A
Agentic Radar
Agentic Radar is a security scanning tool for analyzing and assessing agentic systems, helping developers, researchers, and security experts understand the workflows of agentic systems and identify potential vulnerabilities.
Python
548
5 points
C
Cloudflare
Changesets is a build tool for managing versions and releases in multi - package or single - package repositories.
TypeScript
1.5K
5 points
E
Edgeone Pages MCP Server
EdgeOne Pages MCP is a service that quickly deploys HTML content to EdgeOne Pages via the MCP protocol and obtains a public URL
TypeScript
250
4.8 points
Featured MCP Services
M
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
D
Duckduckgo MCP Server
Certified
The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.
Python
823
4.3 points
G
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
79
4.3 points
N
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
130
4.5 points
U
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#
554
5 points
F
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.6K
4.5 points
C
Context7
Context7 MCP is a service that provides real-time, version-specific documentation and code examples for AI programming assistants. It is directly integrated into prompts through the Model Context Protocol to solve the problem of LLMs using outdated information.
TypeScript
5.2K
4.7 points
M
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
745
4.8 points
AIbase
Zhiqi Future, Your AI Solution Think Tank
© 2025AIbase