@dave-wind
Basic information
mcp model-context-protocol mysql cursor n8n
Add this server to your MCP-compatible client using the configuration below.
{
"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.
Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
An official Qdrant Model Context Protocol (MCP) server implementation
Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
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
Comments