MCP Servers / database / MySQL MCP Server

MySQL MCP Server

JSON →
none18database

Integrates with MySQL databases to provide secure database access for LLMs.

Install
How to run this server
[ { "cmd": "npx @kevinwatt/mysql-mcp", "imports": [] } ]
server path: mysql-mcp-server-3
Tools
What this server exposes
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
Configuration
Environment & auth
authnone
envMYSQL_HOST
envMYSQL_PORT
Resources
MySQL MCP Server — MCP Server · libregistry