rdb_mcp_server

rdb_mcp_server

0
databases

The rdb-mcp-server is an experimental MCP server designed to handle low-level SQL operations across various databases using JDBC. It supports MySQL, PostgreSQL, and SQLite, allowing users to perform operations through standard input/output mechanisms.

rdb-mcp-server

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

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

Download and run the JAR file using Java. Provide necessary environment variables for configuration.

Available Tools

executeQuery

Executes read-only SQL queries. No authentication required.

executeRawSql

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

executePreparedSql

Executes parameterized SQL operations using PreparedStatement.