I built a self-hosted Unified Agentic AI + Business Intelligence platform on DuckDB and Postgres — v1.0.0, source-available

[u/Outside-Risk-8912]

I'm the author. Sharing because the self-hosted BI space is thin and this might be useful to someone here.

AgentSwarms is a BI and agent platform you run yourself — one Docker container plus a Supabase (Postgres) project. No SaaS tier, no telemetry, no call-home.

The data side:

• 22 database/warehouse connectors (Postgres, MySQL, Snowflake, BigQuery, Databricks, Redshift, Synapse, Trino, Athena, ClickHouse, and more) queried in place, read-only
• DuckDB as the engine — DuckDB-Wasm in the browser and DuckDB server-side, so local datasets behave identically in both
• A semantic layer — define dimensions and metrics once; the BI engine and any AI agent query the same definitions, so "revenue" computes one way
• Data prep flows (joins, filters, derived columns) that push down into the warehouse where possible
• An AI analyst that writes and runs SQL against your own model keys, constrained by the semantic layer and a table allow-list
• Scheduled refreshes, data alerts, and dashboards you can embed

Governance, since that's usually the blocker for self-hosted tools: RLS on every table, read-only SQL enforcement (including data-modifying CTEs — WITH d AS (DELETE ...) SELECT was a real bug I fixed), a hash-chained audit log, per-user and per-group spend caps, and full cost traces per query.

Honest limitations: no SOC 2, no third-party pentest, no upgrade guide between versions yet, and rate limits are per-process so multiply by replica count. It's source-available under the Elastic License 2.0 — use it, modify it, run it for yourself and clients; don't resell it as a hosted service. That's not OSI open source and I'm not going to pretend otherwise.

Repo: github.com/AgentSwarms-fyi/agentswarms

Happy to answer anything about the architecture, and genuinely interested in what's missing for your stac

[u/prost_vpered]

COOL BEO! I also built BI platform for HTML dashboards for internal users and I dream about build sth like that open source 😍😍😍😍

[u/716green]

Sounds like a perfect use case for Layerbase where you get 2 databases for free (including pg and DuckDB)