
Postico
DBeaver
DataGrip
TablePlus
QueryPie
SQLGate
Navicat
pgAdmin
DrawSQL
DBDiagram.io
Azimutt
MySQL Workbench
DbSchema
PopSQL
ChartDB
LucidChart
DrawSQL is a simple, beautiful database diagram editor for developers to ๐ง create, ๐ฌ collaborate and ๐ visualize their entity relationship diagrams.
Postico
DrawSQLPostico is recommended for software developers, database administrators, and data analysts who work with PostgreSQL databases on macOS. It's particularly beneficial for individuals who prefer a graphical user interface over command-line tools and those who need to perform database management tasks efficiently and intuitively.
No Postico videos yet. You could help us improve this page by suggesting one.
Postico might be a bit more popular than DrawSQL. We know about 17 links to it since March 2021 and only 12 links to DrawSQL. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
Postico 2 is a native Mac app for PostgreSQL and PostgreSQL-compatible databases such as Amazon Redshift, CockroachDB, and Greenplum. - Source: dev.to / about 1 month ago
Looks interesting ! I'm a fan of https://eggerapps.at/postico2/ personally but I'll check it out. - Source: Hacker News / 3 months ago
Since you mentioned it, I was always curious if the team behind TablePlus were/are connected to the team behind Postico [1]. The UIs for both (at least before Postico 2) are almost identical. [1] https://eggerapps.at/postico2/. - Source: Hacker News / almost 3 years ago
Postico is a native Mac app for Postgres databases (and some compatible databases including Amazon Redshift, CockroachDB, Greenplum, and others). It's a Mac-only app, and the UI reflects it. The person behind Postico is the same developer who built postgres.app, which starts a Postgres server on your Mac. - Source: dev.to / almost 3 years ago
Sequel pro could be compared with postico2 as far as native look and feel go - https://eggerapps.at/postico2/. - Source: Hacker News / almost 3 years ago
With this, I went for designing the db. I went to http://drawsql.app/ and created my first draft. Then exported the DDL and did a bit of back and forth with AI. This is the final draft of the database:. - Source: dev.to / 8 months ago
So I started designing the DB using this cool tool. The project has 2 tables, users and categories . The user can create many categories as he wants so the first approach I took was creating a third table, a union table to store user_id and category_id. With this solution the users are able to create x numbers of categories and we can see assign the category to the user. - Source: dev.to / over 1 year ago
Once you have generated the SQL code, you can convert it into a relational schema (the graphical table model) using DrawSQL. This tool offers:. - Source: dev.to / over 1 year ago
DrawSQL makes it easy for teams to collaborate on creating and maintaining schema diagrams. With a single source of truth, there's no need for manually syncing diagram files between different developers and offline tools anymore. Source: about 3 years ago
To be honest, since you are just getting started, I think you should reconsider simplifying this app to begin with. Built something easier and get some more experience before jumping in the ocean. Maybe start by focusing only on the parent company and sub-companies. However, I strongly recommend you to try and make a diagram of your database with relations and columns as it can you a lot of time. I personally use... Source: about 3 years ago
DBeaver - DBeaver - Universal Database Manager and SQL Client.
DBDiagram.io - Free database diagrams designer for analysts & developers ๐
DataGrip - Tool for SQL and databases
Azimutt - Next-Gen ERD to Design, Explore and Document real world databases (big and messy ones ^^)
TablePlus - Easily edit database data and structure
MySQL Workbench - MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.