Top 7 fdw Open-Source Projects

clickhouse_fdw

2 241 3.1 C++

ClickHouse FDW for PostgreSQL
duckdb_fdw

4 235 7.3 PLpgSQL

DuckDB Foreign Data Wrapper for PostgreSQL
InfluxDB

www.influxdata.com sponsored

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
sqlite_fdw

6 193 5.7 PLpgSQL

SQLite Foreign Data Wrapper for PostgreSQL

Project mention: Things that surprised me while running SQLite in production | news.ycombinator.com | 2023-07-03

https://github.com/pgspider/sqlite_fdw
Postgres has foreign data wrappers which can kinda achieve this(see also: https://github.com/pgspider/sqlite_fdw ), but ive been surprised by how well sqlite is already supported by many tools : sometimes it comes for free as its used in testing - hooking up stuff like litestream can work really wel l too

parquet_s3_fdw

1 162 2.3 PLpgSQL

ParquetS3 Foreign Data Wrapper for PostgresSQL
pgrocks-fdw

1 117 10.0 C

Bring RocksDB to PostgreSQL as an extension. It is the first foreign data wrapper (FDW) that introduces LSM-tree into PostgreSQL. The underneath storage engine can be RocksDB. The FDW also serves for VidarDB engine, a versatile storage engine for various workloads. See the link for more info about VidarDB engine.
bigquery_fdw

2 89 3.9 Python

BigQuery Foreign Data Wrapper for PostgreSQL
firebird_fdw

2 36 5.1 C

A PostgreSQL foreign data wrapper (FDW) for Firebird - latest version 1.3.1 (2023-06-22)
WorkOS

workos.com sponsored

The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).