Basic operations

Table of contents

• First access
• Database navigator
• Object editor
• Basic operations
  • How to create the first connection
  • Object creation
  • Work with data
  • Execute SQL queries

This guide outlines the essential steps to quickly get started with CloudBeaver.

First access

When you open CloudBeaver in your browser for the first time, you’ll land directly on the login page. After logging in, you can start working with your databases right away.

Tip: For a detailed understanding of CloudBeaver interface, refer to the Application Window Overview article.

Database navigator

After logging in, you’ll see the Database Navigator. It’s your main workspace for accessing and managing databases.

• To start, create a connection to a database.

• To explore the database objects, click on the arrow next to a database name to expand and see tables, views, and other metadata objects.

Object editor

From the Database Navigator, you can open the Object Editor to explore and manage database objects.

Double-click a table or other object to open it. The Object Editor provides detailed tabs for working with your data.

The Object Editor has three tabs to organize your work:

Tab	Description	Reference article
Properties	View and edit the properties of the database object.	Properties Editor
Data	Open the Data Editor to manage table and view data.	Data Editor
Diagram	Visualize table relationships with Entity-Relationship Diagrams.	Diagrams

Basic operations

Now let’s explore how to manage your data in CloudBeaver.

How to create the first connection

After logging in, create your first database connection:

1. Click New Connection on the welcome page.

   

2. Select your database type from the list.

3. Enter connection details:

   • Host.
   • Port.
   • Database name.
   • Database credentials.

4. Test the connection, then click Finish.

Tip: For a full list of supported databases, see Supported Databases.

Object creation

Create new objects like tables, views, or schemas using SQL scripts.

1. In the Database Navigator, locate your database.

2. Click Open SQL Editor button in the top toolbar.

   

3. Write your SQL script:

   Example:

   CREATE TABLE example_table (
       id INT PRIMARY KEY,
       name VARCHAR(100)
   );

4. Run the script:

   • Click the Execute SQL Statement button or press Ctrl+Enter to run it and create the object.

Tip: See more information on SQL Editor.

Work with data

1. View and edit data:

   • Double-click a table in the Database Navigator, or right-click it and select Open.
   • Edit data directly in the grid and click Save.

   

2. Insert new data:

   • Click the Add button to add new records.
   • Fill out the row and click Save.

3. Delete data:

   • Select rows and click the Delete selected button .
   • Confirm and save changes.

Tip: See more information on Data Editor.

Execute SQL queries

1. In the Database Navigator, locate your database.

2. Click Open SQL Editor button in the top toolbar.

3. Write your query:

   1. In the SQL Editor, type your SQL query.

      Example: SELECT * FROM Album;.

      

      Tip: Use AI SQL Assistance to improve your SQL scripts.

   2. Press Ctrl+Enter or right-click the query and click Execute SQL Statement button.

4. View results:

   • Results appear in the bottom panel of the SQL Editor.

Tip: Want to work faster? Check out the list of available keyboard shortcuts in Shortcuts.