Advertise
MCP.so
Sign In

MySQL MCP Server

@youngsu5582

Repository

Basic information

Category

Databases

Transports

stdio

Author

youngsu5582

About MySQL MCP Server

No overview available yet

MySQL MCP Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

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?

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. This server is a Java conversion of a Python codebase, designed for Java-based environments.

How to use MySQL MCP Server?

Install via pip install mysql-mcp-server, then set the required environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE). Use it with Claude Desktop by adding a configuration entry to claude_desktop_config.json, or run the main application as a standalone server.

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

  • Allow an AI assistant to explore database schema and content
  • Enable controlled SQL query execution from AI models
  • Safely analyze database data without full administrative access
  • Integrate MySQL data into MCP-compatible applications

Frequently asked questions

1

What is the origin of this server?

This project is a Java conversion of a Python codebase from [design-computer/mysql_mcp_server](https://github.com/designcomputer/mysql_mcp_server/tree/main), preserving the core functionality for Java environments.

2

How do I configure database credentials?

Set the environment variables `MYSQL_HOST`, `MYSQL_PORT` (optional, defaults to 3306), `MYSQL_USER`, `MYSQL_PASSWORD`, and `MYSQL_DATABASE` before running the server.

3

What are the security best practices?

Create a dedicated MySQL user with minimal permissions, never use root credentials, restrict database access to necessary operations, enable logging for audit purposes, and perform regular security reviews.

4

Can I use this with Claude Desktop?

Yes, add a configuration entry to `claude_desktop_config.json` with the `uv` command and environment variables as shown in the README.

5

What license is this server under?

It is licensed under the MIT License.

Comments

More Databases MCP servers

MySQL MCP Server

designcomputer

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

1.3K

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

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