mcp-server-Sql

What is mcp-server-Sql?

mcp-server-Sql is a Spring Boot application that executes SQL queries and updates, writing results to CSV or text files, and integrates with the Spring AI MCP (Model, Chat, Prompt) framework for use as an AI tool.

How to use mcp-server-Sql?

Configure your MySQL database connection in application.yml, build the project with mvn clean package, and run the JAR with java -jar target/mcp-server-Sql-1.0-SNAPSHOT.jar. Send JSON payloads with sql and outputPath to execute queries or updates.

Key features of mcp-server-Sql

• Execute SQL queries and save results as CSV files
• Execute UPDATE, INSERT, DELETE and return affected row count
• Custom database connection via configuration
• Integrates with Spring AI MCP framework as a tool

Use cases of mcp-server-Sql

• Query a database and export results to a CSV file
• Perform batch updates and log affected rows to a text file
• Provide SQL operations as a tool for AI agents within MCP

FAQ from mcp-server-Sql

What are the runtime requirements?

Java 17, Spring Boot 3.4.3, and a MySQL 8.0 database are required.

How do I configure the database connection?

Set spring.datasource.url, username, and password in application.yml.

What format are query results saved in?

Query results are saved as CSV files; update results are saved as text files with the affected row count.

How do I execute a specific SQL command?

Send a JSON payload with the sql key containing your statement and an outputPath key for the output file location.

Is authentication or transport security handled?

The README does not mention authentication or transport security—only database credentials in configuration.