Ask HN: Tool for getting meaningful data out of database quickly
I have a workflow that comes in every week or so, which would be someone high-ranking asking for such and such data, by this and that range of months, with this and that kind of attributes.
We have 3 SQL database (2 PostgreSQL, 1 old Oracle), and usually this involves me opening up my SQL program, writing out the query by hand, and then exporting it.
Sometimes the demand would involve a lot of tables that are scattered.
I have DataGrip which helps me, but I want something better.
I know in my head how it all works, but I would like to know if there is something on the market that lets me:
- Assign meaning to all the relationships of tables;
- Query visually by telling it (e.g.) "all drugs dispensed" after that it knows what "all drugs" means and "dispensed" means; and
- Quickly export to Google Drive or similar share-able avenues.
I can of course write SQLs, but after a while it gets very tedious. I have so many views/functions that I built up to be ready for all the demands but sometimes it gets counter-intuitive.
Do you know of a tool that helps me with this? I've tried these following tools but they seem to pitch for different business use-cases (most seem to pitch for business people who want charts, I don't want charts, I just want my Excel files).
- Google Data Studio.
- Microsoft PowerBI.
- Mode.
- Klipfolio.