Graphical SQL client

Question

I have always used MySQL (or MariaDB, which is essentially the same thing) from the native command-line interface, which works fine. But I've recently started needing simultaneous access to both MySQL and Redshift at work (on Windows 10), and someone suggested I use DBeaver, a GUI for simultaneous multiple connections in multiple SQL flavors. I've started using it, and it has opened my eyes to the wonders of GUI. I can look at a list of columns, indices, or the like, without opening a new command-line window or needing to thereafter scroll back several pages! The wonders of modern technology, I tell you.

But DBeaver has one significant drawback that is slowly driving me nuts. Every time I need to export the full result set of a query to CSV or the like, I should be able to right-click, select "Export From Query", and be done. Instead, "Export From Query" is generally greyed out. Occasionally it's not, and I manage to get my result set exported, but it seems to depend on… I don't know what. Phase of the moon, maybe?

So I'm looking for an alternative. Specifically, I would like the alternative to:

• run on Windows 10 (required)
• be free (like beer) (very preferable)
• be free (like beer) or cheap (e.g., donationware) (required)
• allow access to MySQL and Redshift on different servers (required)
• not require me to type a password each time I connect (preferable)
• allow export to CSV (or tab- or pipe-delimited or the like) (required)
• allow queries to combine two SQL flavors on two servers, as e.g. where foo in({server_alias: query}) (very preferable)
• highlight syntax (preferable)
• … I'm new enough to SQL GUIs that I don't even know what additional features to look for

Answer 1

I'd recommend checking out MySQL Workbench. It's free and runs on Windows 10. It'll let you connect to multiple DBs and save your login passwords among other things.

Answer 2

As much as I do like Mysql Workbench, I have come to prefer HeidiSql Features

Free for everyone, OpenSource since 9 years of active development.
Connect to multiple servers in one window
Connect to servers via commandline
Connect via SSH tunnel, or pass SSL settings
Create and edit tables, views, stored routines, triggers and scheduled events.
Generate nice SQL-exports, compress these afterwards, or put them on the clipboard.
Export from one server/database directly to another server/database
Manage user-privileges
Import text-files
Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
Browse and edit table-data using a comfortable grid
Bulk edit tables (move to db, change engine, collation etc.)
Batch-insert ascii or binary files into tables
Write queries with customizable syntax-highlighting and code-completion
Pretty reformat disordered SQL
Monitor and kill client-processes
Find specific text in all tables of all databases of one server
Optimize and repair tables in a batch manner
Launch a parallel mysql.exe command line window using your current connection settings
And much more

Obligatory screenshot:

If you run a local server (maybe Xampp under Windows?), then you probably know phpMyAdmin; I have come to prefer the single PHP file, easy to switch between databse servers Adminer (Why is Adminer better than phpMyAdmin?)

Connect to a database server with username and password
Select an existing database or create a new one
List fields, indexes, foreign keys and triggers of table
Change name, engine, collation, auto_increment and comment of table
Alter name, type, collation, comment and default values of columns
Add and drop tables and columns
Create, alter, drop and search by indexes including fulltext
Create, alter, drop and link lists by foreign keys
Create, alter, drop and select from views
Create, alter, drop and call stored procedures and functions
Create, alter and drop triggers
List data in tables with search, aggregate, sort and limit results
Insert new records, update and delete the existing ones
Supports all data types, blobs through file transfer
Execute any SQL command from a text field or a file
Export table structure, data, views, routines, databases to SQL or CSV
Print database schema connected by foreign keys
Show processes and kill them
Display users and rights and change them
Display variables with links to documentation
Manage events and table partitions (MySQL 5.1)
Schemas, sequences, user types (PostgreSQL)
Extensive customization options

---

[Update] Here's a shot my adminer login, with a choice of two remembered sites. I have chosen not to even attempt to save passwords, on security grounds and won't try it for you for that reason. Please, give it a try & let us know.