Skip to main content
Glama
dbeaver-mcp-server

dbeaver-mcp-server

by dongchao-1

dbeaver-mcp-server

中文文档

MCP server that reads DBeaver database configurations and provides SQL execution via existing JDBC drivers — no extra driver downloads needed.

Features

  • Auto-discover DBeaver workspaces and projects (macOS / Linux / Windows)

  • List connections from DBeaver's data-sources.json

  • Execute read-only SQL via DBeaver's existing JDBC drivers (JayDeBeApi + JPype)

  • Auto-decrypt DBeaver's encrypted credentials

  • Multi-driver support — all JDBC drivers installed in DBeaver are loaded at once

Related MCP server: Universal Database MCP Server

Tools

Tool

Description

list_workspaces

List all discovered DBeaver workspaces and projects

list_connections

List database connections, optionally filtered by workspace

execute_sql

Execute a read-only SQL query (only SELECT / SHOW / DESCRIBE / EXPLAIN / WITH)

Requirements

  • Python >= 3.13

  • uv (Python package manager)

  • Java Runtime (for JPype/JDBC)

  • DBeaver 26.x (Community Edition)

Installation

git clone <repo-url> dbeaver-mcp-server
cd dbeaver-mcp-server
uv sync

Usage

Standalone

cd /path/to/dbeaver-mcp-server
source .venv/bin/activate
mcp dev src/server.py

With OpenCode

Add to ~/.config/opencode/opencode.json:

{
  "mcp": {
    "dbeaver": {
      "type": "local",
      "command": [
        "/path/to/dbeaver-mcp-server/.venv/bin/python",
        "-m",
        "src.server"
      ],
      "enabled": true
    }
  }
}

Environment Variables

Variable

Description

Default

DBEAVER_WORKSPACE_PATH

Override workspace path

Auto-discovered

DBEAVER_DRIVERS_XML_PATH

Override drivers.xml path

Auto-discovered

DBEAVER_ENCRYPTION_KEY

Override credential encryption key (hex)

Default

Security

  • Only read-only SQL is allowed: SELECT, SHOW, DESCRIBE, EXPLAIN, WITH

  • INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, TRUNCATE are blocked

  • Passwords are decrypted in-memory only, never written to disk

How It Works

  1. Discovers DBeaver workspace via default paths or DBEAVER_WORKSPACE_PATH

  2. Reads data-sources.json for connection configurations

  3. Reads drivers.xml and scans JDBC jars for driver class names

  4. Decrypts credentials-config.json using DBeaver's AES-128-CBC key

  5. Starts a JVM with all JDBC jars and executes queries via JayDeBeApi

Available Tools

3 tools
execute_sqlA

Execute a read-only SQL query on a specified DBeaver database connection. Only SELECT, SHOW, DESCRIBE, EXPLAIN, WITH statements are allowed. Write operations are strictly prohibited.

Args: connection_name: The name of the database connection (as shown in list_connections). sql: The read-only SQL query to execute.

Inputs: sql (required), connection_name (required). Returns: result

list_connectionsA

List all configured database connections from DBeaver. Optionally filter by workspace_path from list_workspaces.

Args: workspace_path: Optional workspace path to filter connections. If empty, returns all.

Inputs: workspace_path. Returns: result

list_workspacesA

List all discovered DBeaver workspaces with their projects and data source locations.

Inputs: no named parameters. Returns: result

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A4/5.0

    Scored across 3 tools

    Disambiguation5/5

    Each tool has a distinct purpose: listing workspaces, listing connections, and executing SQL queries. No overlap in functionality.

    Naming Consistency5/5

    All tools follow a consistent verb_noun pattern using snake_case (list_workspaces, list_connections, execute_sql).

    Tool Count5/5

    Three tools are appropriate for the server's focused purpose of managing database connections and executing read-only SQL queries. Each tool serves a clear role.

    Completeness3/5

    The tool set covers workspace discovery, connection listing, and SQL execution, but lacks schema exploration (e.g., listing tables or describing schemas), which is a notable gap for a database tool.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      MCP server for connecting to databases (PostgreSQL, MySQL, SQL Server, Redis) enabling SQL queries, table exploration, and Redis key-value operations.
      1
      MIT
    • F
      license
      Not graded
      quality
      D
      maintenance
      A versatile MCP server that connects to multiple relational databases (MySQL, PostgreSQL, Oracle, SQL Server, SQLite) and enables secure read-only SQL query execution and metadata access.
      4
      -
    • A
      license
      A
      quality
      C
      maintenance
      MCP server for querying and managing multiple databases (SQLite, PostgreSQL, MySQL) with read-only mode and schema inspection.
      2
      13
      MIT
    • A
      license
      Not graded
      quality
      C
      maintenance
      MCP server that connects to SQL databases (SQLite, PostgreSQL, MSSQL, MySQL) and provides tools to run read-only queries, list schemas/tables, and manage connections via stdio transport.
      Apache 2.0