Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

rbdc-mcp-server

NotificationsYou must be signed in to change notification settings

rbatis/rbdc-mcp

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

36 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

A database server based onModel Context Protocol (MCP), supporting SQLite, MySQL, PostgreSQL, and MSSQL databases.

🇨🇳 中文文档 / Chinese Documentation:README_cn.md

Advantages

  • 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 fromGitHub Releases:

PlatformDownload
Windows (x64)rbdc-mcp-windows-x86_64.exe
macOS (Intel)rbdc-mcp-macos-x86_64
macOS (Apple Silicon)rbdc-mcp-macos-aarch64
Linux (x64)rbdc-mcp-linux-x86_64

Installation Steps:

Windows:

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

macOS:

  1. Download the appropriate file:
    • Intel chip:rbdc-mcp-macos-x86_64
    • Apple Silicon:rbdc-mcp-macos-aarch64
  2. Rename and install:
    mv rbdc-mcp-macos-* rbdc-mcpchmod +x rbdc-mcpsudo mv rbdc-mcp /usr/local/bin/
  3. Test:rbdc-mcp --help

Linux:

  1. Downloadrbdc-mcp-linux-x86_64
  2. Rename and install:
    mv rbdc-mcp-linux-x86_64 rbdc-mcpchmod +x rbdc-mcpsudo mv rbdc-mcp /usr/local/bin/
  3. Test:rbdc-mcp --help

🛠️ Method 2: Install via Cargo

Prerequisites: InstallRust first.

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

🔧 Method 3: Build from Source

git clone https://github.com/rbatis/rbdc-mcp.gitcd rbdc-mcpcargo 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:

Different Database 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"]    }  }}
Windows Full Path (if not in PATH)
{"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:

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

📊 Usage Examples

Natural Language Database Operations

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

🗄️ Database Support

DatabaseConnection URL Format
SQLitesqlite://path/to/database.db
MySQLmysql://user:password@host:port/database
PostgreSQLpostgres://user:password@host:port/database
MSSQLmssql://user:password@host:port/database

⚙️ Configuration Options

ParameterDescriptionDefault
--database-url, -dDatabase connection URLRequired
--max-connectionsMaximum connection pool size1
--timeoutConnection timeout (seconds)30
--log-levelLog level (error/warn/info/debug)info

🛠️ Available Tools

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

📸 Screenshots

Step 1: ConfigurationConfiguration

Step 2: Usage in ClaudeUsage

License

Apache-2.0

About

rbdc-mcp-server

Resources

Stars

Watchers

Forks

Packages

No packages published

Contributors2

  •  
  •  

Languages


[8]ページ先頭

©2009-2025 Movatter.jp