Spring Boot MySQL Project
@angelo848
About Spring Boot MySQL Project
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
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
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.
Frequently asked questions
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.
Basic information
More Databases MCP servers
Elasticsearch/OpenSearch MCP Server
cr7258A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.
Sail MCP Server for Spark SQL
lakehqDrop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
Meilisearch MCP Server
meilisearchA Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.
Redis MCP Server
redisThe official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently
Dbhub
bytebaseZero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
Comments