I've been looking for an affordable editor and use web storm with the dba plug-in right now. It kinda works for postgres, but not quite.

Although this tool, 0xDBE, doesn't look to have any DBA features like the OP was requesting.