The DBeaver MCP Server provides AI assistants with secure, universal access to 200+ database types through existing DBeaver connections with zero configuration and enterprise-grade safety features.
Connection Management: List and inspect all DBeaver database connections, get detailed connection information, test connectivity, and auto-detect DBeaver workspace (supports legacy XML and modern JSON formats, versions 6.x through 21.x+)
Data Operations: Execute read-only SELECT queries with configurable row limits (default: 1000), perform validated INSERT/UPDATE/DELETE operations, and export up to 10,000 rows to CSV, JSON, XML, or Excel formats
Schema Management: List tables and views with optional schema filtering, get detailed table schemas (columns, data types, indexes), create and alter tables using DDL statements, and drop tables with mandatory safety confirmation
Business Intelligence: Store and retrieve persistent business insights with optional tags and connection associations, get database statistics and metadata, and track analysis findings with query execution performance monitoring
Safety & Security: Built-in query validation with automatic LIMIT protection, confirmation prompts for destructive operations, secure credential management through DBeaver, configurable timeout protection (default: 30 seconds), and comprehensive error handling
Platform Support: Cross-platform compatibility (Windows, macOS, Linux), full Model Context Protocol integration with resource browsing capabilities, and debug mode for troubleshooting
Integrates with DBeaver to provide access to 200+ database types through existing DBeaver connections, allowing database querying, schema exploration, and data export functionality without additional configuration.
Provides access to MySQL databases for schema exploration and query execution through existing DBeaver connections.
Enables running queries on PostgreSQL databases through DBeaver connections, with support for data retrieval and manipulation operations.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@DBeaver MCP Serverlist all tables in my production PostgreSQL database"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
DBeaver MCP Server
MCP server that provides AI assistants access to databases through DBeaver connections.
Features
Uses existing DBeaver connections (no separate config needed)
Native query execution for PostgreSQL, MySQL/MariaDB, SQLite, SQL Server
Falls back to DBeaver CLI for other database types
Connection pooling with configurable pool size and timeouts
Transaction support (BEGIN/COMMIT/ROLLBACK)
Query execution plan analysis (EXPLAIN)
Schema comparison between connections
Read-only mode and tool filtering
Query validation to block dangerous operations
Data export to CSV/JSON
Related MCP server: IoTDB MCP Server
Requirements
Node.js 18+
DBeaver with at least one configured connection
Installation
Configuration
Add to your Claude Desktop config (~/Library/Application Support/Claude/claude_desktop_config.json on macOS):
Environment Variables
Variable | Description | Default |
| Path to DBeaver executable | Auto-detected |
| Path to DBeaver workspace | OS default |
| Query timeout (ms) |
|
| Enable debug logging |
|
| Disable write operations |
|
| Comma-separated tools to disable | None |
| Minimum connections per pool |
|
| Maximum connections per pool |
|
| Idle connection timeout (ms) |
|
| Connection acquire timeout (ms) |
|
Read-Only Mode
Disable Specific Tools
Available Tools
Connection Management
list_connections- List all DBeaver connectionsget_connection_info- Get connection detailstest_connection- Test connectivity
Data Operations
execute_query- Run SELECT querieswrite_query- Run INSERT/UPDATE/DELETEexport_data- Export to CSV/JSON
Schema Management
list_tables- List tables and viewsget_table_schema- Get table structurecreate_table- Create tablesalter_table- Modify tablesdrop_table- Drop tables (requires confirmation)
Transactions
begin_transaction- Start a new transactionexecute_in_transaction- Execute query within a transactioncommit_transaction- Commit a transactionrollback_transaction- Roll back a transaction
Query Analysis
explain_query- Analyze query execution plancompare_schemas- Compare schemas between two connectionsget_pool_stats- Get connection pool statistics
Other
get_database_stats- Database statisticsappend_insight- Store analysis noteslist_insights- Retrieve stored notes
DBeaver Version Support
Supports both configuration formats:
DBeaver 6.x: XML config in
.metadata/.plugins/org.jkiss.dbeaver.core/DBeaver 21.x+: JSON config in
General/.dbeaver/
Development
License
MIT