# Polynya

> Turn your Postgres into AI-ready data workspaces.

Polynya streams your Postgres to Iceberg every 30 seconds. Your AI agents get their own ephemeral ClickHouse instance on demand — not your production database. Build workspaces (collections of views) that persist across sessions. From your agent's point of view, it's a 24/7 data warehouse.

## How it works

1. Connect your Postgres: `npx polynya create --all`
2. Build workspaces: create collections of views your agents can query
3. Let your agents query: connect Polynya as an MCP server

## Quickstart

```
npx polynya create --all
```

## MCP

Connect Polynya as an MCP server so your AI agent can query your data:

```
claude mcp add --transport http polynya https://api.polynya.dev/mcp
```

## Features

- **Always fresh**: Data syncs every 30 seconds. No Kafka, no Debezium, no Airflow.
- **Workspaces that compound**: Create workspaces — collections of views that persist across sessions. Analytics, fraud, experimentation. Your agent builds up an analytical layer over time.
- **Your agent's own database**: An ephemeral ClickHouse spins up when your agent queries and shuts down when it's done. Your production database never sees the query.

## Use cases

- **Product analytics**: Revenue breakdown, user metrics, retention analysis
- **Fraud detection**: Surface suspicious patterns, save fraud rules as persistent views
- **Performance monitoring**: Track latency, match times, SLOs with visualizations
- **Customer data platform**: Unify user profiles, segment audiences, track lifecycle events
- **Experimentation**: Analyze A/B tests, compare variants, measure uplift

## Pricing

Free during early access. No credit card required. No egress fees. No per-row charges.

- **Free**: 1 project, 5 tables, 1 workspace (10 views), ephemeral ClickHouse, 30s sync
- **Pro $39/mo**: 3 projects, 25 tables, unlimited workspaces & views (coming soon)
- **Team $99/mo**: 10 projects, unlimited tables, 10 team members (coming soon)

## Links

- Website: https://polynya.dev
- MCP endpoint: https://api.polynya.dev/mcp
- CLI: https://www.npmjs.com/package/polynya
- Built on pg2iceberg: https://pg2iceberg.dev