mcp-server-mysql
by yuru-sha
Model Context Protocol Server for MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Last updated: N/A
What is mcp-server-mysql?
This is a Model Context Protocol (MCP) server specifically designed for MySQL databases. It allows Large Language Models (LLMs) to interact with and understand MySQL database schemas and execute read-only queries, facilitating data-driven applications and insights.
How to use mcp-server-mysql?
The server can be installed using Docker, NPM, or Smithery. After installation, configure your application (e.g., Claude Desktop) to connect to the server using the provided connection URL format. Ensure the MySQL server is accessible and that the connection details are correct.
Key features of mcp-server-mysql
Read-only access to MySQL databases
Schema inspection capabilities
Safe query execution within READ ONLY transactions
Docker support
Use cases of mcp-server-mysql
Enabling LLMs to understand and query data in MySQL databases
Building data-driven applications powered by LLMs
Generating insights from MySQL data using LLMs
Automating database schema analysis and documentation
FAQ from mcp-server-mysql
What is the purpose of this server?
What is the purpose of this server?
It allows LLMs to interact with MySQL databases in a read-only manner.
How do I install the server?
How do I install the server?
You can install it using Docker, NPM, or Smithery.
What kind of access does the server provide?
What kind of access does the server provide?
It provides read-only access to protect the database.
How do I configure the server for Claude Desktop?
How do I configure the server for Claude Desktop?
Add the provided configuration snippet to your claude_desktop_config.json file.
What is the connection URL format?
What is the connection URL format?
The connection URL format is mysql://[user][:password]@host[:port]/database.