广告合作
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 DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

NPILayer

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539
广告合作