
MySQL
The MySQL MCP Server enables AI applications to securely interact with MySQL databases through the Model Context Protocol, providing tools to list tables, read table contents, and execute SQL queries with proper error handling and comprehensive logging. It solves the problem of safely connecting large language models to database systems by establishing a controlled, structured interface that abstracts direct database access through environment variable configuration. The server integrates with AI platforms like Claude Desktop and Visual Studio Code, allowing AI agents to explore and analyze databases without exposing raw database credentials or uncontrolled query execution.
- GitHub stars
- 1.3K
- tools
- 3
- last updated
- Mar 7, 2026
Tools
3 toolsPublic tool metadata for what this MCP can expose to an agent.
execute_sqlExecutes any standard SQL query.
Executes any standard SQL query.
No parameter schema in public metadata yet.
get_schema_infoProvides detailed metadata about database structures.
Provides detailed metadata about database structures.
No parameter schema in public metadata yet.
get_table_sampleFetches a representative sample of data.
Fetches a representative sample of data.
No parameter schema in public metadata yet.
Sponsors
Readme
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 — install from PyPI and run the server on your own machine (see Installation).
Details
- Repository
- github.com/designcomputer/mysql_mcp_server
- Category
- Databases