MySQL MCP Server
JSON →Integrates with MySQL databases to provide secure database access for LLMs.
Install
npx @kevinwatt/mysql-mcp Tools · 4
- mysql_query Execute read-only SELECT queries with limits on query length (4096 chars), result rows (1000), and timeout (30s)
- mysql_execute Execute data modification operations (INSERT/UPDATE/DELETE) with optional parameters, returns affected rows and last insert ID, with automatic transaction handling
- list_tables List all tables in the current database
- describe_table Show the structure of a specified table
Environment variables
MYSQL_HOSTMYSQL_PORT
Links
★ 18 GitHub stars