mcp-spring-demo

This MCP server is a Spring-based demo that exposes an MCP Server connected to a PostgreSQL database for a Hospital domain. It provides multiple MCP Tools that enable CRUD operations on doctors, patients, and appointments via natural language requests. The server runs alongside a client app and an Ollama instance, enabling a complete end-to-end flow where user requests are translated into database actions. By default, the MCP Server listens on port 8080, while the MCP Client runs on port 8081 and communicates with Ollama on port 11434. To use the system, start Ollama and the database, then run the MCP Server and Client, and send tool requests via HTTP POST to /tool with a JSON message describing the desired operation.

Prerequisites:

• Java 24 or a compatible JDK
• Maven
• Docker (for Ollama and local PostgreSQL setup)
• Docker Compose (optional, for database setup with Flyway migrations)

Setup steps:

1. Install prerequisites on your system (Java, Maven, Docker).

2. Start the Ollama service (if not running separately):

docker run -d -v ollama:/root/.ollama -p 11434:11434 --name ollama ollama/ollama

3. Start the PostgreSQL database with migrations ( Flyway ) using Docker Compose if you have a docker-compose.yml configured as shown in the project:

docker compose up --build

4. Build and run the MCP Server (from the mcp-server module directory):

mvn spring-boot:run

5. Run the MCP Client (from the mcp-client module directory) if you want to test the client-side:

mvn spring-boot:run

6. Verify the server is running on http://localhost:8080 and the client on http://localhost:8081.

Notes:

• Ensure the PostgreSQL database is accessible on port 5432 and that Flyway migrations are applied to set up doctors, patients, and appointments tables.
• The Ollama service should be reachable at http://localhost:11434 unless you customize the host/port.
• If you change ports, update the client and Ollama configurations accordingly.
• Typical environment variables you might configure include database URL, username, and password for the server to connect to PostgreSQL; these would be provided via your Spring configuration (e.g., application.properties or environment variables like SPRING_DATASOURCE_URL, SPRING_DATASOURCE_USERNAME, SPRING_DATASOURCE_PASSWORD).
• If you encounter issues with the MCP Tools, check server logs for any tool registration or schema errors and verify that the database schema matches the expected models (doctors, patients, appointments).