DBeaver
You can connect to CedarDB using DBeaver Community, the free universal database tool. You can use DBeaver to connect to CedarDB and view your database, manage your schema, and insert or update values in tables.
Set up DBeaver
Install DBeaver
Install DBeaver Community from its download page.
Start DBeaver
After starting DBeaver, and before you connect to CedarDB, the initial interface will be empty.
Add a CedarDB connection
To connect to CedarDB, create a new database connection with the shown keyboard shortcut or by clicking the
corresponding
icon.
In the following wizard, you can use the PostgreSQL driver to connect to CedarDB.
![connect to a database wizard](/docs/images/dbeaver/3_connect.png)
In the next screen, enter your CedarDB connection settings like so:
![CedarDB connection settings](/docs/images/dbeaver/4_connect_details.png)
Test the connection
You can test the connection with the “Test Connection …” button, which verifies your connection credentials. When everything is correct, the test completes successfully.
![successful connection test](/docs/images/dbeaver/5_connect_test.png)
In case your system needs advanced configuration, please refer to the official docs.
Features
This is a brief overview of the features you can use with DBeaver. For more in-depth information, use DBeaver’s getting started guide.
Schema
For an overview of your database, you can open its schemas in the database navigator view on the left. This shows the current schema with all visible tables and their used storage space. When you select a schema, you can also display an entity diagram showing all tables with their relations as connections by foreign keys.
Tables
When selecting a table, you can see all its columns in the Properties tab shown below. In the second tab, “Data”, you can view and edit the data contained in the table.
Queries
To write SQL queries, you can open the SQL Editor via the menu bar, or with the SQL toolbar entry. In this editor, you can enter arbitrary SQL scripts and execute them in the current database. This DBeaver SQL editor has convenient auto-complete functionality to help you write SQL queries quickly.