@davewind/mysql-mcp-server

What is @davewind/mysql-mcp-server?

@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.

How to use @davewind/mysql-mcp-server?

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.

Key features of @davewind/mysql-mcp-server

• Read-only database access with SQL validation and READ ONLY transactions
• Automatic schema discovery for all tables in the database
• Single query tool that accepts and executes SELECT statements
• Full compliance with the Model Context Protocol specification
• Simple configuration requiring only a connection string

Use cases of @davewind/mysql-mcp-server

• Enabling LLMs to answer questions about database structure and contents
• Allowing AI assistants to generate reports from read-only data
• Providing safe, auditable database introspection for MCP-compatible agents
• Building tools that let language models explore relational data without risk of modification

FAQ from @davewind/mysql-mcp-server

What SQL operations does @davewind/mysql-mcp-server support?

Only 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.

What are the runtime requirements?

Node.js version 18 or higher is required. The server runs as an MCP tool and communicates via stdio using JSON-RPC.

Where does the data live?

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.

How does authentication work?

Authentication is handled through the MySQL connection string passed at startup, which includes username and password (e.g., mysql://user:password@localhost:port/database).

Can this server modify the database schema?

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.