I haven't seen anyone here mention DataGrip, so here goes:
If you work with a database you should try DataGrip. It is the best client I've ever used, for every single database I've tried it with (mostly Postgres, some SQLite and Redshift as well). Autocomplete just works, it will create schema diagrams for you that are accurate and useful, it's data export tools are obvious and fast. I pay for a license personally for use on side projects, and use it at work on a daily basis.
If you work with a database you should try DataGrip. It is the best client I've ever used, for every single database I've tried it with (mostly Postgres, some SQLite and Redshift as well). Autocomplete just works, it will create schema diagrams for you that are accurate and useful, it's data export tools are obvious and fast. I pay for a license personally for use on side projects, and use it at work on a daily basis.