MySQL MCP Server

@youngsu5582

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

youngsu5582

关于 MySQL MCP Server

暂无概览

MySQL MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MySQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

常见问题

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.

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.

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.