Postgres is configured with a single datasource property. It should follow the following format: postgres://username:password@host:port/database.

Example:

# DATABASE_URL defined as environment variable as
# postgres://username:password@host:port/database
datasource: ${env.DATABASE_URL}
query: select * from users;