Connect to the manage database in DataGrip

This guide explains how to connect DataGrip to the local Inkeep manage database and run branch-scoped queries on a project branch.

Download DataGrip

Install the latest version of DataGrip from JetBrains: DataGrip download.

In DataGrip, go to: File -> New -> Data Source -> PostgreSQL -> PostgreSQL.

Use this URL:

jdbc:postgresql://localhost:5432/inkeep_agents?user=appuser&password=password

Or fill the fields with these values:

Click Test Connection and confirm it succeeds.

In Database Explorer, click the 3 dots next to No databases selected and select all databases.

Select the inkeep_agents database and click Go to DDL.

In the query console, check out the project branch first, then run your SQL.

Example for the default sample project:

SELECT DOLT_CHECKOUT('default_activities-planner_main');
SELECT * FROM skills;

General branch pattern:

SELECT DOLT_CHECKOUT('{tenant_id}_{project_id}_{branch}');

Run queries with Cmd/Ctrl + Enter, then choose the statement to execute.

Query results appear in the bottom panel of the IDE.