Name: mysql-server MCP Server
Author: xianzong85

mysql-server MCP Server について

概要はまだありません

#mysql #mcp #database #typescript

基本情報

カテゴリ

データベース

トランスポート

stdio

公開者

xianzong85

設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

ツール

1

Execute SQL queries

概要

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.

mysql-server MCP Server