Skip to main content
Glama

DBeaver MCP Server

by srthkdev
MIT License
47
12
  • Apple
  • Linux

DBeaver MCP Server

A Model Context Protocol (MCP) server that integrates with DBeaver to provide AI assistants access to 200+ database types through DBeaver's existing connections. This MCP server is designed to be production-ready and feature-complete for real-world usage with Claude, Cursor, and other MCP-compatible AI assistants.

🚀 Features

  • Universal Database Support: Works with all 200+ database types supported by DBeaver
  • Zero Configuration: Uses your existing DBeaver connections
  • Secure: Leverages DBeaver's credential management
  • Cross-Platform: Works on Windows, macOS, and Linux
  • Production Ready: Full error handling, logging, and safety checks
  • Resource Support: Browse table schemas through MCP resources
  • Business Insights: Track and store analysis insights with tagging
  • Multiple Export Formats: CSV, JSON export capabilities
  • Schema Management: Complete DDL operations (CREATE, ALTER, DROP)
  • Safety First: Built-in query validation and confirmation prompts
  • Version Compatibility: Supports both legacy DBeaver (6.x) and modern DBeaver (21.x+) configurations

🔧 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

ToolDescriptionSafety Level
list_connectionsList all DBeaver database connections✅ Safe
get_connection_infoGet detailed connection information✅ Safe
execute_queryExecute SELECT queries (read-only)✅ Safe
write_queryExecute INSERT, UPDATE, DELETE queries⚠️ Modifies data
create_tableCreate new database tables⚠️ Schema changes
alter_tableModify existing table schemas⚠️ Schema changes
drop_tableRemove tables (requires confirmation)❌ Destructive
get_table_schemaGet detailed table schema information✅ Safe
list_tablesList all tables and views in database✅ Safe
export_dataExport query results to CSV/JSON✅ Safe
test_connectionTest database connectivity✅ Safe
get_database_statsGet database statistics and info✅ Safe
append_insightAdd business insights to memo✅ Safe
list_insightsList 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

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)

💡 Usage Examples

Basic Operations

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

Advanced Operations

  • Schema management: "Create a new table called 'products' with columns id, name, price"
  • Data analysis: "Find the top 10 customers by order value and save this insight"
  • Safety checks: "I want to drop the test_table - make sure to confirm first"

Business Intelligence

  • Track insights: "The Q4 sales data shows a 23% increase in mobile orders - tag this as 'quarterly-analysis'"
  • Review analysis: "Show me all insights related to sales performance"

🔧 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

🔄 Comparison with Other MCP Servers

This DBeaver MCP server provides:

  • ✅ Universal database support (200+ databases vs. 4-5 in most MCP servers)
  • ✅ Resource-based schema browsing
  • ✅ Business insights tracking
  • ✅ Complete DDL operations (CREATE, ALTER, DROP)
  • ✅ Advanced safety features
  • ✅ Multiple export formats
  • ✅ Production-ready error handling
  • ✅ Cross-platform compatibility

🤝 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:

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

Related MCP Servers

  • -
    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
  • -
    security
    F
    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.
    Last updated -
    • Apple
  • 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
    14
    2
    MIT License
  • -
    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 -
    7
    2
    MIT License

View all related 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