designcomputer avatar

MySQL

designcomputer/mysql_mcp_server

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 tools

Public 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

Tests PyPI - Downloads AgentAudit Safe

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).

View the full README on GitHub

Details

Repository
github.com/designcomputer/mysql_mcp_server
Category
Databases

Related Databases MCP servers

View all
1clickhouse avatarClickHouseclickhouse/mcp-clickhouseOfficial ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.903stars
2alexander-zuev avatarSupabasealexander-zuev/supabase-mcp-serverQuery MCP enables end-to-end management of Supabase via chat interface: read & write query executions, management API support, automatic migration versioning, a821stars
3timescale avatarTiger MCPtimescale/tiger-cliProvides programmatic access to Tiger Cloud services, databases, and documentation.127stars
4wgong avatarWgong Sqlite Mcp Serverwgong/sqlite-mcp-serverExplore, query, and inspect SQLite databases with ease. List tables, preview results, and view det…1stars
5rosch100 avatarMcp Encrypted Sqliterosch100/mcp-encrypted-sqliteMCP server for encrypted SQLite databases (SQLCipher 4) - Works with MoneyMoney, KeePass and more0stars
6supabase avatarSupabasesupabase/mcpMCP server for interacting with the Supabase platform0stars