@papi/adapter-pg

PostgreSQL adapter for PAPI. Reads and writes project data to a Supabase-hosted PostgreSQL database.

Overview

This adapter implements the PapiAdapter interface using PostgreSQL (via Supabase) as the storage backend. It's the recommended adapter for hosted/production usage — all data is stored in the database with Row Level Security (RLS) for multi-tenant isolation.

Installation

npm install @papi/adapter-pg

This adapter is bundled into @papi/server — install separately only if building custom tooling.

Configuration

Set these environment variables to connect to your Supabase instance:

| Variable | Required | Description | |----------|----------|-------------| | DATABASE_URL | Yes | PostgreSQL connection string | | PAPI_PROJECT_ID | Yes | UUID identifying your project in the database |

License

MIT