All updates
database
docs
integrations
backend

Full Supabase schema, seed data, docs, and env template

  • Complete Supabase schema and docsAdded the full Supabase schema, migrations, seed data, and a human-readable database reference so projects can be run and inspected locally or by CI.

Database schema

  • Added a complete Supabase schema (identity, entitlements, Vault, GitHub, projects, commits, changelog entries, CMS tables, prompts, audit) and supporting migrations.database
  • Included RLS policies, triggers, indexes and FK constraints to support secure, production-like local development.database

Seed data & prompts

  • Populated seed data for entitlement catalog, system changelog section types (sections + components), and five system prompts to bootstrap generation and local testing.database

Documentation

  • Published a Product Requirements Document (docs/prd.md), a full database reference (docs/database.md) with column-by-column details, and a product backlog (docs/backlog.md).docs
  • Backlog documents planned v1+ items (reactions, comments, MCP server, analytics, integrations, RSS, cookie policy) so roadmap decisions are clear.docs

Environment template

  • Updated .env.local.example with GitHub App keys, Svix API key, and SuprSend workspace keys to simplify repo connection and outbound webhook setup.integrations

Developer tooling

  • Added TypeScript types and a lazy Supabase client singleton (packages/database/src/index.ts) to improve developer experience and keep types in sync with the schema.backend
Full Supabase schema, seed data, docs, and env template