@dave-wind
基本情報
mcp model-context-protocol mysql cursor n8n
以下の設定を使って、このサーバーを 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
@davewind/mysql-mcp-server is a Model Context Protocol server that provides read-only access to MySQL databases. It enables LLMs to inspect database schemas and execute read-only SQL queries using a secure, MCP-compliant interface.
Install the package globally via npm install @davewind/mysql-mcp-server -g, then configure your MCP settings file with the server command and a MySQL connection string. The server is invoked with npx -y @davewind/mysql-mcp-server mysql://user:password@localhost:port/database.
query tool that accepts and executes SELECT statementsOnly SELECT statements are allowed. The server enforces read-only access through SQL validation and executes all queries within READ ONLY transactions. Modification commands (INSERT, UPDATE, DELETE) and schema changes (CREATE, ALTER, DROP) are not supported.
Node.js version 18 or higher is required. The server runs as an MCP tool and communicates via stdio using JSON-RPC.
The server connects to an external MySQL database specified by the user in the connection string. No data is stored locally; all queries operate directly on the target database.
Authentication is handled through the MySQL connection string passed at startup, which includes username and password (e.g., `mysql://user:password@localhost:port/database`).
No. The security model explicitly prevents any schema modification (CREATE, ALTER, DROP) as well as data modification (INSERT, UPDATE, DELETE). Only read-only SELECT queries are permitted.
A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.
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
A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
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.
MCP server for interacting with Neon Management API and databases
コメント