HN Showcase
Back to browse
Polynya – Turn your Postgres into workspaces for AI

Polynya – Turn your Postgres into workspaces for AI

by hasyimibhar·Apr 26, 2026·5 points·0 comments
Visit ProjectView on HN

AI Analysis

●●SolidBig BrainShip It

Ephemeral ClickHouse on demand beats Kafka pipelines — but early access limits confidence.

Strengths
  • •One-command setup (npx polynya create) replaces hours of Kafka, Debezium, and Flink configuration.
  • •Persistent workspaces save views across sessions so agents build compound analytical layers.
  • •30-second sync intervals on all tiers without requiring 24/7 warehouse infrastructure.
Weaknesses
  • •Early access stage with limited documentation on reliability, scaling, or production readiness.
  • •Competes with established data pipeline tools (Fivetran, Airbyte) that already handle Postgres replication.
Target Audience

Developers building AI agents that need real-time database access

Similar To

Fivetran · Airbyte · Materialize

Post 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 create

It'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/

Similar Projects