Spring Boot MySQL Project

What is Spring Boot MySQL Project?

Spring Boot MySQL Project is an MCP server that provides database access to a MySQL database using Spring Boot, HikariCP connection pool, and Hibernate. It is designed for developers who want to interact with MySQL databases through MCP clients.

How to use Spring Boot MySQL Project?

Create a MySQL database named demo, update credentials in application.properties if needed, then build with Maven (mvn clean install) and run via mvn spring-boot:run or java -jar. For MCP client usage, configure the server with JSON providing database host, port, schema, user, and password as JVM arguments.

Key features of Spring Boot MySQL Project

• Uses Spring Boot with MySQL and HikariCP connection pool.
• Hibernate ddl-auto set to update for automatic schema changes.
• Supports MCP stdio transport.
• Configurable via application.properties and JVM arguments.
• Default connection pool size of 10.
• Runs on port 8080.

Use cases of Spring Boot MySQL Project

• Querying a MySQL database from an MCP client.
• Managing database schema automatically via Hibernate.
• Connecting to a remote MySQL database using MCP configuration.
• Debugging the MCP server with the inspector tool.

FAQ from Spring Boot MySQL Project

What is the mandatory configuration for stdio mode?

Set spring.main.web-application-type=none in application.properties to avoid a web server startup error when using stdio.

How to debug the MCP server?

Use the MCP inspector with the command: npx @modelcontextprotocol/inspector java -Dspring.ai.mcp.server.stdio=true -jar /path/to/project/target/java-mysql-mcp-0.0.1-SNAPSHOT.jar. Logs are written to ./mcp-mysql-stdio-server.log.

What are the default database credentials?

Default username is root and password is root for the demo database.

How to configure database connection in an MCP client?

Provide a JSON configuration with JVM arguments: -Ddb.hostenv=host:port, -Ddb.schema=/demo, -Ddb.user=username, -Ddb.passwordenv=password.

What is the default server port?

The default port is 8080.