wrappers
wrappers : Foreign data wrappers developed by Supabase
Overview
| ID | Extension | Package | Version | Category | License | Language |
|---|---|---|---|---|---|---|
| 8500 | wrappers
|
wrappers
|
0.5.7 |
FDW
|
Apache-2.0
|
Rust
|
| Attribute | Has Binary | Has Library | Need Load | Has DDL | Relocatable | Trusted |
|---|---|---|---|---|---|---|
--s-d-r
|
No
|
Yes
|
No
|
Yes
|
yes
|
no
|
| Relationships | |
|---|---|
| See Also | multicorn
odbc_fdw
jdbc_fdw
pgspider_ext
|
manual updated pgrx by Vonng
Packages
| Type | Repo | Version | PG Major Compatibility | Package Pattern | Dependencies |
|---|---|---|---|---|---|
| EXT | PIGSTY
|
0.5.7 |
18
17
16
15
14
|
wrappers |
- |
| RPM | PIGSTY
|
0.5.7 |
18
17
16
15
14
|
wrappers_$v |
- |
| DEB | PIGSTY
|
0.5.7 |
18
17
16
15
14
|
postgresql-$v-wrappers |
- |
| Linux / PG | PG18 | PG17 | PG16 | PG15 | PG14 |
|---|---|---|---|---|---|
el8.x86_64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
el8.aarch64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
el9.x86_64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
el9.aarch64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
el10.x86_64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
el10.aarch64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
d12.x86_64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
d12.aarch64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
d13.x86_64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
d13.aarch64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
u22.x86_64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
u22.aarch64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
u24.x86_64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
u24.aarch64
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
PIGSTY 0.5.7
|
Source
pig build pkg wrappers; # build rpm/debInstall
Make sure PGDG and PIGSTY repo available:
pig repo add pgsql -u # add both repo and update cacheInstall this extension with pig:
pig install wrappers; # install via package name, for the active PG version
pig install wrappers -v 18; # install for PG 18
pig install wrappers -v 17; # install for PG 17
pig install wrappers -v 16; # install for PG 16
pig install wrappers -v 15; # install for PG 15
pig install wrappers -v 14; # install for PG 14Create this extension with:
CREATE EXTENSION wrappers;Usage
Supabase Wrappers is a framework for building PostgreSQL Foreign Data Wrappers (FDW), with 30+ pre-built connectors for cloud services, databases, and APIs. It supports WHERE, ORDER BY, and LIMIT pushdown, with some wrappers also supporting data modification (INSERT/UPDATE/DELETE).
Available Wrappers
| Category | Wrappers |
|---|---|
| Databases | ClickHouse, BigQuery, Snowflake, DuckDB, SQL Server, Redis, PostgreSQL |
| Storage | AWS S3, Cloudflare D1, Apache Iceberg |
| SaaS/APIs | Stripe, Firebase, Airtable, Auth0, Notion, Slack, HubSpot, Shopify |
| Auth | AWS Cognito, Clerk, Auth0 |
| Other | OpenAPI, Logflare, Calendly, Cal.com, Paddle, Orb, Infura, Gravatar |
Example (Stripe)
CREATE EXTENSION wrappers;
CREATE SERVER stripe_server
FOREIGN DATA WRAPPER stripe_wrapper
OPTIONS (
api_key_id '<key_ID>',
api_url 'https://api.stripe.com/v1/',
api_version '2024-06-20'
);
CREATE FOREIGN TABLE stripe_customers (
id text,
email text,
name text,
description text,
created timestamp,
attrs jsonb
)
SERVER stripe_server
OPTIONS (
object 'customers',
rowid_column 'id'
);
SELECT id, email, name FROM stripe_customers WHERE email LIKE '%@example.com';The rowid_column option is required for INSERT/UPDATE/DELETE support. The attrs column provides access to additional metadata as JSON.
Each wrapper uses its own FOREIGN DATA WRAPPER name (e.g., stripe_wrapper, firebase_wrapper, clickhouse_wrapper), but they are all installed via the single wrappers extension. Refer to the documentation for wrapper-specific options and supported objects.