Generated types workflow, type-safe database queries, discriminated unions for state, and generic CRUD helpers.
Auto-generated from the 4 rules this article references — each links to the enforceable rule.
BeforeMerge offers hundreds of code review rules, guides, and detection patterns to help your team ship better code.
Generate types from your Supabase schema:
npx supabase gen types typescript --project-id $PROJECT_ID > database.types.tsUse in your client:
import { Database } from "./database.types"
const supabase = createServerClient<Database>(url, key, { cookies })Now all queries are type-safe:
const { data } = await supabase.from("rules").select("title, slug, impact")
// data type: { title: string; slug: string; impact: string }[]type Tables = Database["public"]["Tables"]
type Rule = Tables["rule"]["Row"]
type RuleInsert = Tables["rule"]["Insert"]
type RuleUpdate = Tables["rule"]["Update"]type ScanState =
| { status: "idle" }
| { status: "scanning"; progress: number }
| { status: "complete"; findings: Finding[] }
| { status: "error"; error: string }