Rbdc MCP

🚀 RBDC MCP Server

The RBDC MCP Server is a database server based on the Model Context Protocol (MCP). It supports multiple databases, including SQLite, MySQL, PostgreSQL, and MSSQL, providing a unified interface for seamless database operations.

🇨🇳 Chinese Documentation: README_cn.md

🚀 Quick Start

The RBDC MCP Server is a powerful tool that allows you to interact with various databases using a unified interface and natural language queries. Follow the steps below to get started.

✨ Features

• Multiple Database Support: Seamlessly work with SQLite, MySQL, PostgreSQL, and MSSQL using a unified interface.
• AI Integration: Native integration with Claude AI through the Model Context Protocol.
• Zero Configuration: Automatic management of database connections and resources.
• Security: Controlled access to your database through AI-driven natural language queries.
• Simplicity: Use natural language to query and modify your database without writing SQL.

📦 Installation

🚀 Method 1: Download Pre-built Binaries (Recommended)

Download the latest release for your platform from GitHub Releases:

Installation Steps:

Windows:

1. Download rbdc-mcp-windows-x86_64.exe.
2. Rename it to rbdc-mcp.exe.
3. Move the executable to a directory, e.g., C:\tools\rbdc-mcp.exe.
4. Add the directory to the PATH environment variable:
   • Right-click "This PC" → "Properties" → "Advanced system settings" → "Environment Variables".
   • Find "Path" in "System variables", click "Edit".
   • Add C:\tools to the path list.
5. Restart the command prompt and test the installation: rbdc-mcp --help.

macOS:

1. Download the appropriate file based on your chip:
   • For Intel chip: rbdc-mcp-macos-x86_64.
   • For Apple Silicon: rbdc-mcp-macos-aarch64.
2. Rename and install the executable:

   mv rbdc-mcp-macos-* rbdc-mcp
   chmod +x rbdc-mcp
   sudo mv rbdc-mcp /usr/local/bin/
   

3. Test the installation: rbdc-mcp --help.

Linux:

1. Download rbdc-mcp-linux-x86_64.
2. Rename and install the executable:

   mv rbdc-mcp-linux-x86_64 rbdc-mcp
   chmod +x rbdc-mcp
   sudo mv rbdc-mcp /usr/local/bin/
   

3. Test the installation: rbdc-mcp --help.

🛠️ Method 2: Install via Cargo

Prerequisites: Install Rust first.

cargo install --git https://github.com/rbatis/rbdc-mcp.git

🔧 Method 3: Build from Source

git clone https://github.com/rbatis/rbdc-mcp.git
cd rbdc-mcp
cargo build --release
# Executable: target/release/rbdc-mcp

🔧 Quick Setup

Step 1: Configure Claude Desktop

Configuration File Location:

• Windows: %APPDATA%\Claude\claude_desktop_config.json
• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

Basic Configuration:

{
  "mcpServers": {
    "rbdc-mcp": {
      "command": "rbdc-mcp",
      "args": ["--database-url", "sqlite://./database.db"]
    }
  }
}

Platform-Specific Examples:

{
  "mcpServers": {
    "rbdc-mcp-sqlite": {
      "command": "rbdc-mcp",
      "args": ["--database-url", "sqlite://./database.db"]
    },
    "rbdc-mcp-mysql": {
      "command": "rbdc-mcp",
      "args": ["--database-url", "mysql://user:password@localhost:3306/database"]
    },
    "rbdc-mcp-postgres": {
      "command": "rbdc-mcp",
      "args": ["--database-url", "postgres://user:password@localhost:5432/database"]
    }
  }
}

{
  "mcpServers": {
    "rbdc-mcp": {
      "command": "C:\\tools\\rbdc-mcp.exe",
      "args": ["--database-url", "sqlite://C:\\path\\to\\database.db"]
    }
  }
}

Step 2: Restart Claude Desktop

After saving the configuration, restart Claude Desktop to load the MCP server.

Step 3: Test the Connection

In Claude Desktop, try asking the following questions:

• "Show me the database connection status"
• "What tables are in my database?"

💻 Usage Examples

Basic Usage

You can use natural language to perform various database operations. Here are some examples:

• Query Data: "Show me all users in the database"
• Modify Data: "Add a new user named John with email john@example.com"
• Get Status: "What's the database connection status?"
• Schema Info: "What tables exist in my database?"

🗄️ Database Support

🔧 Technical Details

Configuration Options

Available Tools

• sql_query: Execute SELECT queries safely.
• sql_exec: Execute INSERT/UPDATE/DELETE operations.
• db_status: Check connection pool status.

📸 Screenshots

Step 1: Configuration

Step 2: Usage in Claude

📄 License

This project is licensed under the Apache-2.0 license.