curl --request POST \
  --url https://use.hoop.dev/api/connections/{nameOrID}/dbaccess \
  --header 'Content-Type: application/json' \
  --data '{
  "access_duration_seconds": 123
}'

{
  "connection_string": "postgres://noop:noop@db.example.com:5432/mydb?sslmode=disable",
  "created_at": "2025-08-25T12:00:00Z",
  "database_name": "mydb",
  "expire_at": "2025-08-25T13:00:00Z",
  "hostname": "db.example.com",
  "id": "15B5A2FD-0706-4A47-B1CF-B93CCFC5B3D7",
  "password": "noop",
  "port": "5432",
  "username": "noop"
}