tags:

  • development
  • dbeaver
  • database
  • postgres
  • local related:
  • ./naming-conventions.md
  • ../../api/docker-compose.yml
  • ../../api/README.md

DBeaver Local PostgreSQL

How to connect DBeaver to the local Autimit PostgreSQL database.

Requirements

  • Docker Engine running in WSL
  • DBeaver installed on the host machine
  • Local PostgreSQL container running from the API project

Start Local PostgreSQL

From the API project:

cd ~/autimit/api
docker compose up -d postgres

Check that PostgreSQL is healthy:

docker compose ps postgres

Run migrations if needed:

bun db:migrate

Connection Settings

Create a new PostgreSQL connection in DBeaver with:

FieldValue
Hostlocalhost
Port5432
Databaseautimit
Usernameatmt_user
Passwordatmt_user

Find API Tables

After connecting:

  1. Open the autimit database.
  2. Open Schemas.
  3. Open the api schema.
  4. Open Tables.
  5. Confirm the users table exists after migrations run.

Expected table path:

autimit.api.users

Troubleshooting

If DBeaver cannot connect, check that the container is running:

docker compose ps postgres

If the database was recreated, run migrations again:

bun db:migrate

If DBeaver does not show the api schema, refresh the connection or enable all schemas in the DBeaver navigator filters.