Main features

Data Editor

CloudBeaver provides a convenient UI to show data from your tables or from custom query results. The following features are available out-of-the-box:

  • Support both relational and document-oriented databases
  • Show values of all data types
  • Read data from tables of any length
  • Filter data easily with embedded filter panel
  • Order data table by any number of columns

Data Export

You can export your data to files in multiple formats in a flexible way:

  • Export table data or custom SQL query results
  • Support multiple export formats:
    • CSV
    • XLSX (Excel spreadsheets)
    • XML
    • JSON
    • SQL INSERTs
  • Support big number of export configuration options

Entity Diagrams

You can use entity diagrams to explore your database structure, see table connections and quickly navigate your database objects. Main features:

  • Shows complete schema of your database
  • Table with columns and data types
  • Unique keys
  • Foreign keys
  • Auto layout
  • Export as PNG or SVG

SQL Editor

  • A powerful editor for your SQL scripts
  • Syntax highlighting for different SQL dialects
  • Smart auto-completion for tables, columns, procedures and SQL keywords
  • See query results in multiple tabs
  • Supports NoSQL languages for NoSQL databases (e.g. MongoDB, Cassandra, DynamoDB)

AWS Integration

Native integration with AWS IAM:

  • Hosted as EC2 instance
  • Use your AWS credentials to authorize and browse AWS databases
  • Integration with RDS authentication
  • Supported databases:
    • RDS
      • PostgreSQL
      • MySQL
      • Oracle
      • SQL Server
    • Redshift
    • DocumentDB
    • DynamoDB
    • Aurora
    • Athena
    • Keyspaces
  • Native AWS Cloud Explorer (search database across different regions)

Docker

  • Easily install using 1 docker command
  • Supports Linux, Windows and MacOS host machines
  • Ready to serve databases on the same host machine or any remote databases
  • Server configuration easily supports docker environment

SQL, NoSQL and Cloud

  • Supported relational databases:
    • PostgreSQL
    • MySQL
    • MariaDB
    • SQL Server
    • Oracle
    • Apache Hive
    • DB2 LUW
    • DB2 iSeries/AS 400
    • DB2 z/OS
    • SQLite
    • Apache Derby
    • Firebird
    • H2 Embedded
    • Trino
    • Azure Databricks
    • Informix
    • Sybase jConnect
  • Non-relational databases:
    • MongoDB
    • Apache Cassandra
    • AWS DynamoDB
    • Clickhouse
    • Couchbase
    • Greenplum
    • SAP HANA
    • InfluxDB
    • Netezza
    • Redis
    • Teradata
    • Vertica
  • Cloud:
    • Google BigTable
    • Google BigQuery
    • Snowflake

Execution plan

  • The execution plan command generates a tree of query execution as one of the result tabs and is convenient in estimating if the query or script is optimal enough.