java-spring-mysql-mcp-server

java-spring-mysql-mcp-server

0
databases

The project is a Spring Boot application integrated with MySQL and HikariCP, enabling efficient database connectivity. It supports running on Model Context Protocol (MCP) clients with customizable configurations.

Spring Boot MySQL Project

This is a Spring Boot project configured with MySQL and HikariCP connection pool.

Prerequisites

  • Java 17 or later
  • Maven 3.6 or later
  • MySQL 8.0 or later

Setup

  1. Create a MySQL database named demo.
  2. Update the database credentials in src/main/resources/application.properties if they differ from the defaults.

Running the Application

  1. Build the project.
  2. Run the application.

Configuration

  • Server port: 8080
  • HikariCP connection pool size: 10
  • Hibernate ddl-auto: update

Usage on MCP clients

db.hostenv value is the host and port of the database server, e.g., localhost:3306.