SQL-QueryDSL-query-mcp-server

divaxi/SQL-QueryDSL-query-mcp-server

3.2

If you are the rightful owner of SQL-QueryDSL-query-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

The SQL QueryDSL MCP Server is a schema-based server that processes JSON query objects from AI clients to filter and return records from a SQL database.

Tools
1
Resources
0
Prompts
0

SQL QueryDSL MCP Server

This project is a schema-based QueryDSL MCP Server (STDIO) that accepts JSON query objects from an AI client and returns filtered records from a SQL database.
The repository includes an example implementation using the Employees model as a reference.

🚀 Requirements

  • Java SDK
  • Maven
  • A SQL Database (PostgreSQL recommended)

📘 Getting Started

1. Clone the repository

git clone https://github.com/divaxi/SQL-QueryDSL-query-mcp-server.git
cd <REPO_FOLDER>

2. Adjust the code to match your database

Modify the schema, configuration, and Spring Boot properties, etc... to fit your own SQL database.

3. Build the project

mvn clean package -DskipTests

4. Run or test with MCP Inspector

You can validate your MCP server using

💬 Using with ChatGPT / Claude Desktop / VS Code

add this following JSON.

{
  "mcpServers": {
    "server-name": {
      "command": "java",
      "args": [
        "-Dspring.ai.mcp.server.stdio=true",
        "-jar",
        "/ABSOLUTE/PATH/TO/PARENT/FOLDER/ai-0.0.1-SNAPSHOT.jar"
      ]
    }
  }
}