VPNs/Accessing the Dev DB

The Humanforce VPN can be used to access the databases in each HR environment. VPN setup instructions are available here.

Accessing the Dev DB

  1. Configure and connect to the VPN by following the above steps
  2. In the DB Client of your choice, create a new DB connection
  3. Using the credentials from Keeper (“Lapis Dev RDS”), connect to the Dev DB
  4. You should now have access to all tenants as different schemas, note that to check data across all tenants, a query can be run against all schemas by appending the table name with all_ for example, to query all Business Entities, you would run the following SQL:
SELECT * FROM all_business_entities

Accessing the Prod DB

  1. Configure and connect to the VPN by following the above steps

  2. In Slack, /msg intellibot prod-db

    prod-db Command

  3. Use your favourite DB client to connect with the details provided by intellibot

Notes

  1. Special access needs to be granted before the above intellibot command will work for you. This access is only granted on an as needed basis with approval from the CTO
  2. Destructive SQL statements are blocked, including DROP, TRUNCATE and DELETE, unless you have been granted to use them
  3. All SQL queries are logged to #alert-ihr-sql-logs in Slack
  4. It is best to use the psql client as other DB clients tend to cache and prefetch a lot of data which makes it extremely slow to connect through the proxy