DbAlchemy

DbAlchemy is a set of database tools that can control Postgres, MySql/MariaDb, Sql Server, Oracle and SqLite databases.

A free and paid for version is available from the website.

On first connection to a database it discovers all tables and columns together with their properties and foreign key relationships. The tools avalable include:

Database Copy/Migration - to any supported database type

Advanced View/Edit - That can show foreign key columns to any depth and can display all foreign keys pointing to a given row.

Entity Relationship Diagram - Automatically generated, position and content can be adjusted by user, can be saved to a .svg file.

Schema Editor - Allows the structure of a database to be created or edited.

SQL Queries - Can be constructed manually in the SQL dialect relevant to the database. Results can be displayed in a table and form.

Find/Replace - Allows for a controlled search of a database table followed by optional replace of selected field