# mariusandra/insights

Open Source Self-Hosted Business Intelligence Platform

Repository: https://github.com/mariusandra/insights
Canonical: https://ross.abutalabs.com/products/insights
Homepage: https://demo.insights.sh/
Language: JavaScript
License: MIT
License Family: permissive
Topics: business-intelligence, visualization, data-analytics, kea, react, insights, dashboard, feathersjs
Last push: 2025-12-09T10:25:58+00:00

## Health v2 (maintenance only)
Score: 57/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 56, release rhythm 35, longevity 100
- inputs: {"age_days": 3396, "days_push": 267, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1122, forks 76 (observed 2026-08-28T04:03:40.143194+00:00)

## What it is
Insights is a self-hosted, open-source business intelligence platform for visually exploring PostgreSQL databases and building time-based performance graphs without writing SQL. It is installed via npm and offers schema auto-detection, data filtering, and saved views through a web interface.

## Use cases
- explore a postgres database visually without writing sql
- build graphs of business metrics over time
- self-host an alternative to google data studio or looker
- auto-detect database schema and foreign keys
- create filtered subsets of data to share with marketing
- save and revisit chart views of key metrics

## When to choose
- you use PostgreSQL and want a free, self-hosted BI tool
- you want non-technical users to explore data without SQL
- you need quick time-series charts of business performance

## When to avoid
- you need a security-audited, production-hardened BI platform
- you need dashboards, exports, or access control (not yet implemented)
- your data lives in databases other than PostgreSQL

## Facets
- artifact type: application
- maturity: experimental
- function: data-visualization, analytics, search-engine, self-hosted
- domain: data-visualization, analytics, databases, self-hosted
- platform: self-hosted, cross-platform
- tags: business-intelligence, postgresql, dashboards, sql-explorer, charts, no-sql-required, nodejs, web-server

## Member repositories
- mariusandra/insights (main) score 57

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:40.143194+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:40:56.527100+00:00, confidence not recorded.
  - readme: https://github.com/mariusandra/insights (fetched 2026-08-28T04:03:40.143194+00:00, sha 176c5b18b1d6)
  - homepage: https://demo.insights.sh/ (fetched 2026-08-29T12:44:32.942518+00:00, sha 3c2cb39c0a5e)
  - registry_npm: https://registry.npmjs.org/insights (fetched 2026-08-29T12:44:32.951813+00:00, sha ec341f6de231)
- Data as of 2026-08-30T08:39:29.467469+00:00.