MySQL MCP Server
@kioyong
About MySQL MCP Server
No overview available yet
Config
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryTools
3Execute a SELECT SQL query and return results
List all table names in the database
Get schema information for a specific table
Overview
What is MySQL MCP Server?
A Spring Boot server implementing the Model Context Protocol (MCP) for MySQL database operations. It lets AI assistants like Claude Desktop or Cline execute SELECT queries, list tables, and retrieve table schemas.
How to use MySQL MCP Server?
Build the project with mvn install, then add the provided JSON configuration to your MCP server config file, specifying the path to the JAR and the MySQL JDBC URL via the SPRING_DATASOURCE_URL environment variable.
Key features of MySQL MCP Server
- Execute SELECT SQL queries (results truncated at 4000 characters)
- List all table names in the connected database
- Retrieve schema information (name, type, nullable, default) for a specific table
Use cases of MySQL MCP Server
- Allow an AI assistant to read data from a MySQL database.
- Let users explore database tables and schemas through natural language.
- Integrate MySQL querying into MCP‑compatible tools like Claude Desktop.
FAQ from MySQL MCP Server
What SQL operations does it support?
Only SELECT queries are allowed; write operations are not supported.
How do I configure the database connection?
Set the SPRING_DATASOURCE_URL environment variable to a JDBC URL in the format jdbc:mysql://username:password@host:port/database.
How is the server built?
It uses Maven: run mvn install to build the JAR file.
What license is this server under?
The MIT License.
Frequently asked questions
What SQL operations does it support?
Only SELECT queries are allowed; write operations are not supported.
How do I configure the database connection?
Set the `SPRING_DATASOURCE_URL` environment variable to a JDBC URL in the format `jdbc:mysql://username:password@host:port/database`.
How is the server built?
It uses Maven: run `mvn install` to build the JAR file.
What license is this server under?
The MIT License.
Basic information
More Databases MCP servers
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
MySQL MCP Server
designcomputerA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
Elasticsearch/OpenSearch MCP Server
cr7258A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.
nuzur
nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi
Sqlite
modelcontextprotocolModel Context Protocol Servers
Comments