Cloud Explorer
Note: This feature is available in Ultimate and Team editions, as well as in CloudBeaver Enterprise.
Table of contents
Overview
Cloud Explorer offers deep integration with popular cloud service providers. As of the latest version, it supports Amazon Web Services (AWS), Google Cloud Platform (GCP), and Microsoft Azure.
With Cloud Explorer, you can set up your cloud access once and then easily browse, connect, and manage your cloud databases. It saves you from manually configuring each database connection, as it reads all database endpoint information directly from the cloud provider.
Authentication is centralized. You use your cloud account to access your cloud databases. Before you start using Cloud Explorer, you need to set up your cloud provider access. This setup includes access credentials, availability zones for database search, and other cloud-specific settings.
Supported Databases
The Cloud Explorer allows you to easily connect with and manage various databases. Here is the list of databases it supports:
Providers | Databases |
---|---|
Amazon Web Services | PostgreSQL |
MySQL | |
Oracle | |
Amazon Redshift | |
Amazon Athena | |
Amazon DocumentDB | |
Amazon DynamoDB | |
Amazon Keyspaces | |
Amazon ElastiCache (Redis) | |
Amazon Timestream | |
Amazon Neptune | |
Google Cloud Platform | AlloyDB for PostgreSQL |
Microsoft SQL Server | |
PostgreSQL | |
MySQL | |
Spanner | |
Firestore | |
BigQuery | |
Bigtable | |
Microsoft Azure | Microsoft SQL Server |
PostgreSQL | |
MySQL | |
CosmosDB (MongoDB) | |
CosmosDB (Cassandra) |
Cloud configuration
To begin the configuration process, click the Cloud Explorer button located in the Toolbar. From there, you can start setting up your cloud provider access according to your needs. This involves configuring your access credentials, specifying the availability zones for database search, and adjusting other cloud-specific settings. The setup process varies depending on the cloud service provider you're using.
If this is your first time setting up, the Create Cloud Configuration dialog will open, guiding you through the setup process. Once you've set up your first cloud configuration, clicking the Cloud Explorer button will open a dialog displaying your cloud databases.
If you need to set up a new cloud configuration, you can do so by clicking the New button in the Cloud Explorer dialog. You can start setting up your new cloud provider access according to your needs.
Cloud configuration is different for each cloud service provider.
Amazon Web Services
Name | Description | Additional article |
---|---|---|
Default Credentials | Allows AWS to determine credentials using the standard credential providers. | AWS Default credentials |
AWS Profile | Allows you to choose which credentials profile you want to use. | AWS Profile |
Access/Secret Key | Allows you to choose which credentials profile you want to use. If you have an AWS Secret set up, enter it in the Connection settings. | AWS Access/Secret Key |
Single Sign-On (SSO) | Allows access to AWS resources without explicitly specifying user credentials in DBeaver connections configuration. | AWS SSO guide |
Tip: About permissions, read AWS managed policies article.
Google Cloud Platform
Name | Description | Additional article |
---|---|---|
Default Credentials | Allows GCP to determine credentials using the standard credential providers. | GCP Default credentials |
Web browser or SSO | Allows you to authorize your connection through your Google account without needing a service or user-based key file. | GCP SSO |
Access key file | Allows you to provide the path to your service or user credentials files. | GCP Access key |
Microsoft Azure
Name | Description |
---|---|
Default credentials | Utilizes Azure identity to authenticate using the identity assigned to the service or local development environment. |
Enterprise application | Represents a service principal identity in Azure Active Directory. |
Client secret | A confidential string created in the Azure portal to authenticate your application to Azure services. |
Client certificate | Uses a certificate to authenticate an application with Azure Active Directory. |
Read more about available Microsoft Azure credentials types.
Configuring SSH Tunnels
DBeaver supports SSH tunnel connections for enhanced security when accessing cloud databases. Detailed instructions for setting up SSH tunnels in DBeaver are available in the SSH Tunnel Configuration article.
Explorer
Once you've configured your cloud provider access, open the Cloud Explorer dialog and add database connections. In the top drop-down of the explorer dialog, you can select the active cloud configuration or click Edit button to change the cloud configuration.
You can see cloud databases in the center of the dialog in a hierarchical view. All databases are grouped by database/service type. When you expand one of the top elements, DBeaver will search cloud databases in configured availability zones/regions.
If you have a large number of databases in your cloud, you can search or filter them using filter text above the cloud navigator.
You can drag-and-drop cloud databases directly to database navigator view or projects view. You can also add any number of databases to your project directly from the Cloud Explorer. To do this, click on the database you want to add. Once selected, click on the Add to Project button located in the bottom right corner of the Cloud Explorer dialog, or right-click on the database and select Add to Project from the context menu. This will add the selected database to your project, making it easier to manage and navigate your databases within specific projects.
Database cloud information
You can access your cloud database configuration directly from the Database Navigator. To do this, right-click on the database you are interested in and select Edit Connection. This action opens a special tab in the connection settings dialog. The information displayed in this tab is specific to the cloud and database type of the selected database.