Pg_mooncake – Delta/Iceberg columnstore tables in Postgres

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

Real-time analytics on Postgres tables. Contribute to Mooncake-Labs/pg_mooncake development by creating an account on GitHub.

docker run --name mooncake --rm -e POSTGRES_PASSWORD=password mooncakelabs/pg_mooncake This will start Postgres with pg_mooncake preinstalled. You can then connect to it using psql with the default user postgres : docker exec -it mooncake psql -U postgres Option 2: From Source To build pg_mooncake, first install Rust , pgrx , and the build tools for DuckDB . git clone --recurse-submodules https://github.com/Mooncake-Labs/pg_mooncake.git To build and install for Postgres versions 14-18, run: cargo pgrx init --pg18= $( which pg_config ) # Replace with your Postgres version make pg_duckdb # Skip if pg_duckdb is already installed make install PG_VERSION=pg18 Finally, add pg_mooncake to…from github.com

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…

• 
  Supabase2024 · supabase.com · ▲2,325

  The Postgres developer platform is now generally available

• 
  pg_flame – flamegraph visualizations of PostgreSQL query plans2019 · github.com · ▲321

  A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame

• 
  Postgres.js – Fastest Full-Featured PostgreSQL Client for Node and Deno2022 · github.com · ▲257

  Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare - porsager/postgres

• 
  Neon2024 · neon.com · ▲183

  Postgres got serverless, no more infra babysitting

• 
  bit.io2021 · ▲130

  All your data in one place

• 
  Cloud-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…

• 
  buzzabout▲1,267

  Audience insights from 1B+ online discussions in 2 mins

  AI · 2024 · buzzabout.ai

• 
  bolt.new▲1,230

  Build and scale high-performing websites & apps using your words. Join millions and start building today.

  AI · 2024 · bolt.new

• 
  Feta▲1,217

  Run smarter stand-ups, build better products

  AI · 2024 · feta.io

• 
  Trag▲955

  AI code review companion

  AI · 2024 · usetrag.com

• 
  Softr for Notion▲923

  Turn Notion databases into portals & apps with no code

  Dev tools · 2024 · softr.io

• 
  General Collaboration▲910

  One inbox for all your work discussions

  Work · 2024 · generalcollaboration.com