MySQL MCP Server
A Model Context Protocol (MCP) implementation that enables secure interaction with MySQL databases. This server component facilitates communication between AI applications (hosts/clients) and MySQL databases, making database exploration and analysis safer and more structured through a controlled interface.
Note: MySQL MCP Server supports both standard input/output (STDIO) and Streamable HTTP (SSE) transport modes. The SSE mode is recommended for remote/self-hosted deployments.
Deployment options
- Hosted — Fronteir AI runs the server for you; no local setup required.
- Local — Smithery installs and runs the server on your own machine.
Features
- List available MySQL tables as resources
- Read table contents
- Execute SQL queries with proper error handling
- Multi-database mode (Optional
MYSQL_DATABASE) - SSE/HTTP transport support (
MCP_TRANSPORT=sse) - SSH Tunneling support
- Comprehensive schema information
- Table data sampling
- Secure database access through environment variables
- Comprehensive logging
