Open source

I build the extensions that unlock DuckDB.

36 native DuckDB extensions under Query.Farm, plus VGI — a protocol for writing DuckDB functions in any language. Everything here is open source and installable from SQL.

DuckDB extensions

1,892

GitHub stars

2M+

Extension installs

152

VGI workers

Featured

airport

350

Flagship

Query any Arrow Flight server as if it were a DuckDB table.

C++ 24d ago →

httpserver

285

Turns DuckDB itself into a queryable HTTP API server.

C++ 24d ago →

shellfs

Pipe shell command output straight into a DuckDB scan.

C++ 24d ago →

clickhouse-sql

ClickHouse SQL dialect compatibility, inside DuckDB.

C++ 24d ago →

httpclient

HTTP GET and POST from SQL, with no external tooling.

C++ 20d ago →

lindel

Talk subject

Hilbert and Z-order curves for locality-preserving sort keys.

C++ 24d ago →

openprompt

Prompt an LLM directly from a SQL query.

C++ 24d ago →

tributary

Read and write Kafka topics from SQL.

C++ 23d ago →

All DuckDB extensions

airport The Airport extension for DuckDB, enables the use of Arrow Flight with DuckDB

C++ 350

httpserver DuckDB HTTP API Server and Query Interface in a Community Extension

C++ 285

shellfs DuckDB extension allowing shell commands to be used for input and output.

C++ 96

clickhouse-sql DuckDB Community Extension implementing ClickHouse SQL Dialect macros and Custom functions for DuckDB

C++ 94

httpclient DuckDB HTTP GET/POST Client in a Community Extension

C++ 80

lindel DuckDB Extension Linearization/Delinearization, Z-Order, Hilbert and Morton Curves

C++ 68

openprompt DuckDB Community Extension to prompt LLMs from SQL

C++ 62

tributary A DuckDB Extension for Kafka

C++ 58

cronjob DuckDB CronJob Extension

C++ 55

datasketches Integrates DuckDB with the high-performance Apache DataSketches library. This extension enables users to perform approximate analytics on large-scale datasets using state-of-the-art streaming algorithms, all from within DuckDB.

C++ 53

radio Radio is a DuckDB extension by Query.Farm that brings real-time event streams into your SQL workflows. It enables DuckDB to receive and send events over systems like WebSocket and Redis Pub/Sub.

C++ 43

crypto DuckDB Extension for cryptographic hash functions and HMAC

C++ 31

fuzzycomplete DuckDB Extension for fuzzy string matching based autocompletion

C++ 30

duckdb-cron-extension DuckDB Cron Expression Extension

Rust 29

stochastic A DuckDB extension that add comprehensive statistical distribution functions to DuckDB, enabling advanced statistical analysis, probability calculations, and random sampling directly within SQL queries.

C++ 28

textplot A DuckDB community extension that enables text-based data visualization directly in SQL queries, including ASCII/Unicode bar charts, density plots, and sparklines for lightweight analytics and dashboards.

C++ 28

evalexpr_rhai A DuckDB extension to evaluate the Rhai scripting language as part of SQL.

C++ 27

adbc_scanner A DuckDB ADBC Scanner Extension - adds support for using ADBC drivers with DuckDB as a client.

C++ 25

geosilo DuckDB extension for compact geometry encoding using delta-encoded coordinates. 3-4x smaller than WKB.

C++ 25

quackscale DuckDB WireGuard Extension with Quack & Ducklake over Tailscale, Headscale & Co

C++ 24

clickhouse-native Experimental ClickHouse Native Client and Native file reader Extension for DuckDB chsql

Rust 22

pyroscope DuckDB Pyroscope Extension for Continuous Profiling

Rust 21

rapidfuzz DuckDB Community Extension adding RapidFuzz algorithms for search, deduplication, and record linkage.

C++ 19

redis DuckDB Redis Client community extension

C++ 17

a5 A5 Geospatial Extension for DuckDB

C++ 17

webmacro DuckDB WebMacro: Share and Load your SQL Macros via gists

C++ 16

marisa The Marisa extension by Query.Farm integrates the fast, space-efficient MARISA trie into DuckDB, enabling high-performance string lookups, prefix searches, and autocomplete functionality.

