mysql-mcp-server-java

mysql-mcp-server-java

6

The MySQL MCP Server is a Spring Boot server designed to implement Model Context Protocol (MCP) for MySQL, offering functionalities like executing SELECT queries, listing database tables, and retrieving table schema information. It is built with Maven and operates under the MIT License.

MySQL MCP Server

Spring Boot server implementing Model Context Protocol (MCP) for MySQL database operations.

Features

  • Execute SELECT queries
  • List all tables in database
  • Get table schema information

API

Tools

  • query

    • Execute a SELECT SQL query and return results
    • Note: Only SELECT queries are allowed
  • listAllTablesName

    • List all table names in the database
  • getTableSchema

    • Get schema information for a specific table

License

This MCP server is licensed under the MIT License.