CloudBeaver

CloudBeaver is an open-source, self-hosted web application that provides a graphical interface for managing and querying various database systems. It functions as a web server that allows users to interact with their databases through a browser rather than a local desktop installation. This approach centralizes database access, allowing teams to collaborate on queries and data exploration without requiring every user to configure local drivers or environment variables.

The software is typically deployed as a server application, with official support for running within Docker containers. It provides a centralized environment where administrators can manage database connections and users can execute queries and explore data structures via a web-based frontend. The system is designed to handle various connection properties, including the ability to set values to NULL in driver properties and the use of custom startup arguments for containerized environments.

Key features

• SQL Editor with fuzzy search auto-completion for object names
• Data Editor with multi-cell copy-paste and find-and-replace functionality
• Navigator tree for browsing database structures and containers
• DDL generation options from the Data Editor and Result Set
• Support for multiple database systems including PostgreSQL, MySQL, ClickHouse, and DuckDB
• References panel to explore table relationships via foreign keys
• Administrative controls for user management and SSH tunneling restrictions
• HTTP header authentication for GraphQL queries using API tokens

The application is built using a Java backend and a frontend developed with TypeScript and React. It includes a variety of database drivers to ensure compatibility with different SQL dialects and specific database behaviors, such as the DELIMITER keyword in MySQL or GEOMETRY types in DuckDB. The Data Editor maintains the state of column configurations, including filters and sorting, across page refreshes and re-logins. For accessibility, the interface includes keyboard shortcuts and WCAG compliant contrast settings for both light and dark themes.

CloudBeaver is designed for database administrators and developers who require a web-based interface for database management.