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
Xata MCP Server
The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.
Sqlite
modelcontextprotocolModel Context Protocol Servers
88.1K
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
818
Local YDB MCP
astandrikSafety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.
4
Neon MCP Server
neondatabaseMCP server for interacting with Neon Management API and databases
617
Comments