What operations does MySQL Database Access MCP Server support?
It supports listing databases, listing tables, describing table schemas, and executing read‑only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN).
@allizwellai
基本情報
概要はまだありません
以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"mysql-mcp-server"
],
"env": {
"MYSQL_HOST": "",
"MYSQL_PORT": "",
"MYSQL_USER": "",
"MYSQL_PASSWORD": "",
"MYSQL_DATABASE": ""
}
}
}
}ツール一覧はまだありません
この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。
上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。
MySQL Database Access MCP Server provides read-only access to MySQL databases via the Model Context Protocol. It lets you list databases, list tables, describe table schemas, and execute read-only SQL queries. This server is designed for developers and AI agents who need to inspect MySQL schemas and query data without risk of modification.
Install globally via npm (npm install -g mysql-mcp-server) or build from source, then configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) and add the server configuration to your MCP settings file. Use the provided tools: list_databases, list_tables, describe_table, and execute_query.
It supports listing databases, listing tables, describing table schemas, and executing read‑only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN).
Install from npm (`npm install -g mysql-mcp-server`) or build from source. Set environment variables for your MySQL connection (host, port, user, password, database) and add the server to your MCP settings file.
No. The server enforces read‑only access; only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed. Data modification attempts are blocked.
`MYSQL_HOST`, `MYSQL_PORT`, and `MYSQL_USER` are required. `MYSQL_PASSWORD` is optional but recommended. `MYSQL_DATABASE` is optional.
The server has a query timeout to prevent long‑running queries from consuming resources and a row limit to prevent excessive data return.
Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.
コメント