Loading connector details…
MySQL MCP Server
MCPOpen Source10.0
by tqvthu-works • Data & Databases
A lightweight MCP server that lets Cursor IDE agents query and inspect MySQL databases with configurable write permissions.
Example Use Cases
- 1
Run read-only SQL queries against a MySQL database to fetch data for analysis or reporting.
- 2
Introspect and explore database schemas to discover tables, columns, and relationships.
- 3
Controlled write access to a MySQL database where insert/update/delete operations can be explicitly enabled or disabled via configuration.
Description
This project implements a Model Context Protocol (MCP) server for interacting with MySQL databases from Cursor IDE. It supports executing SQL queries (read-only by default), inspecting database schemas, and configuring whether insert/update/delete operations are allowed. The server is configured via environment variables and can be run with npm/ts-node, making it simple to integrate into development environments. Disabling write operations by default helps reduce risk when exposing databases to automated agents.
Capabilities(19 total)
Tools (14)
connect_db
Connect to a MySQL database using URL, workspace config, or direct parameters
url:stringworkspace:stringhost:stringport:numberuser:stringpassword:stringdatabase:string
query
Execute a SELECT query and return results
sql:string*params:array
execute
Execute an INSERT, UPDATE, or DELETE query
sql:string*params:array
list_tables
List all tables in the connected database
list_databases
List all accessible databases on the server
Prompts (5)
generate-select
Generate a SELECT query for a table with optional filters
tablecolumnswhereorderBylimit
generate-insert
Generate an INSERT statement template for a table
table
generate-update
Generate an UPDATE statement template for a table
tablewhere
explain-schema
Get a natural language explanation of a table structure
table
suggest-indexes
Analyze a table and suggest potential indexes for optimization
table
Quick Actions
Security
Scanned 2 month(s) agoRisk Level
MODERATE
Can modify files, state, or send data externally
Trust Score
C50/100
4/17 checks passed
Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.
Quick Stats
Service TypeMCP
Pricing ModelFree
Capabilities14 Tools / 5 Prompts / 0 Resources
Ownertqvthu-works
CategoryData & Databases
DependenciesStandalone
Tags
Read-only SQLSchema discoveryMySQLAccess controlData analysis