@papi-ai/adapter-pg

@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