Chapter 2 : Data MCP Servers

Build Data MCP Servers

• Build MCP Servers with No-code and Customize & Extend to complete your use case.
• Use MCP Servers via AI Editors like Cursor or Cline

Getting Started

Please undertake below tutorial first , if you have not:

• Build Your First App
  • With Focus on Backend Spring-Java

MCP Server - Spring Java

info

• MCP Server - Spring Java is built along with Backend spring-java.
• Project Location in downloaded dir is at e.g.
  • EmGenDir_JohnDoe_WS_51069\WS_51069\mcp\spring-java\emmcp

Run Builds and Explore

tip

MCP Layer Connects to API Layer, REST or GraphQL. So please configure and run destination API Layer first.

• APIs Run Builds and Explore
  • Please execute & run backend/spring-java/emapi project:
  • Compile, Deploy, Run.
  • Refer to Tutorial Section 2-5-A : Backend Spring Java

MCP Server Project Build

• Open Maven Project in IDEA IntelliJ
• Maven Goal: package
• Note down jar location, e.g.:
  • C:\Users\JohnDoe\Downloads\EmGenDir_JohnDoe_WS_51123\WS_51123\mcp\spring-java\emmcp\app\mcprest\target\mcprest-1.0-SNAPSHOT.jar

Configure and Run

Configure MCP Server

• Please follow Readme in downloaded dir:
  • mcp\spring-java\README-MCP-Server.md

MCP Server For REST

Configure MCP Server For REST

• Please follow Readme in downloaded dir:
  • mcp\spring-java\README-mcprest.md

tip

• Refer to some general screenshots on MCP Server configuring in below also:
  • Tutorial 7 : AI Based Development
    • Chapter 2 : EasyManage Builder MCP Server
      • Cursor

• MCP Added

• MCP Tools

Use MCP Server For REST with Cursor Chat

• Ask Questions and get data insights
• MCP Server For REST Run by following below sections in Readme README-mcprest.md:
  • Available Tools
  • Sample Chats

Example Chat Usage

Get Schema Details

easymanage get all api schema

get details for entity Product 

get schema for ViewAll

General

easymanage get table data from Product table in table format

Get Paged Data With Queried & Sorted

• To get queried and sorted data as per parameters as pages
• With Flexible SQL-Like Querying

easymanage get table data as pages from Product table queried as "productId > 2" sorted by "productName desc" with 1 page size 3

• Please note parameters for above Tool call were constructed properly by AI:

MCP Server For GraphQL

Configure MCP Server For GraphQL

• Please follow Readme in downloaded dir:

  • mcp\spring-java\README-mcpgraphql.md

• See sample screens For REST which, are similar

Use MCP Server For GraphQL with Cursor Chat

• Ask Questions and get data insights

• MCP Server For GraphQL Run by following below sections in Readme README-mcpgraphql.md:

  • Available Tools
  • Sample Chats

• See sample screens For REST which, are similar

Configure Multiple MCP Servers (Optional)

• Please follow Readme in downloaded dir:
  • mcp\spring-java\README-MCP-Server.md
• Look For Section: How to setup multiple MCP Servers