Rdb MCP Server

🚀 rdb-mcp-server

An experimental MCP server based on Spring AI for low-level SQL operations, using JDBC with stdio as the transport mechanism. The project prototype is generated by AI.

🚀 Quick Start

✨ Features

• Database Support: Supports MySQL, PostgreSQL, and SQLite.
• Multiple Usage Modes: Can be run independently or integrated with MCP clients.
• Variety of Tools: Provides different SQL execution tools.

📦 Installation

Download the JAR file from the GitHub Releases page.

Configuration

Available environment variables:

• DB_URL: Database connection URL (Default: jdbc:sqlite:./sqlite.db)
• DB_USER: Database username
• DB_PASSWORD: Database password
• API_PASSWORD: Password for non-read-only operations (Optional)
• LOG_FILE: Log file path (Optional, Default: ./rdb-mcp-server.log)

Run in Standalone Mode

java -jar x.x.x.jar

MCP Client Integration

Command Line Interface

{
  "mcpServers": {
    "rdb_mcp_server": {
      "command": "java",
      "args": [
        "-jar",
        "/path/to/jar"
      ],
      "env": {
        "DB_URL": "jdbc:mysql://localhost:3306/your_database",
        "DB_USER": "your_username",
        "DB_PASSWORD": "your_password",
        "API_PASSWORD": "your_password_here",
        "LOG_FILE": "./rdb-mcp-server.log"
      },
      "disabled": false,
      "autoApprove": []
    }
  }
}

Cursor

{
  "mcpServers": {
    "rdb_mcp_server": {
      "command": "java",
      "args": [
        "-jar",
        "/path/to/jar"
      ],
      "env": {
        "DB_URL": "jdbc:mysql://localhost:3306/your_database",
        "DB_USER": "your_username",
        "DB_PASSWORD": "your_password",
        "API_PASSWORD": "your_password_here",
        "LOG_FILE": "./rdb-mcp-server.log"
      }
    }
  }
}

💻 Usage Examples

Basic Usage

The following are the available tools and their usage descriptions:

executeQuery

Execute read-only SQL queries. No authentication is required.

⚠️ Important Note

This tool is vulnerable to SQL injection attacks.

executeRawSql

Execute raw SQL statements. A password is required for non-read-only operations.

executePreparedSql

Execute parameterized SQL operations using PreparedStatement.

🔧 Technical Details

To add support for other relational databases, add the appropriate database driver to the pom.xml file and rebuild the project.

📄 License

No license information provided in the original document.