Blog Posts

Insights and articles about DuckDB, data engineering, serverless and open source.

TypeScript scripts as DuckDB Table Functions

Query REST APIs, GraphQL endpoints and web pages with SQL by using Bun TypeScript scripts as DuckDB table functions via the shellfs and arrow extensions.

December 10, 2025
3 min read
typescriptarrowduckdb

Use your favorite AI tool to read the latest AWS News

Connect Claude, Claude Code, Cursor, VS Code Copilot or Amazon Q to the unofficial AWS News MCP server, which aggregates 40+ AWS news feeds.

October 14, 2025
3 min read
aiawsagent

Using Amazon SageMaker Lakehouse with DuckDB

Query S3 Tables through Amazon SageMaker Lakehouse and the AWS Glue Iceberg REST catalog with DuckDB, including IAM role and Lake Formation setup.

June 8, 2025
5 min read
gluesagemakerduckdb

Welcome to the age of $10/month Lakehouses

Compare Iceberg, Delta Lake and DuckLake, then deploy a serverless DuckLake lakehouse for about $10 a month on Cloudflare Containers, R2 and Neon Postgres.

May 30, 2025
19 min read
data-lakelakehouseduckdb

Using DuckDB databases as lightweight Data Lake access layer

Share Parquet data in S3 or R2 via a small DuckDB database file of views: a lightweight, low-cost data lake access layer that is queryable with plain SQL.

May 17, 2025
7 min read
data-analyticsdata-lakeduckdb

Handling GTFS data with DuckDB

Load GTFS public transit schedule feeds into a DuckDB database, query stops, routes and trips with SQL, and export the data to Parquet.

May 16, 2025
7 min read
data-engineeringduckdbgtfs

Cost-efficient event ingestion into Iceberg S3 Tables on AWS

Compare three serverless architectures for ingesting events into Apache Iceberg S3 Tables via Amazon Data Firehose, then query the data with Athena and DuckDB.

April 10, 2025
13 min read
cloudflareawsserverless

Query S3 Tables with DuckDB

Step-by-step guide to set up an Amazon S3 Table bucket and query its Apache Iceberg tables with DuckDB, including IAM permissions, secrets and catalog attach.

March 14, 2025
4 min read
awss3iceberg

Querying IP addresses and CIDR ranges with DuckDB

Look up whether an IP address belongs to a CIDR range in DuckDB with three reusable SQL macros that compute network and broadcast addresses.

September 20, 2024
2 min read
data-analyticscidrip-address

Chat with a Duck

Query your data in plain English: use the DuckDB-NSQL LLM via Ollama to generate DuckDB SQL from natural language prompts in the browser-based SQL Workbench.

April 16, 2024
4 min read
aisqlllm