Hacker News Reader

No direct access, but we have a custom report builder tool in the (internal) web app that lets users write SQL queries (SELECT only) against a read-only replica of the production database. They can name and save those, even put them in their navigation menu.

View on HN

Thanks. And I assume that the web app allows them to do parameterization of ids etc?

Users can put placeholders in the query (e.g. :student_id, :year) and then get prompted for those when they run the query. Results page supports filtering and sorting, and saving to CSV/Excel.

This wasn't intended as an end-user tool because few users know SQL or the database schema -- a few do. I wrote it because we get a lot of one-off or once-a-quarter requests for reports and CSV for Excel.

Reply on news.ycombinator.com