Skip to main content
Glama

DBeaver MCP Server

by srthkdev
OverviewInspectNewSchemaRelated ServersScore
TypeScript
Hybrid
MIT License
39
20
  • Apple
  • Linux

DBeaver MCP Server

A production-ready Model Context Protocol (MCP) server that seamlessly integrates with DBeaver to provide AI assistants universal access to 200+ database types through your existing DBeaver connections. Built for real-world usage with Claude, Cursor, and other MCP-compatible AI assistants.

npm version License: MIT Node.js Downloads GitHub stars

🚀 Key Features

🔗 Universal Database Connectivity

  • 200+ Database Types: PostgreSQL, MySQL, Oracle, SQL Server, SQLite, MongoDB, and more

  • Zero Configuration: Leverages your existing DBeaver connections

  • Auto-Detection: Automatically finds and connects to your DBeaver workspace

  • Cross-Platform: Windows, macOS, and Linux support

🛡️ Enterprise-Grade Security & Safety

  • Credential Management: Uses DBeaver's secure credential storage

  • Query Validation: Built-in protection against dangerous operations

  • Confirmation Prompts: Destructive operations require explicit confirmation

  • Connection Validation: All connections verified before operations

  • Error Handling: Comprehensive error recovery and logging

📊 Advanced Data Operations

  • Read Operations: Safe SELECT queries with automatic LIMIT protection

  • Write Operations: INSERT, UPDATE, DELETE with validation

  • Schema Management: Complete DDL operations (CREATE, ALTER, DROP)

  • Data Export: CSV, JSON, XML, Excel export formats

  • Performance Monitoring: Query execution time tracking

🧠 AI-Powered Intelligence

  • Business Insights: Track and store analysis insights with tagging

  • Resource Browsing: Browse table schemas through MCP resources

  • Smart Suggestions: Context-aware database recommendations

  • Analysis Tracking: Persistent storage of business intelligence findings

🔧 Developer Experience

  • MCP Protocol: Full Model Context Protocol compliance

  • TypeScript: Complete type safety and IntelliSense support

  • Debug Mode: Comprehensive logging and troubleshooting

  • Version Compatibility: Supports DBeaver 6.x through 21.x+

🔧 Version Compatibility

This MCP server automatically detects and supports both DBeaver configuration formats:

  • Legacy DBeaver (6.x): Uses XML-based configuration in .metadata/.plugins/org.jkiss.dbeaver.core/

  • Modern DBeaver (21.x+): Uses JSON-based configuration in General/.dbeaver/

The server will automatically detect your DBeaver version and use the appropriate configuration parser.

🛠️ Available Tools

📋 Connection Management

Tool

Description

Safety Level

list_connections

List all DBeaver database connections

✅ Safe

get_connection_info

Get detailed connection information

✅ Safe

test_connection

Test database connectivity

✅ Safe

📊 Data Operations

Tool

Description

Safety Level

execute_query

Execute SELECT queries (read-only)

✅ Safe

write_query

Execute INSERT, UPDATE, DELETE queries

⚠️ Modifies data

export_data

Export query results to CSV/JSON/XML/Excel

✅ Safe

🏗️ Schema Management

Tool

Description

Safety Level

list_tables

List all tables and views in database

✅ Safe

get_table_schema

Get detailed table schema information

✅ Safe

create_table

Create new database tables

⚠️ Schema changes

alter_table

Modify existing table schemas

⚠️ Schema changes

drop_table

Remove tables (requires confirmation)

❌ Destructive

📈 Analytics & Intelligence

Tool

Description

Safety Level

get_database_stats

Get database statistics and info

✅ Safe

append_insight

Add business insights to memo

✅ Safe

list_insights

List stored business insights

✅ Safe

📋 Prerequisites

  • Node.js 18+

  • DBeaver installed and configured with at least one connection

  • Claude Desktop, Cursor, or another MCP-compatible client

🛠️ Installation

Quick Install (Recommended)

npm install -g dbeaver-mcp-server

Verify Installation

dbeaver-mcp-server --help

Manual Installation

git clone https://github.com/srthkdev/dbeaver-mcp-server.git cd dbeaver-mcp-server npm install npm run build npm link # Makes the command available globally

🖥️ Configuration

Claude Desktop Configuration

{ "mcpServers": { "dbeaver": { "command": "dbeaver-mcp-server", "env": { "DBEAVER_DEBUG": "false", "DBEAVER_TIMEOUT": "30000" } } } }

Environment Variables

  • DBEAVER_PATH: Path to DBeaver executable (auto-detected if not set)

  • DBEAVER_TIMEOUT: Query timeout in milliseconds (default: 30000)

  • DBEAVER_DEBUG: Enable debug logging (true/false)

💡 Quick Start Examples

🔍 Basic Database Operations

# List all your database connections "Show me all my database connections" # Execute a simple query "Run this query on my PostgreSQL database: SELECT COUNT(*) FROM orders WHERE date > '2024-01-01'" # Get table schema information "What's the schema of the users table in my MySQL database?" # Export data for analysis "Export all customer data to CSV from my Oracle database"

🏗️ Schema Management

# Create new tables "Create a new table called 'products' with columns id, name, price, created_at" # Modify existing tables "Add a 'description' column to the products table" # Safe table removal (requires confirmation) "I want to drop the test_table - make sure to confirm first"

