MCP Server Sql

🚀 mcp-server-Sql

This is a SQL service application based on Spring Boot, used to execute SQL queries and write the results to a file. As part of the Spring AI MCP (Model, Chat, Prompt) framework, this service provides functions for SQL query and update operations.

🚀 Quick Start

Configure the Database

Configure your database connection information in the application.yml file:

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

Build the Project

mvn clean package

Run the Application

java -jar target/mcp-server-Sql-1.0-SNAPSHOT.jar

✨ Features

• Execute SQL queries and write the results to a CSV file.
• Execute SQL update operations (INSERT, UPDATE, DELETE) and return the number of affected rows.
• Support custom database connection configuration.
• Integrate with the Spring AI MCP framework and can be used as an AI tool.

💻 Usage Examples

Execute a SQL Query

{
  "sql": "SELECT * FROM users",
  "outputPath": "./output/users.csv"
}

Execute a SQL Update Operation

{
  "sql": "UPDATE users SET name='John' WHERE id=1",
  "outputPath": "./output/update_result.txt"
}

🔧 Technical Details

Technology Stack

📚 Documentation

Notes

⚠️ Important Note

• Ensure that the output directory exists or you have permission to create it.
• SQL query results will be saved in CSV format.
• Update operation results will include the number of affected rows and the execution time.