Advertise
MCP.so
Sign In

MySQL MCP Server

@he426100

Repository

Basic information

Category

Databases

License

MIT license

Transports

stdio

Author

he426100

About MySQL MCP Server

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

MySQL MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mysql-mcp-server-he426100": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mysql-mcp-server",
        "."
      ]
    }
  }
}

MySQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol (MCP) server that enables secure interaction with MySQL databases. It allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.

How to use MySQL MCP Server?

Clone the repository, install dependencies with Composer, and set environment variables for database connection (DB_HOST, DB_PORT, DB_USERNAME, DB_PASSWORD, DB_DATABASE). Run as a standalone server with php bin/console or via Docker.

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

  • AI-assisted database exploration and schema discovery
  • Controlled read and query access for AI assistants
  • Secure, logged database interaction in development environments
  • Automated data retrieval and analysis workflows

Frequently asked questions

1

How does MySQL MCP Server ensure security?

It uses environment variables for credentials, recommends creating a dedicated MySQL user with minimal permissions, never uses root credentials, and enables logging for audit purposes.

2

What are the runtime requirements for MySQL MCP Server?

PHP and Composer are required. A MySQL database server must be accessible, with connection details provided via environment variables.

3

How do I run MySQL MCP Server with Docker?

Build the image with `docker build -t mysql-mcp-server .`, then run with `docker run -i --rm mysql-mcp-server --host 127.0.0.1`.

4

Is there support for query whitelisting?

The README suggests considering query whitelisting for production use but does not implement it by default.

5

Where is database connection data stored?

Connection credentials are supplied via environment variables at runtime; no persistent credential storage is provided by the server.

Comments

More Databases MCP servers

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

Advertise