mysql-server MCP Server

What is mysql-server MCP Server?

An MCP server that provides tools for querying MySQL databases. It connects to MySQL databases via environment variables and executes SQL queries. Designed for use with MCP clients like Claude Desktop.

How to use mysql-server MCP Server?

Set MySQL connection details as environment variables (MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) and configure the server in your MCP client's configuration file. The server exposes a single tool called query that takes a SQL string parameter and returns query results.

Key features of mysql-server MCP Server

• Executes SQL queries against MySQL databases
• Single query tool with required SQL string parameter
• Configured via environment variables
• Supports debugging with MCP Inspector
• Written in TypeScript

Use cases of mysql-server MCP Server

• Query a MySQL database through an MCP client like Claude Desktop
• Run ad-hoc SELECT or write queries on demand
• Explore database schema and content interactively

FAQ from mysql-server MCP Server

What environment variables does the server require?

MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE must be set.

How do I configure the server for Claude Desktop?

Add a mysql entry to the mcpServers object in the Claude Desktop config file, specifying the server path and all environment variables.

How can I debug the server?

Use the MCP Inspector by running npm run inspector, which provides a URL with debugging tools.

What transport does the server use?

The README indicates the server communicates over stdio.

Does the server support any authentication method?

It uses password-based MySQL authentication via the MYSQL_PASSWORD environment variable.