Skip to main content
Glama
DBeaver MCP Server

DBeaver MCP Server

by srthkdev

OmniSQL MCP

通用数据库 MCP 服务器 — 让 AI 助手能够使用您本地数据库客户端工作区(兼容 DBeaver)中已保存的连接,对您的数据库进行读/写访问。

npm version License: MIT Node.js

数据库支持

原生支持(直接驱动,速度快):

  • PostgreSQL (通过 pg)

  • MySQL / MariaDB (通过 mysql2)

  • SQL Server / MSSQL (通过 mssql)

  • SQLite (通过 sqlite3 CLI)

Postgres 兼容(自动通过 pg 驱动路由):

  • CockroachDB, TimescaleDB, Amazon Redshift, YugabyteDB, AlloyDB, Supabase, Neon, Citus

其他数据库:回退到通过 OMNISQL_CLI_PATH 配置的外部 CLI。结果取决于具体的 CLI。

Related MCP server: Alibaba Cloud DMS MCP Server

功能特性

  • 重用您本地数据库客户端工作区中已配置的连接 — 无需重复设置

  • 支持 PostgreSQL, MySQL/MariaDB, SQLite, SQL Server 的原生查询执行

  • 具有可配置连接池大小和超时的连接池管理

  • 支持事务 (BEGIN/COMMIT/ROLLBACK)

  • 查询执行计划分析 (EXPLAIN)

  • 连接间的模式(Schema)比较及迁移脚本生成

  • 只读模式,在 execute_query 中强制执行仅 SELECT 操作

  • 连接白名单,限制可访问的数据库

  • 工具过滤,可禁用特定操作

  • 查询验证,阻止危险操作(DROP DATABASE, TRUNCATE, 无 WHERE 条件的 DELETE/UPDATE)

  • 数据导出为 CSV/JSON

  • 优雅关闭,清理连接池

要求

  • Node.js 18+

  • 本地数据库客户端(兼容 DBeaver),且至少配置有一个连接

安装

npm install -g omnisql-mcp

配置

Claude Desktop

添加到 ~/Library/Application Support/Claude/claude_desktop_config.json (macOS):

{
  "mcpServers": {
    "omnisql": {
      "command": "omnisql-mcp"
    }
  }
}

Claude Code

添加到 ~/.claude/settings.json:

{
  "mcpServers": {
    "omnisql": {
      "command": "omnisql-mcp"
    }
  }
}

Cursor

添加到 Cursor 设置 > MCP Servers:

{
  "mcpServers": {
    "omnisql": {
      "command": "omnisql-mcp"
    }
  }
}

环境变量

变量

描述

默认值

OMNISQL_CLI_PATH

外部数据库客户端 CLI 的路径(用于不支持驱动的回退)

未设置

OMNISQL_WORKSPACE

本地数据库客户端工作区目录路径

操作系统默认

OMNISQL_TIMEOUT

查询超时时间 (ms)

30000

OMNISQL_DEBUG

启用调试日志

false

OMNISQL_READ_ONLY

禁用所有写操作

false

OMNISQL_ALLOWED_CONNECTIONS

连接 ID 或名称的逗号分隔白名单

全部

OMNISQL_DISABLED_TOOLS

要禁用的工具的逗号分隔列表

无

OMNISQL_POOL_MIN

每个连接池的最小连接数

2

OMNISQL_POOL_MAX

每个连接池的最大连接数

10

OMNISQL_POOL_IDLE_TIMEOUT

空闲连接超时时间 (ms)

30000

OMNISQL_POOL_ACQUIRE_TIMEOUT

获取连接超时时间 (ms)

10000

只读模式

阻止所有写操作。execute_query 工具仅允许 SELECT, EXPLAIN, SHOW 和 DESCRIBE 语句。事务工具将被完全禁用。

{
  "mcpServers": {
    "omnisql": {
      "command": "omnisql-mcp",
      "env": {
        "OMNISQL_READ_ONLY": "true"
      }
    }
  }
}

连接白名单

限制哪些工作区连接可见。接受以逗号分隔的连接 ID 或显示名称:

{
  "mcpServers": {
    "omnisql": {
      "command": "omnisql-mcp",
      "env": {
        "OMNISQL_ALLOWED_CONNECTIONS": "dev-postgres,staging-mysql"
      }
    }
  }
}

禁用特定工具

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

可用工具

连接管理

  • list_connections - 列出所有数据库连接

  • get_connection_info - 获取连接详情

  • test_connection - 测试连接性

数据操作

  • execute_query - 运行只读查询(仅限 SELECT, EXPLAIN, SHOW, DESCRIBE)

  • write_query - 运行 INSERT/UPDATE/DELETE

  • export_data - 导出为 CSV/JSON

模式管理

  • list_tables - 列出表和视图

  • get_table_schema - 获取表结构

  • create_table - 创建表

  • alter_table - 修改表

  • drop_table - 删除表(需要确认)

事务

  • begin_transaction - 开始新事务

  • execute_in_transaction - 在事务内执行查询

  • commit_transaction - 提交事务

  • rollback_transaction - 回滚事务

