MySQL MCP Server
The MySQL MCP Server lets your AI connect directly to a MySQL database: inspect schemas, run SELECTs, and analyse data — no exporting to CSV and pasting it into the chat.
The everyday uses are "what does this table look like and what indexes does it have?" and ad-hoc data exploration. You stop switching to a DB client just to confirm a column name while writing code.
Install / Connect
# No npm package — install from source.
# See the repo's README for the exact command:
# https://github.com/benborla/mcp-server-mysqlFollow the official README; env and args vary per server.
Why use it
Good for: backend engineers and analysts who query often but don't want to open a client every time.
Before connecting: **use a read-only account for production**. This server supports read-only mode — turn it on. A wrong SQL statement against production isn't reversible.
Similar / alternative servers
XcodeBuildMCP
A Model Context Protocol (MCP) server and CLI that provides tools for agent use
codebase-memory-mcp
High-performance code intelligence MCP server. Indexes codebases into a persiste
serena
A powerful MCP toolkit for coding, providing semantic retrieval and editing capa
unity-mcp
Unity MCP acts as a bridge between AI assistants and your Unity Editor. Give you
Frequently Asked Questions
Can I lock it to read-only?
Yes. The server has a read-only setting, and you should also use a read-only database account — two layers.
How does it differ from the PostgreSQL server?
Different protocol and dialect, same purpose. Both are listed on this site; pick whichever matches your database.