@MCP-Mirror
基本情報
Mirror of
以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@davewind/mysql-mcp-server",
"mysql://user:password@localhost:port/database"
]
}
}
}Execute read-only SQL queries against the connected database
It is a Model Context Protocol server that enforces read-only access to MySQL databases, allowing LLMs to inspect database schemas and execute read-only SQL queries. It acts as an intermediary between LLMs and MySQL databases, processing requests according to the MCP specification.
Install the package globally via npm install @davewind/mysql-mcp-server -g. Then configure your MCP settings file with the command npx -y @davewind/mysql-mcp-server followed by the MySQL connection string (e.g., mysql://user:password@localhost:port/database). The server exposes a single tool query that accepts a sql parameter and executes SELECT statements within READ ONLY transactions.
No. It strictly enforces read-only access by validating SQL queries (only SELECT allowed) and running all queries in READ ONLY transactions. INSERT, UPDATE, DELETE, CREATE, ALTER, DROP operations are not supported.
Node.js v18 or higher is required to run the server.
It uses JSON-RPC over stdio, following the Model Context Protocol specification, and is compatible with any LLM system that supports the MCP standard.
The server validates SQL queries to block any non-SELECT statements, executes all queries in READ ONLY transactions, and prevents data modification or schema alteration (e.g., CREATE, ALTER, DROP).
In your MCP settings file, set the command to `npx -y @davewind/mysql-mcp-server` and provide the MySQL connection string as a command argument in the format `mysql://user:password@localhost:port/database`.
Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes
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.
Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.
Connect ClickHouse to your AI assistants.
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
コメント