Open source
I build the extensions that unlock DuckDB.
40 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.
40
DuckDB extensions
1,948
GitHub stars
2M+
Extension installs
159
VGI workers
Featured
airport
Query any Arrow Flight server as if it were a DuckDB table.
C++
yesterday
→
httpserver
Turns DuckDB itself into a queryable HTTP API server.
C++
yesterday
→
shellfs
Pipe shell command output straight into a DuckDB scan.
C++
yesterday
→
clickhouse-sql
ClickHouse SQL dialect compatibility, inside DuckDB.
C++
2mo ago
→
httpclient
HTTP GET and POST from SQL, with no external tooling.
C++
yesterday
→
lindel
Hilbert and Z-order curves for locality-preserving sort keys.
C++
yesterday
→
openprompt
Prompt an LLM directly from a SQL query.
C++
yesterday
→
tributary
Read and write Kafka topics from SQL.
C++
yesterday
→
All DuckDB extensions
40
airport
DuckDB extension for querying, modifying, and storing data through Apache Arrow Flight servers.
C++
351
httpserver
DuckDB extension for serving SQL queries over HTTP and returning JSON results.
C++
285
shellfs
DuckDB extension for reading from and writing to Unix shell pipelines through file operations.
C++
97
clickhouse-sql
DuckDB Community Extension implementing ClickHouse SQL Dialect macros and Custom functions for DuckDB
C++
94
httpclient
Experimental DuckDB extension for making HTTP GET and POST requests directly from SQL.
C++
82
lindel
DuckDB extension for encoding and decoding multidimensional values with Hilbert and Morton (Z-order) space-filling curves.
C++
67
openprompt
Experimental DuckDB extension for prompting LLMs from SQL through OpenAI-compatible APIs, including Ollama.
C++
62
tributary
Experimental DuckDB extension for reading Apache Kafka topics and inspecting cluster metadata from SQL.
C++
61
datasketches
DuckDB extension for approximate analytics with Apache DataSketches: distinct counts, quantiles, frequent items, set operations, and sampling.
C++
57
cronjob
Experimental DuckDB extension for scheduling SQL queries with cron expressions while the DuckDB process is running.
C++
57
radio
DuckDB extension for sending and receiving real-time messages through WebSocket and Redis Pub/Sub channels.
C++
43
fuzzycomplete
DuckDB extension for fuzzy SQL autocompletion in the command-line interface.
C++
33
stochastic
DuckDB extension for probability distributions, random sampling, statistical properties, distribution fitting, and hypothesis testing.
C++
32
crypto
DuckDB extension for cryptographic hashes, HMACs, key derivation (PBKDF2, HKDF, scrypt, Argon2), and secure random bytes.
C++
31
textplot
DuckDB extension for ASCII and Unicode data visualization in SQL, including bar charts, density plots, and sparklines.
C++
29
duckdb-cron-extension
DuckDB Cron Expression Extension
Rust
29
evalexpr_rhai
DuckDB extension for running Rhai scripts and evaluating expressions in SQL queries.
C++
27
geosilo
DuckDB extension for compact geospatial geometry storage and queries using delta-encoded GEOSILO coordinates.
C++
26
quackscale
DuckDB WireGuard Extension with Quack & Ducklake over Tailscale, Headscale & Co
C++
26
adbc_scanner
DuckDB extension for querying databases through Apache Arrow Database Connectivity (ADBC) drivers.
C++
25
clickhouse-native
Experimental ClickHouse Native Client and Native file reader Extension for DuckDB chsql
Rust
22
pyroscope
DuckDB Pyroscope Extension for Continuous Profiling
Rust
22
rapidfuzz
DuckDB extension for fuzzy string matching, edit distances, search, and record linkage using RapidFuzz.
C++
19
a5
DuckDB extension for geospatial indexing and aggregation with the A5 global grid.
C++
18
redis
Experimental DuckDB extension for reading and writing Redis data directly from SQL.
C++
17
marisa
DuckDB extension for compact string indexes, prefix searches, and autocomplete using MARISA tries.
C++
17
webmacro
DuckDB extension for loading SQL macros from remote URLs, including GitHub Gists.
C++
16
quickjs
DuckDB extension for running JavaScript in SQL queries using the QuickJS-NG engine.
C++
15
hashfuncs
DuckDB extension for non-cryptographic hashing with xxHash, MurmurHash3, and RapidHash.
C++
15
pcap
DuckDB PCAP Reader Extension made in Rust
Rust
14
bitfilters
DuckDB extension for probabilistic set-membership testing with Bloom, XOR, binary fuse, and quotient filters.
C++
11
tera
DuckDB extension for rendering text and HTML from SQL using the Tera template engine.
C++
10
inflector
DuckDB extension for string case conversion and English inflection, including pluralization and singularization.
C++
10
copilot-extension-duckdb
DuckDB Copilot Extension
TypeScript
10
json_schema
DuckDB extension for JSON Schema validation and applying schema default values to JSON data.
C++
9
jsonata
DuckDB extension for querying, filtering, and transforming JSON with the JSONata expression language.
C++
9
tsid
Experimental DuckDB extension for generating time-sortable unique identifiers (TSIDs) and extracting their timestamps.
C++
7
duckdb-grainlift
DuckDB extension for grainlift: query any grainlift-exposed ADBC database from DuckDB and DuckDB-WASM (Haybarn), over HTTP or Iroh
C++
sql-macros
Example DuckDB macros for the webmacro extension
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
TypeScript
Go
Rust
Java
Csharp
C
C++
Protocol & SDK repositories
134 workers
ML, NLP & search
27
Cloud & connectors
24
Utilities
23
Formats & parsing
21
Security & forensics
19
Finance & markets
16
Geospatial
4
Browse all 159 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
→
cloudwatch-log-redirector
CloudWatch Log Redirector
Rust
9mo ago
→
Archive: 71 more personal projects
cupola
6
python-airport-test-server
5
libh3-sys
5
cloudformation-yasnippet
5
grainlift
4
python-sql-scan-planning
3
muid-zero-knowledge-proof
3
fair-weather
2
python-airport-hello-world
2
python-sql-manipulation
2
Microprediction
2
muid-rust
2
grainlift-turso
1
query-farm-telemetry-client
1
grainlift-rust-hello-world
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
query-farm-astro
grainlift-hello-world-python
duckdb-release-countdown
grainlift-cloudflare
grainlift-go
grainlift-typescript
grainlift-python
grainlift-hello-world-go
grainlift-hello-world-typescript
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 156 forks and upstream contributions — DuckDB, Apache Arrow, and others — on GitHub.