Dbeaver MCP Server

Universal database MCP server — native drivers for PostgreSQL, MySQL, SQLite, SQL Server with CLI fallback, reading connections from your local DB

Local serverstdio

What is the Dbeaver MCP server?

Universal database MCP server — native drivers for PostgreSQL, MySQL, SQLite, SQL Server with CLI fallback, reading connections from your local DB client workspace. Exposed over MCP by the dbeaver mcp server, that capability becomes something an assistant can invoke while it works, not something you go and do afterwards.

What it actually does

Universal database MCP server — give AI assistants read/write access to your databases using connections already saved in your local DB client workspace (DBeaver-compatible).

  • Reuses connections already configured in your local DB client workspace — no duplicate setup
  • Native query execution for PostgreSQL, MySQL/MariaDB, SQLite, SQL Server
  • Connection pooling with configurable pool size and timeouts
  • Transaction support (BEGIN/COMMIT/ROLLBACK)
  • Query execution plan analysis (EXPLAIN)
  • Schema comparison between connections with migration script generation

Its toolset

Everything the assistant can do here goes through one of these:

  • Cursor — The Cursor tool exposed by this server
  • Transactions — The Transactions tool exposed by this server
  • Other — The Other tool exposed by this server

Configuration

You will need 4 environment variables: OMNISQL_READ_ONLY, OMNISQL_ALLOWED_CONNECTIONS, OMNISQL_DISABLED_TOOLS, OMNISQL_CLI_PATH. Keep credentials in your client's env block or a secrets manager rather than in a file you might commit.

  • Node.js 18+ - A local DB client (DBeaver-compatible) with at least one configured connection

Adding it to your client

The server ships on npm as omnisql-mcp, so your MCP client can launch it on demand — there is no separate build step. Add the server block to your client's configuration, restart it, and the tools register themselves.

When to reach for it

This sits in the database access group, where several servers overlap in what they claim to do but differ sharply once you actually set them up. Dbeaver's toolset — Cursor, Transactions, Other — is a fair guide to whether it matches your workflow. It is maintained by srthkdev; worth a glance at recent repository activity before you build anything load-bearing on it.

We check each listing at SyncDev against the project's documentation before it goes live — if something here drifts out of date, it is a bug worth reporting.

Caveats

  • It runs with your machine's permissions. That is convenient and also the reason to think about what you point it at before you approve a tool call.
  • MCP clients confirm each tool call by default. Leave that on until you have watched what the dbeaver mcp server does with a few real requests.

Available tools

ToolWhat it does
CursorThe Cursor tool exposed by this server.
TransactionsThe Transactions tool exposed by this server.
OtherThe Other tool exposed by this server.

How to install the Dbeaver MCP server

### Disable Specific Tools

```json
{
  "mcpServers": {
    "omnisql": {
      "command": "omnisql-mcp",
      "env": {
        "OMNISQL_DISABLED_TOOLS": "drop_table,alter_table,write_query"
      }
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

  • Node.js 18+ - A local DB client (DBeaver-compatible) with at least one configured connection
VariableDescriptionRequired
OMNISQL_READ_ONLYConfiguration value read at startup.Optional
OMNISQL_ALLOWED_CONNECTIONSConfiguration value read at startup.Optional
OMNISQL_DISABLED_TOOLSConfiguration value read at startup.Optional
OMNISQL_CLI_PATHFilesystem location the server is allowed to use.Optional

Example prompts to try

  • Use Dbeaver to Cursor.
  • Use Dbeaver to Transactions.
  • Use Dbeaver to Other.

Frequently asked questions

It connects Dbeaver to MCP-compatible AI assistants such as Claude and Cursor, exposing 3 tools (Cursor, Transactions, Other) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Dbeaver directly.