A database server based on Model Context Protocol (MCP), supporting SQLite, MySQL, PostgreSQL, and MSSQL databases.
π¨π³ δΈζζζ‘£ / Chinese Documentation: README_cn.md
- 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
Download the latest release for your platform from GitHub Releases:
Platform | Download |
---|---|
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:
- Download
rbdc-mcp-windows-x86_64.exe
- Rename to
rbdc-mcp.exe
- Move to a directory, e.g.,
C:\tools\rbdc-mcp.exe
- Add to 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
- Restart command prompt, test:
rbdc-mcp --help
macOS:
- Download the appropriate file:
- Intel chip:
rbdc-mcp-macos-x86_64
- Apple Silicon:
rbdc-mcp-macos-aarch64
- Intel chip:
- Rename and install:
mv rbdc-mcp-macos-* rbdc-mcp chmod +x rbdc-mcp sudo mv rbdc-mcp /usr/local/bin/
- Test:
rbdc-mcp --help
Linux:
- Download
rbdc-mcp-linux-x86_64
- Rename and install:
mv rbdc-mcp-linux-x86_64 rbdc-mcp chmod +x rbdc-mcp sudo mv rbdc-mcp /usr/local/bin/
- Test:
rbdc-mcp --help
Prerequisites: Install Rust first.
cargo install --git https://github.com/rbatis/rbdc-mcp.git
git clone https://github.com/rbatis/rbdc-mcp.git
cd rbdc-mcp
cargo build --release
# Executable: target/release/rbdc-mcp
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"]
}
}
}
After saving the configuration, restart Claude Desktop to load the MCP server.
In Claude Desktop, try asking:
- "Show me the database connection status"
- "What tables are in my database?"
- 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 | Connection URL Format |
---|---|
SQLite | sqlite://path/to/database.db |
MySQL | mysql://user:password@host:port/database |
PostgreSQL | postgres://user:password@host:port/database |
MSSQL | mssql://user:password@host:port/database |
Parameter | Description | Default |
---|---|---|
--database-url, -d |
Database connection URL | Required |
--max-connections |
Maximum connection pool size | 1 |
--timeout |
Connection timeout (seconds) | 30 |
--log-level |
Log level (error/warn/info/debug) | info |
sql_query
: Execute SELECT queries safelysql_exec
: Execute INSERT/UPDATE/DELETE operationsdb_status
: Check connection pool status
Apache-2.0