mysql-server MCP Server

@xianzong85

Repository

About mysql-server MCP Server

No overview available yet

#mysql #mcp #database #typescript

Config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Tools

Execute SQL queries

Overview

What is mysql-server MCP Server?

The mysql-server MCP Server is a TypeScript-based Model Context Protocol server that provides tools for querying MySQL databases. It connects to a MySQL server using environment variables and is intended for use with MCP-compatible hosts like Claude Desktop.

How to use mysql-server MCP Server?

Install dependencies with npm install, then build the server with npm run build. Configure the environment variables MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE in your MCP host configuration (e.g., Claude Desktop’s claude_desktop_config.json). Invoke the query tool with a SQL query string to execute queries and receive results.

Key features of mysql-server MCP Server

Executes SQL queries via the query tool
Accepts any SQL query string as input
Returns query results as output
Connects to MySQL using environment variables
Built with TypeScript for reliability
Supports debugging via the MCP Inspector

Use cases of mysql-server MCP Server

Accessing and querying a MySQL database from an AI assistant
Running read-only SQL queries to retrieve data for context
Executing write queries to modify database records
Integrating MySQL data into MCP‑enabled applications
Developing and testing database interactions with Claude Desktop

FAQ from mysql-server MCP Server

How do I install and build the server?

Run npm install to install dependencies, then npm run build to compile the TypeScript project. For development with auto-rebuild, use npm run watch.

How do I configure the MySQL connection?

Set the environment variables MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE in your MCP server configuration file (e.g., Claude Desktop’s claude_desktop_config.json).

What does the `query` tool do?

The query tool takes a SQL query string as a required parameter and returns the results of executing that query against the configured MySQL database.

How can I debug the mysql-server MCP Server?

Use the MCP Inspector by running npm run inspector. The Inspector provides a URL with debugging tools for the server, which communicates over stdio.

What runtime environment is required?

The server is a TypeScript project and requires Node.js to install dependencies and run the compiled JavaScript.

Frequently asked questions

How do I install and build the server?

Run `npm install` to install dependencies, then `npm run build` to compile the TypeScript project. For development with auto-rebuild, use `npm run watch`.

How do I configure the MySQL connection?

Set the environment variables MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE in your MCP server configuration file (e.g., Claude Desktop’s `claude_desktop_config.json`).

What does the `query` tool do?

The `query` tool takes a SQL query string as a required parameter and returns the results of executing that query against the configured MySQL database.

How can I debug the mysql-server MCP Server?

Use the MCP Inspector by running `npm run inspector`. The Inspector provides a URL with debugging tools for the server, which communicates over stdio.