knowledge-base.md 53 KB

Doltgres - knowledge base

Briven Auth rebuild — SuperTokens knowledge base

Purpose: Library cabinet for LLM agents building new Briven Auth. These are reference docs from SuperTokens — borrow good product/architecture ideas. Briven Auth stays Briven-branded, multi-tenant on Briven Doltgres, not a raw SuperTokens install.

Date filed: 2026-07-22 URL count: 492 unique

How agents should use this

HARD RULE (flndrn, 2026-07-26 — never break)

Before any Auth change (magic link, OTP, OAuth/Konnos, sessions, MFA, passkeys, FDI, IdP, SSO, providers, secrets, allowed domains, enable/disable Auth, or any code under Auth surfaces):

  1. You must open this file first.
  2. You must open the matching SuperTokens section/URL below for that feature.
  3. You must not guess login behavior. SuperTokens is the product map; Briven implements Briven-branded on Doltgres.
  4. State in one plain sentence what the SuperTokens/KB behavior is, then code.

Also written into project root CLAUDE.md. Skipping this step is a rule violation, not a style preference.

Always

  1. Prefer Briven product rules (Doltgres-first, project isolation, pk_briven_auth_, no inventing Clerk).
  2. For any database / Doltgres / Postgres-wire problem, open the Doltgres / Dolt official knowledge base section at the bottom of this file first (URLs from AI_DOCS/dolt-reference/). Also read AI_DOCS/dolt-reference/00-doltgres-truth.md.
  3. When stuck on a login feature (sessions, passwordless, MFA, etc.), open the matching SuperTokens section below and keep Doltgres constraints from the Doltgres section.
  4. Translate Supabase/MySQL examples to Briven Doltgres using official Doltgres docs — do not invent.
  5. Do not paste SuperTokens branding into Briven UI — yellow Auth sub-dashboard, Briven styling.
  6. Never abandon SuperTokens Core or change Auth architecture after one SQL error without reading Doltgres docs and notifying flndrn.

Quickstart

Quickstart integrations

Authentication recipes

Additional verification (sessions, MFA, roles, captcha)

Post-authentication (sessions, users, dashboard)

Migration

Platform configuration

Deployment

References (SDKs, FDI, CDI, plugins, testing)

Briven-specific mapping notes

SuperTokens docs say Briven Auth must do
Supabase Briven Doltgres per project
MySQL migrate Migrate / store on Doltgres
Self-host Core Hosted by Briven platform (users do not run Core)
App domain backend SDK First-party auth on app + Briven Auth control plane
Dashboard Yellow Briven Auth sidebar section (sub-dashboard)

Briven Pay build

Briven database — Doltgres / Dolt official knowledge base

Purpose: Library cabinet for EVERY Briven build that touches SQL, Auth, backups, or Postgres-family compatibility. Source: (1) flndrn official www.doltgres.com list (PRIMARY, complete set below) + (2) URLs from AI_DOCS/dolt-reference/* (local notes + often dolthub.com MySQL-Dolt siblings) (already in this repo). Agents must open these — do not guess. HARD RULE: On any Doltgres / Postgres-wire error (including SuperTokens Core or any tool built for Postgres), search this section + AI_DOCS/dolt-reference/00-doltgres-truth.md before changing architecture. Never quit after one SQL error without reading these and notifying flndrn with options.

Local distilled files (always read first)

  • AI_DOCS/dolt-reference/00-doltgres-truth.mdauthoritative DoltGres facts (Postgres-flavored)
  • AI_DOCS/dolt-reference/01-intro-install.md
  • AI_DOCS/dolt-reference/02-use-cases.md
  • AI_DOCS/dolt-reference/03-concepts-git.md
  • AI_DOCS/dolt-reference/04-concepts-sql.md
  • AI_DOCS/dolt-reference/05-rdbms-dolthub.md
  • AI_DOCS/dolt-reference/06-sqlref-server.md
  • AI_DOCS/dolt-reference/07-sqlref-version-control.md
  • DOLTGRES-FIRST.md — Briven hard product rule

Official DoltGres docs (www.doltgres.com) — PRIMARY for Briven

Filed from flndrn full URL list (2026-07-22). These are the real DoltGres product docs (Postgres-flavored). Prefer these over dolthub.com MySQL-Dolt pages when they overlap. Count: 51 URLs

Introduction

Concepts — git / version control

Concepts — SQL

Concepts — RDBMS

Guides

Reference — server

Reference — version control

Reference — SQL support (Postgres-family gaps live here)

Reference — clients

Reference — benchmarks

Introduction / install

Use cases

Concepts — overview + git / version control

Concepts — SQL

Concepts — RDBMS + DoltHub product

SQL reference — server ops

SQL reference — version control API

Blogs (product state / calling conventions)

GitHub install (Dolt sibling — only if needed for concept)

Agent workflow when something fails on Doltgres

  1. Read AI_DOCS/dolt-reference/00-doltgres-truth.md and the matching URL group above.
  2. Doltgres = Postgres family (port 5432, pg driver). Missing feature ≠ abandon the product.
  3. Prefer workarounds (SQL rewrite, session settings, driver, version, config) over stock Postgres.
  4. Notify flndrn with: error text, which doc URL you used, options A/B/C — before switching architecture.