DataGrip

DataGrip

You can connect to CedarDB using DataGrip, the powerful cross-platform JetBrains IDE for databases. You can use DataGrip to connect to CedarDB and view your database, manage your schema, and insert or update values in tables.

Set up DataGrip

Install DataGrip

Install DataGrip according to the instructions on the download page.

Start DataGrip

After starting DataGrip, and before you connect to CedarDB, the initial interface will be empty.

DataGrip interface

Add a CedarDB connection

To connect to CedarDB, create a new data source connection with the shown keyboard shortcut or by clicking the “+” icon. In the now open menu, select PostgreSQL

data source menu

In the following wizard, enter your CedarDB connection settings like so:

CedarDB connection settings

After DataGrip has downloaded the driver, check your connection by clicking on the “Test Connection” button. In case your system needs advanced configuration, please refer to the official documentation.

Select schemas

After setting up the date source, you need to configure which schemas DataGrip should introspect and show. To use all visible schemas of the database, select the corresponding checkbox and apply your changes.

select all schemas

Features

This is a brief overview of the features you can use with DataGrip. For more in-depth information, use DataGrips’s getting started guide.

Tables

When you select a table in the Database Explorer, you can view and edit the data contained in the table.

table view

Queries

To write SQL queries, you can open the Database console and enter arbitrary SQL to execute them in the current database.

SQL console