CloudBeaver
Web-Based Database Management
CloudBeaver is an open source web-based database management and administration tool developed by DBeaver. Built on the architecture of DBeaver (one of the most popular database clients in the world), CloudBeaver provides a graphical interface accessible via a browser, eliminating the need to install client software on each workstation.
In TDP Kubernetes, CloudBeaver is a component exclusive to the Kubernetes edition, providing a unified web interface for administering all databases and query engines of the platform.
Why CloudBeaver?
The inclusion of CloudBeaver in TDP Kubernetes brings several benefits:
- Centralized access: manage all TDP databases from a single browser-based access point
- Zero client installation: no software installation required on user workstations
- Intuitive interface: SQL editor with autocomplete, tabular data visualization, and schema navigation
- Multi-database: supports simultaneous connections to PostgreSQL, ClickHouse, Trino, and other SQL engines
- Access control: user management and permissions per database connection
- Connection sharing: administrators can configure shared connections for the entire team
Key Features
SQL Editor
CloudBeaver provides a full-featured SQL editor with:
- Smart autocomplete: suggestions for tables, columns, and functions based on context
- Syntax highlighting: SQL syntax highlighting to facilitate reading and writing queries
- Multiple tabs: simultaneous query execution across different databases
- Query history: log of executed queries for future reference
- Result export: export in CSV, JSON, and other formats
Schema Navigation
The interface allows visually browsing the database structure:
- Exploration of schemas, tables, columns, and indexes
- Visualization of data types and constraints
- Inspection of views and stored procedures
- Visualization of DDL (Data Definition Language) for objects
Data Visualization
CloudBeaver offers flexible visualization modes for query results:
- Table mode: traditional grid view with sorting and filters
- Text mode: text format visualization for complex data
- Inline editing: direct data editing in the table (when permitted)
Connection Management
Administrators can manage connections centrally:
- Configure connections for all TDP databases
- Define which connections are shared with which users
- Configure connection templates for easier access
- Monitor active connections and user sessions
Integration with TDP Kubernetes
In TDP Kubernetes, CloudBeaver is pre-configured to connect to the following components:
| Component | Driver | Default Port | Typical Use |
|---|---|---|---|
| PostgreSQL | PostgreSQL JDBC | 5432 | Relational database administration |
| ClickHouse | ClickHouse JDBC | 8123 | Analytical queries and data exploration |
| Trino | Trino JDBC | 8080 | Federated queries across multiple sources |
| Hive Metastore | Hive JDBC | 10000 | Table metadata exploration |
Typical Workflow
- The administrator configures the TDP database connections in CloudBeaver
- Analysts access CloudBeaver via a browser and authenticate
- Shared connections automatically appear in the list of available connections
- Analysts can explore schemas, execute SQL queries, and export results
- Query history allows tracking and reusing previous queries
Architecture
CloudBeaver is composed of:
- Frontend: React web application accessible via browser
- Backend: Java server based on Eclipse Equinox (OSGi)
- JDBC Drivers: connectors for each supported database type
- Workspace: storage for configurations, connections, and user preferences
In TDP Kubernetes, CloudBeaver is deployed as a Deployment with a ClusterIP Service, accessible via Ingress Controller.
Security
CloudBeaver provides security mechanisms to protect data access:
- Local authentication: user and password management by CloudBeaver itself
- LDAP authentication: integration with LDAP/Active Directory directories for corporate authentication
- Per-connection permissions: granular control over which users can access which databases
- Read-only connections: ability to configure connections that only allow queries (SELECT)
- Audit logs: logging of all actions performed by users
In TDP Kubernetes, it is recommended to configure CloudBeaver with LDAP authentication when available, aligning with the organization's centralized authentication strategy.
Comparison with DBeaver
| Characteristic | DBeaver Desktop | CloudBeaver |
|---|---|---|
| Installation | Local (per workstation) | Centralized (server) |
| Access | Desktop application | Web browser |
| Management | Individual | Centralized by admin |
| Sharing | Manual | Shared connections |
| Features | Complete | Subset focused on queries |
| Ideal for | Development | Teams and cloud environments |
Best Practices
- Configure read-only connections for analysts who do not need to modify data
- Organize connections in folders grouping by environment (development, production) or by component
- Use connection templates to standardize configurations across the team
- Monitor active sessions to identify long-running queries that may impact performance
- Enable LDAP authentication in corporate environments to avoid credential proliferation
CloudBeaver Project Details
CloudBeaver has its Frontend developed in TypeScript/React and the Backend in Java, based on the Eclipse Equinox (OSGi) framework, sharing the same codebase as DBeaver Desktop.
CloudBeaver Resources
Source(s):