mysql-server MCP Server

@xianzong85

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

xianzong85

mysql-server MCP Server について

概要はまだありません

#mysql #mcp #database #typescript

mysql-server MCP Server の設定

標準の設定はありません

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

リポジトリ

mysql-server MCP Server のツール

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

よくある質問

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.

「データベース」の他のコンテンツ

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.