Skip to content

supabase/wrappers

PostgreSQL version License Tests

Documentation: https://supabase.github.io/wrappers

Source Code: https://github.com/supabase/wrappers

Overview

supabase/wrappers is a PostgreSQL extension that provides integrations with external sources so you can interact with third-party data using SQL.

For example, the Stripe wrapper allows you to query and join against your Stripe customer data straight from PostgreSQL:

1
2
3
4
5
select
  customer_id
  currency
from
   stripe.customers;

returns

1
2
3
4
    customer_id     | currency
--------------------+-----------
 cus_MJiBtCqOF1Bb3F | usd
(1 row)

Currently supabase/wrappers supports:

Integration Select Insert Update Delete Truncate
Airtable ✅ ❌ ❌ ❌ ❌
BigQuery ✅ ✅ ✅ ✅ ❌
ClickHouse ✅ ✅ ✅ ✅ ❌
Firebase ✅ ❌ ❌ ❌ ❌
Logflare ✅ ❌ ❌ ❌ ❌
Notion ✅ ❌ ❌ ❌ ❌
Paddle ✅ ✅ ✅ ❌ ❌
Redis ✅ ❌ ❌ ❌ ❌
S3 ✅ ❌ ❌ ❌ ❌
Snowflake ✅ ✅ ✅ ✅ ❌
Stripe ✅ ✅ ✅ ✅ ❌
SQL Server ✅ ❌ ❌ ❌ ❌

WebAssembly(Wasm) foreign data wrapper

Since v0.4.0, supabase/wrappers supports WebAssembly (Wasm) foreign data wrapper. It enhances flexibility and performance by enabling seamless integration and execution of WebAssembly modules within PostgreSQL.

The Wasm foreign data wrappers are dynamically loaded during query, so they are not required to be built into Wrappers extension. Currently supported Wasm foreign data wrappers are listed below:

Integration Select Insert Update Delete Truncate
Paddle ✅ ✅ ✅ ❌ ❌
Snowflake ✅ ✅ ✅ ✅ ❌

Warning

Restoring a logical backup of a database with a materialized view using a foreign table can fail. For this reason, either do not use foreign tables in materialized views or use them in databases with physical backups enabled.