Exploring a Postgres database with the GTInspector https://www.youtube.com/watch?v=BtfgK7Wcx5o -- with a sufficiently powerful IDE, a query GUI and API blur.