Google Looker
Modern BI platform for governed data modeling and dashboards
Insights
Self-hosted visual analytics for PostgreSQL business performance
Insights provides a free, self-hosted interface to explore PostgreSQL data, create time-based charts, filter results, and share custom subsets, mimicking Google Data Studio without external dependencies.
Overview
Highlights
Auto-detects schema and foreign keys
Multi-database connections with custom SQL fields
Interactive time-based charts with split-by dimensions
Saved views, pinned fields, and keyboard navigation
Pros
- Free and self-hosted
- Works directly with PostgreSQL
- Rich interactive visualizations
- Easy installation via npm
Considerations
- Early beta – no security audit
- Limited mobile support
- Feature set still growing
- No built-in authentication or access control yet
Managed products teams compare with
When teams consider Insights, these hosted platforms usually appear on the same shortlist.
Looking for a hosted option? These are the services engineering teams benchmark against before choosing open source.
Fit guide
Great for
- Small to medium teams needing quick PostgreSQL dashboards
- Developers who prefer JavaScript‑based tooling
- Organizations wanting to keep data on-premise
- Startups looking for a cost‑free BI alternative
Not ideal when
- Enterprises requiring audited security and SSO
- Teams needing extensive mobile or offline access
- Projects that depend on non-PostgreSQL data sources
- Users expecting out-of-the-box export to PDF/XLSX
How teams use it
E‑commerce sales tracking
Visualize revenue trends and user acquisition by country
Marketing campaign analysis
Filter leads and compare conversion rates over time
Finance reporting
Create subsets for CFO with revenue and expense charts
Product usage monitoring
Split active users by platform to spot adoption patterns
Tech snapshot
JavaScript71%
TypeScript23%
CSS6%
HTML1%
Frequently asked questions
What databases does Insights support?
It currently connects to PostgreSQL instances.
How is the application installed?
Install via npm, then run `insights init` and `insights start`.
Is there authentication?
Not yet; authentication and access control are planned for future releases.
Can I embed charts in other apps?
Future roadmap includes an API for embedding React or iframe components.
Is there a mobile-friendly UI?
Mobile support is limited now; improvements are upcoming.
Project at a glance
Active- Stars
- 1,114
- Watchers
- 1,114
- Forks
- 75
LicenseMIT
Repo age8 years old
Last commitlast month
Self-hostingSupported
Primary languageJavaScript
Last synced 3 hours ago