I've always found database structure diagrams to be useful, and I like tools that synchronize editing the structure via the diagram or the SQL code.

I believe the macOS app OmniGraffle can do this, like Microsoft Visio on Windows.

I currently have a copy of Database Designer installed on an Android tablet, it's quite effective for my simple projects.

https://play.google.com/store/apps/details?id=com.klim.dbdes...

Database Designer developer says the app is "free forever", which is nice. App stores note in-app purchases; these are voluntary donations like "Buy Me a Coffee".

The app also has some brief demo videos that are linked as online help.