[gabriel]

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'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.

For db-specific operations I still use PostgreSQL's command-line client psql. It's an invaluable tool, but it's really nice to have options.

I also like the ability to pin query results so that I can quickly compare result sets in slightly-modified queries that I'm trying to fix.

Not so great at exploring the schema. Could be that I just didn't learn the tool enough to make that easier.

[bigtunacan]

I'll second the exploring the schema bit. Overall I'm really impressed with JetBrains tools, in this case however not so much. Schema exploration is pretty critical in a database tool. While it is useful; it isn't able to replace other database tools I need so I've just continued working with my existing tools rather than adding yet another to the mix.

[Lord_Cheese]

I found the SB Navigator plugin solved the weirdness of navigating a schema. I've been using DataGrip for Oracle and MySQL a lot lately and absolutely love it!