What are the runtime requirements?
Java 17, Spring Boot 3.4.3, and a MySQL 8.0 database are required.
MCP Server Sql
@cherry-SC
Basic information
About MCP Server Sql
这是一个基于Spring Boot的SQL服务应用，用于执行SQL查询并将结果写入文件。该服务作为Spring AI MCP（Model, Chat, Prompt）框架的一部分，提供了SQL查询和更新操作的功能。
MCP Server Sql config
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryMCP Server Sql tools
Tool list not available yet
This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
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
Frequently asked questions
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.
More Databases MCP servers
Multi Database MCP Server
FreePeakA powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.
397
MySQL MCP Server
designcomputerA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
1.3K
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
818
MotherDuck's DuckDB MCP Server
motherduckdbLocal MCP server for DuckDB and MotherDuck
498
Neon MCP Server
neondatabase-labsMCP server for interacting with Neon Management API and databases
617
Comments