查询分析

  • explain_query - 分析查询执行计划

  • compare_schemas - 比较两个连接之间的模式

  • get_pool_stats - 获取连接池统计信息

其他

  • get_database_stats - 数据库统计信息

  • append_insight - 存储分析笔记

  • list_insights - 检索存储的笔记

安全性

  • 只读强制执行:execute_query 仅接受只读语句(SELECT, EXPLAIN, SHOW, DESCRIBE, PRAGMA)。写操作必须使用 write_query。

  • 查询验证:阻止 DROP DATABASE, DROP SCHEMA, TRUNCATE, 无 WHERE 条件的 DELETE/UPDATE, GRANT, REVOKE 以及用户管理语句。

  • 连接白名单:通过 OMNISQL_ALLOWED_CONNECTIONS 限制暴露的连接。

  • 工具过滤:通过 OMNISQL_DISABLED_TOOLS 禁用任何工具。

  • 输入清理:连接 ID 和 SQL 标识符经过清理以防止注入。

  • 建议:在生产环境中使用时,请同时使用数据库级别的只读用户以实现纵深防御。

工作区格式支持

支持 DBeaver 兼容数据库客户端编写的两种配置格式:

  • 旧版:.metadata/.plugins/org.jkiss.dbeaver.core/ 中的 XML 配置

  • 新版:General/.dbeaver/ 中的 JSON 配置

凭据会自动从工作区的 credentials-config.json 中解密。

开发

git clone https://github.com/srthkdev/omnisql-mcp.git
cd omnisql-mcp
npm install
npm run build
npm test
npm run lint

许可证

MIT

Available Tools

14 tools
alter_tableC

Modify existing table schema (add columns, rename tables, etc.)

Inputs: connectionId (required), query (required).

append_insightA

Add a business insight or analysis note to the memo

Inputs: insight (required), connection, tags.

create_tableC

Create new tables in the database

Inputs: connectionId (required), query (required).

drop_tableA

Remove a table from the database with safety confirmation

Inputs: confirm (required), connectionId (required), tableName (required).

execute_queryA

Execute a SQL query on a specific DBeaver connection (read-only queries)

Inputs: connectionId (required), query (required), maxRows.

export_dataC

Export query results to various formats (CSV, JSON, etc.)

Inputs: connectionId (required), query (required), format, includeHeaders, +1 more.

get_connection_infoC

Get detailed information about a specific DBeaver connection

Inputs: connectionId (required).

get_database_statsC

Get statistics and information about a database

Inputs: connectionId (required).

get_table_schemaB

Get schema information for a specific table

Inputs: connectionId (required), tableName (required), includeIndexes.

list_connectionsB

List all available DBeaver database connections

Inputs: includeDetails.

list_insightsA

List all stored business insights and analysis notes

Inputs: connection, tags.

list_tablesC

List all tables in a database

Inputs: connectionId (required), includeViews, schema.

test_connectionC

Test connectivity to a DBeaver connection

Inputs: connectionId (required).

write_queryA

Execute INSERT, UPDATE, or DELETE queries on a specific DBeaver connection

Inputs: connectionId (required), query (required).

Tool Schema Changelog

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

Loading tool schema changelog…

    TDQS

    B3.4/5.0

    Scored across 14 tools

    Disambiguation4/5

    Most tools have distinct purposes, but 'execute_query' and 'write_query' could cause confusion as both execute SQL queries, with the distinction being read-only vs. write operations. Other tools like 'create_table', 'alter_table', and 'drop_table' are clearly differentiated for table management.

    Naming Consistency5/5

    All tools follow a consistent verb_noun naming pattern (e.g., 'create_table', 'list_connections', 'execute_query'), with no mixing of conventions like camelCase or snake_case variations. This predictability makes the tool set easy to navigate and understand.

    Tool Count5/5

    With 14 tools, the count is well-scoped for a database management server, covering core operations like connection handling, query execution, table management, and data export. Each tool serves a specific function without redundancy, fitting the domain appropriately.

    Completeness4/5

    The tool set provides comprehensive coverage for database operations, including CRUD for tables, connection management, and query execution. A minor gap exists in data manipulation beyond basic queries, such as bulk operations or transaction handling, but core workflows are well-supported.

    Maintenance

    ActivityMaintained
    ResponsivenessUsually handled

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      Not graded
      quality
      D
      maintenance
      A Model Context Protocol server that enables Large Language Models to access and interact with database connections, including viewing schemas and performing CRUD operations on connected databases.
      -
    • A
      license
      Not graded
      quality
      D
      maintenance
      A Model Context Protocol server that provides AI assistants with comprehensive access to SQL databases, enabling schema inspection, query execution, and database operations with enterprise-grade security.
      62 npm
      9
      MIT
    • A
      license
      B
      quality
      D
      maintenance
      A Model Context Protocol server that provides real-time database schema information to AI assistants, supporting both low-code system schema queries and traditional database metadata queries.
      4
      MIT

    Appeared in Searches