queryLABSCO SUMMARY
Schema exposed automatically, writes impossible by construction.
The automatic schema discovery is what makes the single query tool workable — the model can see column names and types before writing SQL rather than guessing. And read-only is enforced twice, in validation and in the transaction, so the guarantee does not depend on the model behaving. Small surface, clear promise.
What it is
A deliberately narrow MySQL server. It gives a model two things — the schema of every table, and one tool for running SELECT statements — and enforces read-only at two levels: the SQL is validated to allow only SELECT, and every query runs inside a READ ONLY transaction. There is no path to INSERT, UPDATE, DELETE, CREATE, ALTER or DROP.
What you get
- A SQL query executed against the connected database, inside a READ ONLY transaction —
query - JSON schema information for each table, discovered automatically from database metadata, with column names and data types, exposed as resources rather than requiring a call
- A hard boundary: SQL validation permits SELECT only, and no data-modification or schema-modification statement can pass
- Communication over JSON-RPC on stdio, which is what a local client expects
Requirements
Node v18 or newer. The connection string is a command-line argument: npx -y @davewind/mysql-mcp-server mysql://user:password@localhost:port/database, so the credential lives in your client's config file — give it a database user with read permission only, and the enforcement is then belt and braces. It can also be installed globally with npm install @davewind/mysql-mcp-server -g.
Setup effort
One command plus credentials — npm install @davewind/mysql-mcp-server -g, then supply credentials
USE CASES
01
Asking questions of a production database safely
Connect with a read-only account and let the model query; both the SQL check and the transaction mode block anything that would write.
02
Letting a model write correct SQL first time
The table schemas are already exposed as resources, so column names and types come from the database rather than from a guess.
03
Exploring an unfamiliar schema
Read the discovered table structures to understand the shape of the data before asking anything analytical.
1 tool
Listed in project docs. Your client may show a different list.
BEFORE YOU INSTALL
What to know first
Tools you get
1 tool named in the project's documentation.
Requires
- npx on PATH
- Node.js 18 or later
INSTALLATION
Connect your client
Add the block to your client, or run the command directly.
Server setup
Configuration file
JSON
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@davewind/mysql-mcp-server",
"mysql://<YOUR_DB_USER>:<YOUR_DB_PASSWORD>@localhost:<YOUR_DB_PORT>/<YOUR_DB_NAME>"
]
}
}
}npm
TERMINAL
npm install @davewind/mysql-mcp-server -g
