Building an AI-Powered MCP Server with Spring AI: Querying Product Data without APIs
LocalAbout Building an AI-Powered MCP Server with Spring AI: Querying Product Data without APIs
A Spring AI and Spring Boot example for developers building MCP services and clients. It shows how an AI chat client can query product-table data through domain entities rather than a dedicated REST API.
Key features
- 01Expose product data through MCP
- 02Use JPA and PostgreSQL
- 03Include Spring AI client setup
Use cases
- 01Query product details from a chat client
- 02Study a Spring Boot MCP server implementation
MCP support
The MCP server exposes the Product entity to AI chat clients through Spring AI; the example also covers configuring a Spring AI MCP client.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMEBuilding an AI-Powered MCP Server with Spring AI: Querying Product Data without APIs
With the rise of AI assistants and chat-based user interfaces, there’s a growing need to expose backend data in a way that’s more intuitive and context-aware than traditional REST APIs. Enter Spring AI and the Model Context Protocol (MCP) — a powerful combination that enables AI agents to interact directly with domain models without custom APIs.
In this blog post, we’ll walk through how to set up an MCP server using Spring AI to query a simple Product table, which stores details like product name, code, quantity, and price. Instead of creating an API endpoint, we’ll leverage Spring AI’s MCP support to expose the product entity to an AI chat client.
Let’s dive in.
Step 1: Setting Up Your Spring Boot MCP Server
spring-boot-starter-data-jpaspring-ai-starter-mcp-server-webfluxpostgresql
Step 2: Setting Up Your Spring Boot MCP Client
spring-ai-starter-mcp-client-webfluxspring-ai-starter-model-ollamaspring-boot-starter-web
Use Spring Initializr or your IDE.
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.