Polynya
Turn your Postgres into workspaces for AI
Details
- External ID
- 47914821
- Source
- HN
- Company
- —
- Product
- Polynya
- Website domain
- polynya.dev
- Launched
- April 26, 2026
- Cohort
- —
- Upvotes
- 5
- Upvotes percentile
- 0.11182519280205655
- Tags
- —
- Fetched at
- Sept. 7, 2026, 9:26 p.m.
- Updated at
- Sept. 7, 2026, 9:26 p.m.
Description
The idea is simple: AI agents need real-time data to be useful. But streaming real-time data into your data warehouse means you need the data warehouse to be up 24/7. This is expensive and wasteful. What if you could spin up an ephemeral data warehouse only when your agent needs it, and get real-time data at the same time?The solution: Polynya replicates your data into Iceberg, and gives your agent an ephemeral ClickHouse instance on demand. Polynya also provides persistent workspaces — collections of views that survive across sessions. So from your agent's point of view, it's a 24/7 data warehouse.At its core, Polynya is a data platform for streaming real-time data from Postgres to Iceberg. But instead of spending hours setting up costly and complex pipelines involving Kafka, Debezium, Flink, etc., Polynya lets you do this with just one command:npx polynya createIt's currently free on early access, so do try it out and give me any feedback! Currently there is no web dashboard yet (coming soon), you interact with it 100% through CLI.P.S. Polynya is built on top of pg2iceberg, the open source Postgres to Iceberg replication tool I've been building for the past few weeks: https://pg2iceberg.dev/
Enrichment
- Theme
- database infrastructure and developer tools
- Vertical
- Horizontal
- Function
- Agent / copilot
- Audience
- Developer
- AI stance
- AI-native
- Project type
- Commercial product
- Normalized one-liner
- ai workspaces on top of postgres databases
- Manually corrected
- False
Could you build this?
No Continuously streaming Postgres replication streams to Apache Iceberg and orchestrating on-demand ephemeral ClickHouse instances requires advanced distributed systems and data engineering infrastructure.
What it would actually take: The system requires a distributed change data capture (CDC) engine reading Postgres logical replication slots (WAL) and translating them into micro-batched Parquet files committed to Apache Iceberg metadata catalogs every 30 seconds. Additionally, it requires an orchestration control plane (e.g., on Kubernetes or Fly.io) that can instantly spin up and tear down isolated ClickHouse compute nodes wired to query the Iceberg object store. This requires senior expertise in database internals, CDC pipelines, analytical storage engines, and container orchestration.
Discussion
No comments on this launch.
Competitors
Other products that read as similar to this one — 72 launches clear the similarity bar, closest 8 shown.
Attention rank: #69 of 73 (itself plus its competitors, highest first — normalized so YC and Product Hunt are compared fairly).
Launched 179 days after the earliest competitor.
- Poly Studio · ph · 2026-09-30 · 2 upvotes · similarity 0.42
- Artie · hn · 2026-06-10 · 26 upvotes · similarity 0.42
- Streambed · hn · 2026-05-31 · 129 upvotes · similarity 0.42
- Pgclaw · hn · 2026-02-12 · 48 upvotes · similarity 0.41
- Managed Postgres with native ClickHouse integration · hn · 2026-01-22 · 45 upvotes · similarity 0.40
- Public Apache Iceberg datasets via a REST catalog · hn · 2026-01-15 · 13 upvotes · similarity 0.39
- PostgreSQL Migrator · ph · 2026-09-17 · 2 upvotes · similarity 0.39
- AI-first PostgreSQL client for Mac · hn · 2026-04-02 · 7 upvotes · similarity 0.38
Other launches for this product
- No other launches for this product.
Same idea, different domain
Nobody's really built a agent / copilot tool for Agriculture yet.