Is the server read‑only by default?
Yes. Write operations (INSERT, UPDATE, DELETE) are disabled by default. They can be enabled by setting the corresponding environment variables to `true`.
MySQL MCP Server
@tqvthu-works
Basic information
About MySQL MCP Server
No overview available yet
MySQL MCP Server config
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryMySQL MCP Server tools
Tool list not available yet
This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is MySQL MCP Server?
A Model Context Protocol (MCP) server for interacting with MySQL databases directly within Cursor IDE. It allows users to execute SQL queries (read‑only by default), inspect database schemas, and optionally enable write operations through configuration.
How to use MySQL MCP Server?
Install dependencies with npm install, then create a .env file with your MySQL connection details and write‑permission flags. Add the server configuration to your project’s .cursor/mcp.json, specifying npx ts-node as the command and the required environment variables. The server can then be invoked from Cursor IDE.
Key features of MySQL MCP Server
- Execute SQL queries (read-only by default).
- Inspect database schemas.
- Configurable write permissions for INSERT, UPDATE, DELETE.
Use cases of MySQL MCP Server
- Query MySQL databases directly from Cursor IDE during development.
- Safely inspect table structures and relationships.
- Enable controlled write operations (e.g., INSERT) when explicitly allowed.
- Run ad‑hoc SELECT queries without leaving the editor.
- Manage database interactions without switching to a separate SQL client.
Frequently asked questions
How do I enable write permissions?
Set `ALLOW_INSERT_OPERATION`, `ALLOW_UPDATE_OPERATION`, and `ALLOW_DELETE_OPERATION` in your `.env` or MCP configuration to `true`. Each flag controls its respective operation independently.
What dependencies are required?
You need Node.js, the npm packages listed in `package.json` (installed via `npm install`), and `ts-node` to run the TypeScript entry point.
Where should the server be configured?
The server is configured in `.cursor/mcp.json` within your Cursor IDE project. The connection details and permission flags are passed as environment variables in the MCP server entry.
Does the server support authentication?
Connection authentication uses the MySQL credentials provided in the environment variables (`MYSQL_USER`, `MYSQL_PASS`). No additional authentication layer is described.
More Databases MCP servers
Neon MCP Server
neondatabase-labsMCP server for interacting with Neon Management API and databases
617
Postgres Mcp
crystaldbaPostgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
3.0K
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
818
PostgreSQL
modelcontextprotocolModel Context Protocol Servers
88.1K
nuzur
nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi
Comments