pgAdmin contains the ERD Tool which visualizes existing schemas and allows creating new database designs.
Example from their docs: