AcademyMCP serversData and reporting

mcp-server-mysql

Data and analytics teams that want an agent to answer questions from a MySQL database with controlled access.

  • Recommendedour rating
  • 2,151gitHub stars
  • MITlicence
  • 3 months agolast update
claude mcp add mcp-server-mysql -e MYSQL_HOST=127.0.0.1 -e MYSQL_PORT=3306 -e MYSQL_USER=root -e MYSQL_PASS=your_password -e MYSQL_DB=your_database -- npx -y @benborla29/mcp-server-mysql
README.md

Loading the file...

What it does

An MCP server that gives Claude and other LLMs access to a MySQL database. It can inspect schemas and run queries, and it is read-only by default, with writes enabled only through environment flags. It also supports per-database permissions, SSH tunnels, SSL/TLS and masking of sensitive data in results.

Use cases

  1. 01Ask questions about a table and get query results
  2. 02Inspect a schema before writing a report query
  3. 03Query a remote database through an SSH tunnel

Questions about
mcp-server-mysql.

What is mcp-server-mysql used for?

Data and analytics teams that want an agent to answer questions from a MySQL database with controlled access. An MCP server that gives Claude and other LLMs access to a MySQL database. It can inspect schemas and run queries, and it is read-only by default, with writes enabled only through environment flags. It also supports per-database permissions, SSH tunnels, SSL/TLS and masking of sensitive data in results.

How do I install mcp-server-mysql?

Run this in your terminal: claude mcp add mcp-server-mysql -e MYSQL_HOST=127.0.0.1 -e MYSQL_PORT=3306 -e MYSQL_USER=root -e MYSQL_PASS=your_password -e MYSQL_DB=your_database -- npx -y @benborla29/mcp-server-mysql

Is mcp-server-mysql open source?

Yes. The code is on GitHub (benborla/mcp-server-mysql) under the MIT licence.

Is mcp-server-mysql safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.