What I found invaluable is the use of Kate (yes the editor) SQL plugin. It can connect to MySQL/MariaDB, Postgres and others. The main benefit is that you can

What I found invaluable is the use of Kate (yes the editor) SQL plugin. It can connect to MySQL/MariaDB, Postgres and others. The main benefit is that you can organize your SQLs in files or even better in markdown files. God knows how many times I had to retype the same or a very similar SQL in the past.