DOCSEARCHbyAlgolia
Submit Docs

Supabase Wrappers

repository·main·Indexed 21 days ago

https://github.com/supabase/wrappers

A Rust-based development framework for high-performance Postgres Foreign Data Wrappers (FDWs) using the pgrx ecosystem. It provides a collection of pre-built connectors to access external data sources—including BigQuery, Clickhouse, Stripe, Firebase, Airtable, S3, Logflare, Auth0, Cognito, Redis, and SQL Server—directly from a Postgres database as local tables. It supports advanced features such as WHERE, ORDER BY, and LIMIT pushdown, as well as an OpenAPI FDW for integrating RESTful APIs.

Tokens
150.7K
Snippets
402
Records
606
Agent score
74%

What's inside supabase-wrappers

  1. Overview of Supabase Postgres Foreign Data Wrappers

    main

    Supabase Wrappers is a collection of Postgres Foreign Data Wrappers (FDWs) that allow you to access external data sources directly from your Postgres database as if they were local tables.

    Supported FDWs include:

    • BigQuery: Supports data read and modify.
    • Clickhouse: Supports data read and modify.
    • Stripe: Supports data read and modify.
    • Firebase: Supports data read only.
    • Airtable: Supports data read only.
    • S3: Supports data read only.
    • Logflare: Supports data read only.
    • Auth0: Access Auth0 data.
    • Cognito: Access AWS Cognito data.
    • SQL Server: Supports data read only.
    • Redis: Supports data read only.
    • HelloWorld: A demo FDW for development reference.

  4. Overview of Apache Iceberg Foreign Data Wrapper

    main

    The Apache Iceberg Foreign Data Wrapper (FDW) allows you to interact with Apache Iceberg tables from within your database. It is built using the Wrappers framework.

    Current Limitation: As of the current version, it primarily supports data scanning. While recent updates have added data insertion support, users should refer to the official documentation for the full list of supported operations.

  5. Overview of Wrappers

    main
    Wrappers is a development framework for Postgres Foreign Data Wrappers (FDW) written in Rust. It leverages the pgrx ecosystem to provide high-performance, type-safe interfaces for building FDWs. It is designed to simplify the development of connectors for various backends, including RDBMS, RESTful APIs, and flat files, while supporting advanced features like WHERE, ORDER BY, and LIMIT pushdown.

  6. Overview of the DuckDB Wrapper

    main
    The DuckDB Wrapper enables you to read data from a DuckDB database directly from within your Postgres database. It leverages DuckDB's column-oriented Relational Database Management System (RDBMS) capabilities to allow cross-database querying.

  9. What is the Wrappers framework?

    main
    Wrappers is a Rust framework designed for developing PostgreSQL Foreign Data Wrappers (FDW). It extends the native Postgres FDW feature, allowing you to access and query data from external systems—such as APIs or other databases—as if they were native Postgres tables. This enables you to perform SQL joins between your local Postgres data and remote data sources.

  11. Explore Wasm Wrappers catalog

    main

    Wasm Wrappers are Foreign Data Wrappers (FDWs) built with WebAssembly that can be used on the Supabase platform to access external data sources directly via SQL.

    Available Wasm-based wrappers include:

    Each wrapper has dedicated documentation for specific setup and configuration instructions.

  12. Stripe Foreign Data Wrapper Overview

    main
    The Stripe Foreign Data Wrapper (FDW) allows you to interact with Stripe data directly from your PostgreSQL database. It is built using the Wrappers framework, enabling you to query Stripe objects as if they were local tables. For detailed technical documentation, including schema definitions and specific object mappings, refer to the official catalog at https://fdw.dev/catalog/stripe/.