I work with about a 600 table 2 TB PostgreSQL database and I started to use DataGrip, when it was in beta, for constructing complex queries. It&#x27;s quite good for writing larger queries, but also taking auto-generated queries from an ORM and re-formatting them to help with debugging application behavior.<p>For db-specific operations I still use PostgreSQL&#x27;s command-line client psql. It&#x27;s an invaluable tool, but it&#x27;s really nice to have options.<p>I also like the ability to pin query results so that I can quickly compare result sets in slightly-modified queries that I&#x27;m trying to fix.<p>Not so great at exploring the schema. Could be that I just didn&#x27;t learn the tool enough to make that easier.