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
基本情報
MCP Server Sql について
这是一个基于Spring Boot的SQL服务应用，用于执行SQL查询并将结果写入文件。该服务作为Spring AI MCP（Model, Chat, Prompt）框架的一部分，提供了SQL查询和更新操作的功能。
MCP Server Sql の設定
MCP Server Sql のツール
ツール一覧はまだありません
この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。
ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。
概要
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
よくある質問
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.
「データベース」の他のコンテンツ
MotherDuck's DuckDB MCP Server
motherduckdbLocal MCP server for DuckDB and MotherDuck
498
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
818
MySQL MCP Server
designcomputerA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
1.3K
Redis
modelcontextprotocolModel Context Protocol Servers
88.2K
Sail MCP Server for Spark SQL
lakehqDrop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
3.1K
コメント