DBeaver MCP Server

Integrates with DBeaver to provide AI assistants access to over 200 database types using existing connections.

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).

Natively supported(direct driver, fast):

- PostgreSQL (viapg)
- MySQL / MariaDB (viamysql2)
- SQL Server / MSSQL (viamssql)
- SQLite (viasqlite3CLI)

Postgres-compatible(routed throughpgdriver automatically):

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

Other databases: Fall back to an external CLI configured viaOMNISQL_CLI_PATH. Results vary by CLI.

- 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
- Read-only mode with enforced SELECT-only onexecute_query
- Connection whitelist to restrict which databases are accessible
- Tool filtering to disable specific operations
- Query validation to block dangerous operations (DROP DATABASE, TRUNCATE, DELETE/UPDATE without WHERE)
- Data export to CSV/JSON
- Graceful shutdown with connection pool cleanup

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

Add to~/Library/Application Support/Claude/claude_desktop_config.json(macOS):

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

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

Add to Cursor Settings > MCP Servers:

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

Blocks all write operations. Theexecute_querytool only allows SELECT, EXPLAIN, SHOW, and DESCRIBE statements. Transaction tools are disabled entirely.

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

Restrict which workspace connections are visible. Accepts connection IDs or display names, comma-separated:

{ "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- List all database connections
- get_connection_info- Get connection details
- test_connection- Test connectivity

- execute_query- Run read-only queries (SELECT, EXPLAIN, SHOW, DESCRIBE only)
- write_query- Run INSERT/UPDATE/DELETE
- export_data- Export to CSV/JSON

- list_tables- List tables and views
- get_table_schema- Get table structure
- create_table- Create tables
- alter_table- Modify tables
- drop_table- Drop tables (requires confirmation)

- begin_transaction- Start a new transaction
- execute_in_transaction- Execute query within a transaction
- commit_transaction- Commit a transaction
- rollback_transaction- Roll back a transaction

- explain_query- Analyze query execution plan
- compare_schemas- Compare schemas between two connections
- get_pool_stats- Get connection pool statistics

- get_database_stats- Database statistics
- append_insight- Store analysis notes
- list_insights- Retrieve stored notes

- Read-only enforcement:execute_queryonly accepts read-only statements (SELECT, EXPLAIN, SHOW, DESCRIBE, PRAGMA). Write operations must usewrite_query.
- Query validation: Blocks DROP DATABASE, DROP SCHEMA, TRUNCATE, DELETE/UPDATE without WHERE, GRANT, REVOKE, and user management statements.
- Connection whitelist: Restrict which connections are exposed viaOMNISQL_ALLOWED_CONNECTIONS.
- Tool filtering: Disable any tool viaOMNISQL_DISABLED_TOOLS.
- Input sanitization: Connection IDs and SQL identifiers are sanitized to prevent injection.
- Recommendation: For production use, also use a database-level read-only user for defense in depth.

Supports both configuration formats written by DBeaver-compatible DB clients:

- Legacy: XML config in.metadata/.plugins/org.jkiss.dbeaver.core/
- Modern: JSON config inGeneral/.dbeaver/

Credentials are automatically decrypted from the workspacecredentials-config.json.

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

Official Airtable MCP server and skills for working with bases, records, workflows, and business operations from AI agents.

MCP Server For Apache Doris, an MPP-based real-time data warehouse.

Official MCP Server from Atlan which enables you to bring the power of metadata to your AI tools

Query Onchain data, like ERC20 tokens, transaction history, smart contract state.

Read and write access to your Baserow tables.

Introspect and query your apps deployed to Convex.

Interact with the data stored in Couchbase clusters using natural language.

Maritime intelligence for tracking vessels, analysing ports, and exploring ship data.