C++ 16

hashfuncs A DuckDB extension that supplies non-cryptographic hash functions.

C++ 14

pcap DuckDB PCAP Reader Extension made in Rust

Rust 14

inflector Powerful string case transformation and inflection capabilities directly to your SQL queries.

C++ 10

bitfilters A high-performance DuckDB extension providing probabilistic data structures for fast set membership testing and approximate duplicate detection. This extension implements state-of-the-art filter algorithms including Quotient filters, XOR filters, Binary Fuse filters, and soon Bloom filters.

C++ 10

copilot-extension-duckdb DuckDB Copilot Extension

TypeScript 10

jsonata The JSONata extension for DuckDB enables expressive, JSON-focused querying and transformation directly within SQL using the powerful JSONata expression language.

C++ 8

tsid TSID Extension for DuckDB

C++ 7

json_schema A DuckDB extension that bring support for validating JSON data using JSON schemas.

C++ 5

duckdb-cron-expression-extension DuckDB Extension for Cron Expressions

Shell

VGI — the Vector Gateway Interface

DuckDB extensions normally have to be written in C++ and compiled for every platform. VGI removes that constraint: implement scalar, table, and aggregate functions in the language you already use, and DuckDB calls them out-of-process over Apache Arrow IPC.

SDKs

Python Go Java TypeScript Rust C++ Csharp

Protocol & SDK repositories

vgi-rpc-python 14 vgi-java 4 vgi-rpc-go 2 vgi-rpc-java 2 vgi-rpc-typescript 2 vgi-rpc-rust 1 vgi-go 1 vgi-rust 1

128 workers

ML, NLP & search 26 Cloud & connectors 23 Formats & parsing 21 Utilities 19 Security & forensics 19 Finance & markets 16 Geospatial 4

Browse all 152 VGI repositories → Including the same hello-world function implemented in 5 languages, as a protocol conformance check.

Libraries & other projects

libh3

Uber’s Hexagonal Hierarchical Spatial Index (H3) library in Rust

Rust 4y ago →

python-flight-server

A Python framework to build Arrow Flight servers for the DuckDB Airport Extension

Python 1y ago →

quickjs

C++ 24d ago →

Archive: 70 more personal projects

cloudwatch-log-redirector 15 tera 9 python-airport-test-server 5 cloudformation-yasnippet 5 grainlift 4 libh3-sys 4 python-sql-scan-planning 3 muid-zero-knowledge-proof 3 cupola 2 fair-weather 2 python-airport-hello-world 2 python-sql-manipulation 2 Microprediction 2 muid-rust 2 query-farm-telemetry-client 1 python-duckdb-json-serialization 1 monteprediction_client_implied_volatility 1 arrow-flight-optimized 1 muid-node 1 deterministic-screenshots-chromium 1 microprediction-nyiso-electricity 1 MicropredictionHistory 1 microprediction-golf-hole-by-hole 1 nj511-microprediction 1 piedmont-hospital-er-wait-time-microprediction 1 airport-ewr-microprediction 1 nba-scores-microprediction 1 MemorableUniqueIdentifier 1 Amazon-DynamoDB 1 grainlift-hello-world-go grainlift-rust-hello-world grainlift-hello-world-typescript grainlift-hello-world-python grainlift-typescript grainlift-go grainlift-python query-farm-astro discreture blake3 snacks-report tomographic-digest memory-passing-speed-benchmark monteprediction-client-v2 microprediction-node emojitracker-microprediction reddit-recorder radio-scanner-analyzer typescript-api-gateway-lambda-base finviz-microprediction nyiso-electricity-models ncep-grib2-definitions microprediction-nyiso-pull microprediction-bots microprediction-stream-logger inbox-queue moore-hilbert moore-hilbert-sys starter-express-typescript typescript-aws-lambda-function rustyconover.github.io aws-rekognition-text-detection-filter vm-ec2-security-credentialcache encode-detective WebService-Intercom amazon-ses vm-ec2-instance-located devel-stacktrace-ashtmlextended Webservice-Amazon-Signature WebService-Validator-HTML-W3C Test-HTML-W3C

Plus 132 forks and upstream contributions — DuckDB, Apache Arrow, and others — on GitHub.