mysql_mcp_server

A server that enables secure interaction with MySQL databases via the MCP protocol.

MCPDataOpen source

Type: MCP
Open source: Yes
GitHub Stars: ★ 1.3k
Source: mcp-github
Repository: github.com/designcomputer/mysql_mcp_server

Overview

MySQL MCP Server is a Model Context Protocol (MCP) implementation that allows AI applications to securely interact with MySQL databases. This server component facilitates communication between AI applications and MySQL databases through a controlled interface, making database exploration and analysis safer and more structured. Supports standard input/output (STDIO) and streaming HTTP (SSE) transmission modes. Suitable for AI applications requiring access to and manipulation of MySQL databases.

Capabilities

▪List available MySQL tables as resources
▪Read table contents
▪Execute SQL queries and handle errors
▪Multi-database mode support
▪SSH tunnel support
▪Comprehensive schema information

Use cases

AI application data queryingSecure access to database contentMetadata analysis of database structureRemote or self-hosted deployment

Setup

Requires: API KeyNode 环境

pip install mysql-mcp-server or use Smithery for automatic installation: npx -y @smithery/cli install designcomputer/mysql-mcp-server --client claude

This information was compiled by AI from public sources and may contain inaccuracies — please refer to the source.

FAQ

How do I configure environment variables?

Set variables like MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD in the .env file.

What transmission modes are supported?

Supports STDIO and SSE transmission modes.

Related skills

OpenMetadata

OpenMetadata is an open data context layer that provides trustworthy data context and business semantics for AI.

MCP数据治理元数据管理

XHS-Downloader

A link extraction and content collection tool for Xiaohongshu, supporting multiple download and information extraction features.

MCP

unstract

LLM-based tool for extracting structured data from unstructured documents, supporting API deployment and ETL workflows.

MCP

FinanceToolkit

Transparent and efficient financial analysis tool supporting various financial products and metrics.

MCP金融数据分析

deeplake

Deeplake is a data runtime designed for AI agents, offering a serverless multimodal data lake.

Agent SkillAI 数据库多模态数据

skills

Provides real-time market data and options analytics for AI agents.

Agent Skill