Re:Postico – A modern PostgreSQL client for OS X
by johnyzee on Thursday February 19, 2015 @03:55PM
(#9076973)
For the web, TeamPostgreSQL[1] does most of these, like SQL autocomplete including schema object names, live editing query results, table editing, etc. It also has click-through foreign key references, look up rows that reference this one, and other smart features.
[1a] http://www.teampostgresql.com
[1b] http://teampostgresql.herokuapp.com/ (demo)