mysql-mcp-server-java
If you are the rightful owner of mysql-mcp-server-java and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
Spring Boot server implementing Model Context Protocol (MCP) for MySQL database operations.
The MySQL MCP Server is a Spring Boot application designed to facilitate database operations using the Model Context Protocol (MCP). It provides a structured way to interact with a MySQL database, allowing users to execute SELECT queries, list all tables, and retrieve schema information for specific tables. This server is particularly useful for applications that require a standardized protocol for database interactions, ensuring consistency and reliability. The server is built using Maven, making it easy to manage dependencies and build processes. It is designed to be integrated with platforms like Claude Desktop or Cline, providing a seamless experience for developers looking to incorporate database functionalities into their applications.
Features
- Execute SELECT queries
- List all tables in database
- Get table schema information
Tools
query
Execute a SELECT SQL query and return results. Input:
sql(string). Returns: List of query results (truncated after 4000 characters). Note: Only SELECT queries are allowed.listAllTablesName
List all table names in the database. No input required. Returns: Comma-separated list of table names.
getTableSchema
Get schema information for a specific table. Input:
tableName(string). Returns: Comma-separated list of column information including: Column name, Data type, Nullable constraint, Default value.
