| I am very comfortable in the command line and still work with databases in IDEA. It gives you: — autocompletion for everything — table/function names, types; very helpful on projects with hundreds to thousands of tables — navigation ("jump to referenced table", "find foreign keys to this column", etc) — data export in two dozen formats (configurable) — exactly the same UI for working with 30 database engines (or however many it supports, I'm too lazy to count). Especially helpful with databases that have atrocious CLI clients, like Oracle. — a nice tree-structured view of your database; or you can generate a (possibly vector) diagram for the rare case when that helps — high quality autoformatter that works for every SQL dialect it supports, and in the same way — minor things like the ability to extract a subquery with a couple of key presses, or rename a table alias Probably something else I'm forgetting. Saving a couple of keystrokes when writing SQL has little to do with it. |