MySQL MCP Server
@affannahmed
About MySQL MCP Server
No overview available yet
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"MCP-Server-with-Claude-Ai": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mysql-mcp-server",
"--client",
"claude"
]
}
}
}Tools
No tools detected
Fetch the live tool list by running this server in a temporary sandbox using the button above.
Overview
What is MySQL MCP Server?
A Model Context Protocol (MCP) implementation that enables secure interaction between AI applications and MySQL databases through a controlled interface, making database exploration and analysis safer and more structured.
How to use MySQL MCP Server?
Install via pip install mysql-mcp-server or automatically through Smithery. Configure by setting environment variables for MySQL host, port, user, password, and database. Integrate with Claude Desktop by adding the server configuration to claude_desktop_config.json.
Key features of MySQL MCP Server
- List available MySQL tables as resources
- Read table contents
- Execute SQL queries with proper error handling
- Secure database access through environment variables
- Comprehensive logging
Use cases of MySQL MCP Server
- Exploring database schemas by listing tables
- Analyzing data by reading table contents
- Running controlled SQL queries through AI applications
FAQ from MySQL MCP Server
Can MySQL MCP Server be run as a standalone server?
No, it is designed as a communication protocol implementation between AI applications and MySQL databases, not as a standalone server.
What are the dependencies and runtime requirements?
The server requires Python and can be installed via pip. It expects a running MySQL database accessible via environment variable configuration.
How is database access secured?
Access is configured through environment variables for host, port, user, password, and database. The README recommends creating a dedicated MySQL user with minimal permissions and never using root credentials.
What installation methods are available?
Manual installation via pip install mysql-mcp-server or automatic installation for Claude Desktop via Smithery using npx -y @smithery/cli install mysql-mcp-server --client claude.
What data does the server access and where does it live
Frequently asked questions
Can MySQL MCP Server be run as a standalone server?
No, it is designed as a communication protocol implementation between AI applications and MySQL databases, not as a standalone server.
What are the dependencies and runtime requirements?
The server requires Python and can be installed via pip. It expects a running MySQL database accessible via environment variable configuration.
How is database access secured?
Access is configured through environment variables for host, port, user, password, and database. The README recommends creating a dedicated MySQL user with minimal permissions and never using root credentials.
What installation methods are available?
Manual installation via `pip install mysql-mcp-server` or automatic installation for Claude Desktop via Smithery using `npx -y @smithery/cli install mysql-mcp-server --client claude`.
Basic information
More AI & Agents MCP servers
LinkedIn MCP Server
stickerdanielOpen-source MCP server for LinkedIn. Give Claude and any MCP-compatible AI agent access to profiles, companies, jobs, and messages.
🔎 GPT Researcher
assafelovicAn autonomous agent that conducts deep research on any data using any LLM providers
1Panel
1Panel-dev🔥 1Panel is a modern, open-source VPS control panel — and the only one with native AI agent support. Run Ollama models, deploy OpenClaw agents, and manage your entire server stack from one clean web interface.
Web Agent Protocol
OTA-Tech-AI🌐Web Agent Protocol (WAP) - Record and replay user interactions in the browser with MCP support
Open Multi-Agent Canvas
CopilotKitThe open-source multi-agent chat interface that lets you manage multiple agents in one dynamic conversation and add MCP servers for deep research
Comments