rdb-mcp-server

Experimental MCP server based on Spring AI for low-level SQL operations using JDBC.

Uses stdio as the transport mechanism.

Project prototype is AI generated.

Supported Databases

- MySQL - PostgreSQL - SQLite

Requirements

- Java 17 or later

How to Use

Installation

Download the JAR 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)

Running Standalone

java -jar x.x.x.jar

MCP Client Integration

Cline

{
  "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"
      }
    }
  }
}

Available Tools

executeQuery

Executes read-only SQL queries. No authentication required.

Vulnerable to SQL injection。

executeRawSql

Executes raw SQL statements. Requires password for non-read-only operations.

executePreparedSql

Executes parameterized SQL operations using PreparedStatement.

Adding Other Relational Databases

Add the appropriate database driver to the pom.xml file and rebuild.