MySQL MCP Server

@tqvthu-works

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

tqvthu-works

MySQL MCP Server について

概要はまだありません

MySQL MCP Server の設定

標準の設定はありません

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

リポジトリ

MySQL MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MySQL MCP Server?

A Model Context Protocol (MCP) server for interacting with MySQL databases directly within Cursor IDE. It allows users to execute SQL queries (read‑only by default), inspect database schemas, and optionally enable write operations through configuration.

How to use MySQL MCP Server?

Install dependencies with npm install, then create a .env file with your MySQL connection details and write‑permission flags. Add the server configuration to your project’s .cursor/mcp.json, specifying npx ts-node as the command and the required environment variables. The server can then be invoked from Cursor IDE.

Key features of MySQL MCP Server

Execute SQL queries (read-only by default).
Inspect database schemas.
Configurable write permissions for INSERT, UPDATE, DELETE.

Use cases of MySQL MCP Server

Query MySQL databases directly from Cursor IDE during development.
Safely inspect table structures and relationships.
Enable controlled write operations (e.g., INSERT) when explicitly allowed.
Run ad‑hoc SELECT queries without leaving the editor.
Manage database interactions without switching to a separate SQL client.

よくある質問

Is the server read‑only by default?

Yes. Write operations (INSERT, UPDATE, DELETE) are disabled by default. They can be enabled by setting the corresponding environment variables to `true`.

How do I enable write permissions?

Set `ALLOW_INSERT_OPERATION`, `ALLOW_UPDATE_OPERATION`, and `ALLOW_DELETE_OPERATION` in your `.env` or MCP configuration to `true`. Each flag controls its respective operation independently.

What dependencies are required?

You need Node.js, the npm packages listed in `package.json` (installed via `npm install`), and `ts-node` to run the TypeScript entry point.

Where should the server be configured?

The server is configured in `.cursor/mcp.json` within your Cursor IDE project. The connection details and permission flags are passed as environment variables in the MCP server entry.

Does the server support authentication?

Connection authentication uses the MySQL credentials provided in the environment variables (`MYSQL_USER`, `MYSQL_PASS`). No additional authentication layer is described.

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

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note