# BemiHQ/BemiDB

Open-source Snowflake & Fivetran alternative, with Postgres compatibility.

Repository: https://github.com/BemiHQ/BemiDB
Canonical: https://ross.abutalabs.com/products/bemidb
Language: Go
License: AGPL-3.0
License Family: copyleft
Topics: analytics, data-lakehouse, data-warehouse, duckdb, iceberg, olap, parquet, postgresql, zero-etl, data-movement, zero-pipeline
Last push: 2026-01-07T18:55:38+00:00

## Health v2 (maintenance only)
Score: 55/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 61, release rhythm 53, longevity 47
- inputs: {"age_days": 667, "days_push": 238, "days_rel": 238, "gap_med": 0, "n_releases_24m": 144}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1531, forks 43 (observed 2026-08-28T04:04:59.394546+00:00)

## What it is
BemiDB is an open-source analytical data warehouse that combines built-in data source connectors (like Fivetran) with a Postgres-compatible OLAP query engine (like Snowflake), syncing data in compressed columnar format to S3. It is packaged as a single Docker image with stateless processes and leverages an Iceberg-based open table format.

## Use cases
- centralize data from multiple sources without building ETL pipelines
- run fast analytical queries on Postgres data without impacting production
- query data warehouse with Postgres-compatible BI tools, notebooks, and ORMs
- continuously archive historical data from a Postgres database to S3
- self-hosted Snowflake alternative for a data lakehouse on S3
- sync SaaS data sources like Amplitude, Attio, and Dialpad into a warehouse

## When to choose
- you want a self-hosted, open-source alternative to Snowflake plus Fivetran in one tool
- you need Postgres wire compatibility so existing BI tools and ORMs work unchanged
- you want zero-ETL syncing from Postgres or SaaS sources into columnar storage on S3
- you prefer a single Docker image deployment with compute/storage separation

## When to avoid
- you need a fully managed cloud data warehouse with elastic multi-node scaling
- you require strict OLTP transactional workloads rather than analytics
- your organization cannot use AGPL-3.0 licensed software
- you need connectors for data sources not yet supported by its built-in syncs

## Facets
- artifact type: service
- maturity: active
- function: database, etl, search-engine, self-hosted
- domain: databases, analytics, big-data, self-hosted
- platform: self-hosted, go
- tags: data-warehouse, olap, data-lakehouse, zero-etl, postgres-compatible, duckdb, iceberg, parquet, s3, columnar-storage, snowflake-alternative, fivetran-alternative, data-engineering, docker, linux, macos

## Member repositories
- BemiHQ/BemiDB (main) score 55

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:59.394546+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-30T04:31:20.918990+00:00, confidence not recorded.
  - readme: https://github.com/BemiHQ/BemiDB (fetched 2026-08-28T04:04:59.394546+00:00, sha 19f23ac6c1d4)
- Data as of 2026-08-30T08:39:29.467469+00:00.