广告合作
MCP.so
登录

MCP Server Sql

@cherry-SC

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

cherry-SC

关于 MCP Server Sql

这是一个基于Spring Boot的SQL服务应用，用于执行SQL查询并将结果写入文件。该服务作为Spring AI MCP（Model, Chat, Prompt）框架的一部分，提供了SQL查询和更新操作的功能。

#mcp-server-sql#sql-service#spring-boot

MCP Server Sql 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

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

常见问题

1

What are the runtime requirements?

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

2

How do I configure the database connection?

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

3

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.

4

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.

5

Is authentication or transport security handled?

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

评论

数据库 分类下的更多 MCP 服务器

Elasticsearch MCP Server

elastic

685

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569
广告合作