mcpField
M
mcp-server-Sql

mcp-server-Sql

Local
github.com/cherry-SCDatabases2Updated 82w ago
Repository

About mcp-server-Sql

A Spring Boot SQL service built with Spring AI MCP for use as an AI tool. It runs queries and saves results as CSV, or performs data updates and reports affected rows.

Key features

  1. 01Run SQL queries and save CSV
  2. 02Execute INSERT, UPDATE, DELETE
  3. 03Return affected row counts
  4. 04Configure database connections

Use cases

  1. 01Export query results to CSV
  2. 02Run database updates through an AI tool

MCP support

Integrates Spring AI MCP to expose SQL query and update capabilities as an AI tool.

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

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

mcp-server-Sql

项目介绍

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

功能特性

  • 执行SQL查询并将结果写入CSV文件
  • 执行SQL更新操作（INSERT, UPDATE, DELETE）并返回影响的行数
  • 支持自定义数据库连接配置
  • 集成Spring AI MCP框架，可作为AI工具使用

技术栈

  • Java 17
  • Spring Boot 3.4.3
  • Spring AI 1.0.0-M6
  • MySQL 8.0
  • HikariCP 连接池
  • Lombok

快速开始

配置数据库

在application.yml文件中配置您的数据库连接信息：

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/your_database?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
    username: your_username
    password: your_password
构建项目
mvn clean package
运行应用
java -jar target/mcp-server-Sql-1.0-SNAPSHOT.jar

使用示例

执行SQL查询
{
  "sql": "SELECT * FROM users",
  "outputPath": "./output/users.csv"
}
执行SQL更新操作
{
  "sql": "UPDATE users SET name='John' WHERE id=1",
  "outputPath": "./output/update_result.txt"
}

注意事项

  • 确保输出目录存在或有权限创建
  • SQL查询结果将以CSV格式保存
  • 更新操作结果将包含影响的行数和执行时间

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.