Metabase

Helical Insight is an open-source business intelligence and embedded analytics platform for self-hosted, cloud, on-premises, and hybrid deployments. It combines natural-language, chat-driven AI analytics with bring-your-own-LLM support, automatic SQL generation, report summarization, and insight discovery; interactive dashboards with filters, KPI widgets, drill-down and drill-through interactions, maps, charts, pivot tables, and custom JavaScript visualizations; and paginated, pixel-perfect reports for invoices, financial statements, operational reports, and regulatory reporting. Dashboards, reports, and the AI chatbot can be embedded in web applications, SaaS platforms, customer portals, and enterprise applications. Reports and dashboards can be exported to PDF, Excel, CSV, Word, HTML, JSON, and XML, scheduled for delivery by email, and distributed as personalized reports. The platform supports white labeling, multi-tenancy, row-, column-, and table-level security based on user context, and SSO through JWT, Okta, Keycloak, OAuth, and custom token-based mechanisms. It connects to relational databases, NoSQL and big-data systems, flat files, cloud storage, and APIs through native connectors, JDBC, REST APIs, custom integrations, and uploaded JDBC drivers. Docker, Kubernetes, caching, pagination, virtualization, load balancing, clustering, and REST APIs support deployment and extension, while developers can customize it with Java, JavaScript, CSS, HTML, Liquid Template Language, plugins, and custom workflows. The project states that its enterprise features are available in the free open-source version.

PostHog is an open-source product analytics and developer platform for tracking user events and journeys. It provides web analytics, session replay, feature flags, experiments, error tracking, surveys, data warehousing, and AI observability, and is used to analyze activity such as signups, downloads, posts, captions, credits, and cancellations.

Supabase is a hosted Postgres development platform for building production web, mobile, and AI applications, built from open-source components and available for self-hosting or local development. It provides a managed Postgres database, authentication and authorization, Row Level Security, auto-generated REST and GraphQL APIs, realtime database-change subscriptions over WebSockets, Edge Functions and serverless database functions, file storage, and an AI vector and embeddings toolkit. Its architecture combines PostgreSQL with services including PostgREST for REST APIs, GoTrue for JWT-based authentication and session management, Realtime for converting PostgreSQL replication changes to JSON broadcasts, Storage for S3-compatible file management with Postgres permissions, and pg_graphql for GraphQL access. It also provides dashboard tools such as table and SQL editors, policy management, deployment workflows, and official client libraries for JavaScript, Flutter, Swift, and Python, with additional community libraries for other languages.

PostgreSQL is an open-source relational database management system maintained by the PostgreSQL Global Development Group. It provides SQL-compliant, ACID transactions, MVCC concurrency, and extensibility through custom types, functions and extensions, and is used for general-purpose and enterprise database workloads.