// the find
mariusandra/insights
Open Source Self-Hosted Business Intelligence Platform
A self-hosted BI tool for exploring PostgreSQL databases visually, with a focus on time-series graphs showing business metrics. It's a solo-developer project from the author of kea (the React state management library), aimed at small teams who want something lighter than Metabase or Redash and don't want Google in the loop.
Auto-detection of schema including foreign key relationships is genuinely useful — most tools make you define models manually. The kea-based state management means the frontend logic is well-organized and URL-shareable state works out of the box. The subset feature (exposing only a slice of fields to specific users) is a practical privacy control that larger tools often complicate. Monorepo structure with clear package separation (api/web/charts/desktop) makes it feasible to contribute without touching everything.
The README says 'extremely early BETA' and lists dashboards, user management, and access control as 'coming soon' — this isn't a tool you deploy to production for a team. PostgreSQL-only; no MySQL, SQLite in production, Snowflake, or anything else despite SQLite appearing in the adapter code. Last meaningful development activity seems to have plateaued well before the 2025 push date, and 76 forks with 1121 stars suggests more people looked than built. Requires Node 10+ (ancient) and the install path uses a global npm install, which is a red flag for anything you'd want to manage or update reliably.