DEV Community

loading...

Use Heroku Dataclips to share query and do ad-hoc data exports

swanson profile image matt swanson Originally published at boringrails.com on ・1 min read

Heroku Dataclips enable you to create SQL queries for your Heroku Postgres databases and share the results with colleagues, third-party tools, and the public. Recipients of a dataclip can view the data in their browser and also download it in JSON and CSV formats.

Heroku Dataclips

Usage

If you are hosting your app on Heroku, you might need to run some ad-hoc queries or share a report. Instead of generating an admin page or a CSV report, you can make a Dataclip that attaches to your production database and run raw SQL queries.

The editor has autocomplete features for tables and columns and you can export the data to CSV or JSON.

Super handy for one-off SQL queries or barebones reporting and way better than having to rails c or dig up the raw connection string!

Additional Resources

Heroku Blog: A Dialog with Your Data Using the New Dataclips

Heroku Blog: Share your Heroku Postgres data with the new Dataclips


Discussion (0)

pic
Editor guide