Best Database Clients for Heroku

A fully interactive SQL editor allows you to create and execute queries. JackDB offers everything you need in a database client: syntax highlighting and code formatting as well as intelligent autocompletion. Snippets let you save and share your most important SQL queries. Simply create and save any query in JackDB and then share the snippet with your team. Everyone has access to the latest version of a snippet if anyone updates it. JackDB is committed to security. Roles are a convenient and secure way of limiting database access to authorized users, and granting new users access to data sources. You can view everything in your database, not just views and tables. View your schemas, indexes, and other system details like tablespaces or user sessions.

Postbird is a cross platform PostgreSQL GUI client written in JavaScript and run with Electron. Views, material views and foreign tables are supported. Constraints and schemas can be connected to Heroku's Postgres. Manage extensions, procedures, users and filter tables. Edit values. Import & export tables or database tables. Comfortable query editing, including saving the last query, syntax highlight, keyboard shortcuts, query history, query history, viewing large numbers, explaining formatting, and saving results in CSV.