Pg_mooncake – Delta/Iceberg columnstore tables in Postgres
Hello HN, one of the founders of Mooncake Labs here. Today, we are launching pg_mooncake, an extension that brings columnstore tables with DuckDB execution to Postgres. Expect analytical performance akin to DuckDB on Parquet (clickbench results to come soon). You can run transactional updates, deletes, inserts on these tables, and they're written as Delta Lake tables (and soon Iceberg) to your object store (S3, etc.). pg_mooncake is live on Neon today. Let us know what you think. It'll be coming to Supabase shortly, and other Postgres providers in the future. Why another postgres analytics…
In plain words
pg_mooncake is a Postgres extension that adds columnstore tables to Postgres using DuckDB's execution engine. It supports transactional operations like updates, deletes, and inserts while storing data as Delta Lake tables (with Iceberg support planned) in object storage like S3. The extension delivers analytical performance comparable to DuckDB on Parquet files. It is currently available on Neon and planned for Supabase and other Postgres providers.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
Hello HN, one of the founders of Mooncake Labs here. Today, we are launching pg_mooncake, an extension that brings columnstore tables with DuckDB execution to Postgres. Expect analytical performance akin to DuckDB on Parquet (clickbench results to come soon). You can run transactional updates, deletes, inserts on these tables, and they're written as Delta Lake tables (and soon Iceberg) to your object store (S3, etc.). pg_mooncake is live on Neon today. Let us know what you think. It'll be coming to Supabase shortly, and other Postgres providers in the future. Why another postgres analytics extension? We actually leverage pg_duckdb and DuckDB as our execution engine — this is how we were able to ship the extension in just 60 days. We wrote about this with the DuckDB team: https://motherduck.com/blog/pg-mooncake-columnstore/ pg_mooncake shines in two scenarios: 1. Up-to-date analytics in Postgres - This is where having a table semantics, and not just exporting files is key. 2. Exporting Postgres Data to Iceberg/Delta Lake tables, and querying them outside of Postgres - Run ad-hoc analytics with Pandas, DuckDB, Polars. Or data transforms and processing with Polars and Spark directly on these tables. You don’t need to manage ad-hoc parquet files and complex pipelines. Mooncake Labs. We just came out of stealth today. Mooncake is a managed Lakehouse with clean Postgres and Python experiences. Our core belief is that open table formats (Iceberg and Delta) provide a lot of flexibility, and we can ensure great DevEx on top. We will bring it to more workloads, applications, developers and agents. Read about our beliefs: https://mooncake.dev/blog/3. Cheers!
Does the same job
all alternatives →
- HFHasura – Fast, instant GraphQL APIs on Postgres2018 · github.com · ▲382
- PJPostgres.js – Fastest Full-Featured PostgreSQL Client for Node and Deno2022 · github.com · ▲257
- CRCloud-Ready Postgres MCP Server2025 · github.com · ▲167
Hey HN, I built pg-mcp, a Model Context Protocol (MCP) server for PostgreSQL that provides structured schema inspection and query execution for LLMs and agents. It's multi-tenant and runs over HTTP/SSE (not stdio) Features - Supports multiple database connections from multiple agents - Schema Introspection: Returns table structures, types, indexes and constraints; enriched with descriptions from pg_catalog. (for well documented databases) - Read-Only Queries: Controlled execution of queries via MCP. - EXPLAIN Tool: Helps smart agents optimize queries before execution. - Extension…
More commerce this month
the category →
Compare your startup equity grant for free.
Commerce · 26d ago · equitybee.com
Launched alongside, October 2024
the whole month →
Softr for Notion▲925Turn Notion databases into portals & apps with no code
Dev tools · 2024 · softr.io
One inbox for all your work discussions
Work · 2024 · generalcollaboration.com