mysql-server MCP Server
by MCP-Mirror
A TypeScript-based MCP server that provides tools for querying MySQL databases. It demonstrates core MCP concepts by providing tools for executing SQL queries and connecting to MySQL databases via environment variables.
Last updated: N/A
What is mysql-server MCP Server?
This is a Model Context Protocol (MCP) server designed to facilitate access to MySQL databases. It allows users to execute SQL queries and retrieve results through the MCP interface.
How to use mysql-server MCP Server?
To use this server, you need to configure it with the necessary MySQL connection details (host, user, password, database) as environment variables. Then, integrate the server configuration into your MCP client (e.g., Claude Desktop) by adding the server details to the claude_desktop_config.json file. You can then use the query tool to execute SQL queries.
Key features of mysql-server MCP Server
Execute SQL queries
Connect to MySQL databases via environment variables
MCP integration
TypeScript implementation
Use cases of mysql-server MCP Server
Querying data from a MySQL database
Integrating MySQL data into MCP-based applications
Automating database tasks using MCP
Building custom database interfaces
FAQ from mysql-server MCP Server
What is MCP?
What is MCP?
Model Context Protocol is a framework for building and integrating applications.
How do I configure the MySQL connection?
How do I configure the MySQL connection?
Set the MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE environment variables.
Where do I add the server config for Claude Desktop?
Where do I add the server config for Claude Desktop?
On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json. On Windows: %APPDATA%/Claude/claude_desktop_config.json
How do I debug the server?
How do I debug the server?
Use the MCP Inspector by running npm run inspector.
What tool is available?
What tool is available?
The query tool is available for executing SQL queries.