MCP.so
ログイン

MySQL MCP Server

@shreyansh-ghl

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

shreyansh-ghl

MySQL MCP Server について

概要はまだありません

MySQL MCP Server の設定

標準の設定はありません

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

リポジトリ

MySQL MCP Server のツール

1

Execute read-only SQL queries against the connected database

概要

What is MySQL MCP Server?

A Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.

How to use MySQL MCP Server?

Install globally with npm link, then run mysql-mcp-server mysql://username:password@host:3306/database. Alternatively, configure it as an MCP server in Cursor by adding the command and database URL to the MCP settings JSON.

Key features of MySQL MCP Server

  • Execute read-only SQL queries against a MySQL database.
  • Automatically discover and expose table schemas as JSON resources.
  • All queries run within a READ ONLY transaction.
  • Authentication handled via database URL credentials.
  • Integrates with Cursor’s Agentic chat for natural language querying.

Use cases of MySQL MCP Server

  • Let an LLM inspect database schemas and answer questions about table structures.
  • Run read-only analytical queries via natural language prompts in Cursor.
  • Provide safe, credential‑limited database access for AI assistants.

よくある質問

1

What protocol does MySQL MCP Server use?

It implements the Model Context Protocol (MCP) for read‑only database interaction.

2

How is authentication handled?

Authentication uses a database URL in the format `mysql://username:password@host:port/database`. Credentials can be passed via environment variables for security.

3

What runtime dependencies are required?

Node.js and npm are required. The server is installed from a Git repository using `npm install` and `npm link`.

4

Where does the data live?

Data stays in the connected MySQL database. The server only reads metadata and executes queries; it does not store data locally.

5

What are the security recommendations?

Use a MySQL user with minimal read‑only permissions, store credentials in environment variables, and never commit configuration files with passwords to version control.

コメント

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