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
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
- 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
- RDS
- Native AWS Cloud Explorer (search database across different regions)
SQL and NoSQL
- Supported relational databases:
- PostgreSQL
- MySQL
- MariaDB
- SQL Server
- Oracle
- Hive
- Non-relational databases
- MongoDB (DocumentDB)
- Cassandra
- AWS DynamoDB
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.