📊 Business Intelligence & Analytics

# Data analysis with insights "Find the top 10 customers by order value and save this insight" # Track business findings "The Q4 sales data shows a 23% increase in mobile orders - tag this as 'quarterly-analysis'" # Review past analysis "Show me all insights related to sales performance"

🔧 Advanced Use Cases

# Performance analysis "Analyze query performance and identify slow queries in my production database" # Data quality checks "Check for missing or invalid data in the customer table" # Migration planning "Help me analyze the current schema for migrating from MySQL to PostgreSQL"

🔧 Resource Browsing

The server provides MCP resources for browsing database schemas:

  • Browse table schemas directly in your MCP client

  • Resources are automatically discovered from your DBeaver connections

  • Provides structured schema information in JSON format

🛡️ Safety Features

  • Query Validation: Automatic detection of dangerous operations

  • Confirmation Requirements: Destructive operations require explicit confirmation

  • Connection Validation: All connections are verified before operations

  • Error Handling: Comprehensive error messages and logging

  • Rate Limiting: Built-in timeouts to prevent runaway queries

🚀 Production Features

  • Comprehensive Logging: Debug mode for troubleshooting

  • Error Recovery: Graceful handling of connection failures

  • Performance Monitoring: Query execution time tracking

  • Business Context: Insight tracking for data analysis workflows

  • Multi-format Export: Support for CSV and JSON export formats

🛠️ Development

Setup Development Environment

git clone https://github.com/srthkdev/dbeaver-mcp-server.git cd dbeaver-mcp-server npm install

Available Scripts

npm run build # Build the project npm run dev # Watch mode for development npm run clean # Clean build artifacts npm run start # Start the server npm run test # Run tests (placeholder) npm run lint # Run linter (placeholder)

Publishing to npm

npm run publish # Interactive publish script npm run publish:patch # Quick patch version (1.1.3 → 1.1.4) npm run publish:minor # Quick minor version (1.1.3 → 1.2.0) npm run publish:major # Quick major version (1.1.3 → 2.0.0)

Build Scripts

  • scripts/build.sh: Build the project

  • scripts/install.sh: Install dependencies and build

  • scripts/publish.sh: Publish to npm with checks

📝 Documentation

🆚 Why Choose DBeaver MCP Server?

🏆 Industry-Leading Features

Feature

DBeaver MCP

Other MCP Servers

Database Support

200+ databases

4-5 databases

Configuration

Zero config (uses existing DBeaver)

Manual setup required

Schema Browsing

✅ MCP Resources

❌ Limited

Business Intelligence

✅ Insights tracking

❌ Not available

DDL Operations

✅ Complete (CREATE, ALTER, DROP)

⚠️ Limited

Safety Features

✅ Advanced validation

⚠️ Basic

Export Formats

✅ CSV, JSON, XML, Excel

⚠️ Limited

Error Handling

✅ Production-ready

⚠️ Basic

Cross-Platform

✅ Windows, macOS, Linux

⚠️ Limited

🎯 Perfect For

  • Data Analysts: Comprehensive database access with AI assistance

  • Database Administrators: Complete schema management and monitoring

  • Developers: Seamless integration with existing DBeaver workflows

  • Business Intelligence: Advanced analytics with insight tracking

  • Enterprise Teams: Production-ready with enterprise security features

🤝 Contributing

  1. Fork the repository

  2. Create a feature branch: git checkout -b feature/new-feature

  3. Make your changes and add tests if applicable

  4. Commit your changes: git commit -m 'Add new feature'

  5. Push to the branch: git push origin feature/new-feature

  6. Submit a pull request

📦 NPM Package

This project is published on npm as dbeaver-mcp-server:

npm package npm downloads

📝 License

MIT License - see LICENSE file for details

🙏 Acknowledgments

  • Anthropic for the Model Context Protocol

  • DBeaver for the amazing database tool

  • The open source community for inspiration and feedback

Note: This project is not officially affiliated with DBeaver or Anthropic. It's designed for real-world production use with AI assistants.

Deploy Server
A
security – no known vulnerabilities
A
license - permissive license
A
quality - confirmed to work

How are these scores calculated?

Related Resources

Tools

View all tools

Related MCP Servers

  • MySQL MCP Server

    caicongyang
    -
    security
    F
    license
    -
    quality
    A Model Context Protocol server that enables AI models to interact with MySQL databases through natural language, supporting SQL queries, table creation, and schema exploration.
    Last updated -
    3
    • Linux
    • Apple

  • IoTDB MCP Server

    -
    security
    -
    license
    -
    quality
    A Model Context Protocol server that enables AI assistants to securely interact with Apache IoTDB databases through a controlled interface for listing tables, reading data, and executing SQL queries.

  • SQL Server MCP

    cwilby
    A
    security
    A
    license
    A
    quality
    A Model Context Protocol server that enables AI assistants (Cursor, Windsurf, Claude Code) to interact with Microsoft SQL Server databases by providing connectivity through environment-configurable connections.
    Last updated -
    8
    19
    4
    MIT License

  • MCP SQL Server

    ryudg
    -
    security
    A
    license
    -
    quality
    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.
    Last updated -
    4
    2
    MIT License

View all related MCP servers

Appeared in Searches

New MCP Servers

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/srthkdev/dbeaver-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server