Spring Boot MySQL Project

Name: Spring Boot MySQL Project
Author: angelo848

@angelo848

代码仓库

关于 Spring Boot MySQL Project

暂无概览

基本信息

分类

数据库

运行时

java

传输方式

stdio

发布者

angelo848

配置

暂无标准配置

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

代码仓库

工具

未检测到工具

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

概览

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.