Architecture

Supabase

The PostgreSQL database platform used for structured data storage, including event data, kanban state, and scraper outputs.

Supabase provides the relational data layer for Knowledge OS. Newsletter event data flows through scrapers into Supabase tables, where it is queried by generation skills to produce weekly newsletters. The kanban task system uses dual-write to both Supabase (SQL-queryable) and local JSONL files (git audit trail). Supabase PostgREST has a specific gotcha: neq.expired filters silently exclude NULL values, which caused 63+ future events to disappear in production. That incident led to a permanent memory entry about NULL handling. Migrations live in the shared data pipeline directory and follow a numbered prefix convention.

Where it shows up:

Event data storageKanban task trackingScraper outputNewsletter data pipeline

Build your Knowledge OS

90 minutes from zero to your first skill chain.