CloudBeaver — Web-Based Database Management Client

Introduction

CloudBeaver is the web-based sibling of the popular DBeaver desktop database client. It runs as a server application and provides a rich SQL editor, visual data browser, and database administration tools accessible from any modern web browser.

What CloudBeaver Does

• Provides a browser-based SQL editor with syntax highlighting and auto-completion
• Displays table data in a spreadsheet-like grid with inline editing capabilities
• Supports connections to PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, ClickHouse, and 30+ other databases
• Manages multiple database connections with a visual navigator and metadata browser
• Offers role-based access control for shared team environments

Architecture Overview

CloudBeaver is a Java-based server built on the Eclipse Equinox OSGi framework. The backend communicates with databases via JDBC drivers bundled as plugins. The frontend is a React application that communicates with the backend through a GraphQL API. Configuration and user data are stored in an embedded H2 database by default.

Self-Hosting & Configuration

• Deploy via Docker with a single command or install from a ZIP distribution
• Configure database connections through the web UI or a JSON configuration file
• Set up user authentication with local accounts, LDAP, or SSO via OpenID Connect
• Add JDBC drivers for additional databases by dropping JARs into the drivers directory
• Place behind a reverse proxy like Nginx for HTTPS termination and custom domain access

Key Features

• Full-featured SQL editor with auto-completion, syntax highlighting, and execution plans
• Visual data editor for browsing and modifying table contents without writing SQL
• ER diagram generation for visualizing table relationships
• Multi-user support with role-based permissions and connection sharing
• Built on DBeaver's proven JDBC connectivity supporting 30+ database engines

Comparison with Similar Tools

• DBeaver — Desktop application requiring local installation; CloudBeaver runs in the browser
• pgAdmin — PostgreSQL-specific web tool; CloudBeaver supports many database engines
• Adminer — Lightweight PHP-based tool with fewer features and no multi-user support
• Beekeeper Studio — Desktop SQL client with a modern UI; not web-based
• phpMyAdmin — MySQL/MariaDB-only web tool with a dated interface

FAQ

Q: Is CloudBeaver free? A: The Community Edition is free and open source under the Apache 2.0 license. An Enterprise Edition adds extra features.

Q: Can multiple users share database connections? A: Yes. Administrators can create shared connections that are visible to specific user roles.

Q: Does CloudBeaver support SSH tunnels? A: Yes. SSH tunnel configuration is available for secure connections to remote databases.

Q: How does CloudBeaver compare to DBeaver? A: CloudBeaver provides a subset of DBeaver's features in a web interface. For heavy-duty database development, DBeaver Desktop remains more feature-rich.

Sources

• https://github.com/dbeaver/cloudbeaver
• https://cloudbeaver.io