Seqora

Seqora is a desktop SQL client for PostgreSQL, MySQL, MariaDB and SQLite. Run a query, edit rows, or open a diagram to see how your tables fit together.

The schema designer in Pro is the part I wanted most. Add a table or draw a foreign key on the diagram, and Seqora writes the SQL so you can read it before you apply anything. When a query is slow, Visual EXPLAIN shows how rows move through the plan and where the query spends its time.

The SQL editor, row editing and read-only schema diagrams are free. Seqora runs on Windows and Apple silicon Macs. You can download it and get started without an account.