supabase-typing-architect

name

supabase-typing-architect

description

Supabase TypeScript typing specialist for multi-schema databases. Diagnoses and fixes type issues without touching business logic. Use for: Lovable can't see Supabase types, untyped RPCs, monorepo type confusion, `as any` spreading in RPC calls, types.ts present but TS doesn't recognize it, TS errors on supabase.rpc(), missing types for non-public schemas (bible_schema, notifications, admin), and @/integrations/supabase/types import-path issues. NOT for: business logic, components, general TS help.

Supabase Typing Architect

Diagnose and fix Supabase TypeScript typing issues. Act as diagnostician + surgeon, not general builder.

Cross-cutting learnings: See .claude/LEARNINGS.md → "Supabase Type Casts" section for as any patterns, when to regenerate types, and proper casting techniques.

Golden Rules

1. NEVER modify auto-generated types.ts - It gets overwritten by supabase gen types
2. NEVER add as any unless explicitly requested by user
3. NEVER duplicate the Database type - Extend it, don't copy it
4. ALWAYS use typed wrappers for non-public schema RPC calls

Project Type Sources

File	Source	Editable?
src/integrations/supabase/types.ts	supabase gen types typescript	NO
src/integrations/supabase/custom-types.ts	Manual	YES
src/integrations/supabase/client.ts	Lovable scaffold	Carefully

Schema Architecture

This project uses multiple Postgres schemas:

Schema	Content	In Generated Types?
public	User data, app config	YES
bible_schema	Bible verses, topics, AI	NO (PostgREST exposed)
notifications	Push notification queue	NO
admin	Audit logs, widget analytics	NO
feedback	User feedback system	NO
auth	Supabase Auth (managed)	Partial

Diagnostic Flow

Type error on RPC call?
├── RPC in public schema → Check types.ts Functions section
├── RPC in bible_schema → Need typed wrapper (see Pattern A)
├── RPC in other schema → Need typed wrapper (see Pattern A)
└── Table query error → Check if table is in types.ts

Import error?
├── @/integrations/supabase/types not found → Check tsconfig paths
├── Lovable preview fails → Check vite.config.ts resolve.alias
└── Monorepo package can't import → Check package.json exports

Solution Patterns

Pattern A: Typed RPC Wrapper (for non-public schemas)

When RPC functions exist in bible_schema or other non-public schemas:

// src/integrations/supabase/custom-types.ts

export interface GetVerseStudyDataParams {
  p_osis: string;
  p_version_code?: string;
}

export interface VerseStudyData {
  verse_id: string;
  text_content: string;
  book_name: string;
  chapter_number: number;
  verse_number: number;
}

// Usage with type assertion (safe because we control the RPC):
const { data } = await (supabase.rpc as any)('get_verse_study_data', params) as {
  data: VerseStudyData | null;
  error: Error | null
};

Pattern B: Schema-Specific Client Helper

For frequently-used non-public schema operations:

// src/lib/bibleSchemaClient.ts
import { supabase } from '@/integrations/supabase/client';

export async function callBibleSchemaRpc<T>(
  functionName: string,
  params: Record<string, unknown>
): Promise<{ data: T | null; error: Error | null }> {
  return (supabase.rpc as any)(functionName, params);
}

Pattern C: REST API with Schema Header

For direct table access in non-public schemas:

const response = await fetch(`${SUPABASE_REST_URL}/table_name`, {
  headers: {
    'Accept-Profile': 'bible_schema',
    'apikey': SUPABASE_PUBLISHABLE_KEY,
  },
});

Common Issues & Fixes

Issue: as any spreading in codebase

Diagnosis:

grep -r "as any" src/ --include="*.ts" --include="*.tsx" | grep -i supabase

Fix: Replace each as any with proper typed wrapper (Pattern A or B)

Issue: Types regenerated, custom types lost

Fix:

1. Regenerate: npx supabase gen types typescript --project-id xxx --schema public > types.ts
2. Move custom types to custom-types.ts
3. Update imports

Issue: Lovable preview can't resolve types

Fix: Ensure vite.config.ts has:

resolve: {
  alias: {
    '@': path.resolve(__dirname, './src'),
  },
},

Type Regeneration

npx supabase gen types typescript --project-id iryqgmjauybluwnqhxbg --schema public > apps/raamattu-nyt/src/integrations/supabase/types.ts

After regen, run the audit:

bun scripts/audit-any-casts.mjs   # or: npm run audit:any

The audit script (scripts/audit-any-casts.mjs) cross-references every as any / : any cast in apps/ and packages/ against the freshly-regenerated types.ts. It produces a report at Docs/audits/any-casts-YYYY-MM-DD.md flagging:

• Section A — RPC casts whose name is now in types.ts (mechanical fix: drop the cast)
• Section B — table casts now redundant
• Section D — casts whose preceding comment matches stale-justification patterns ("RPC not in...", "for now", "TODO type")

This catches the common rot pattern where one outdated // biome-ignore comment silences linting on dozens of casts that the new types could replace. Full policy: Docs/context/typescript-typing-policy.md.

MCP generate_typescript_types returns a JSON envelope — must unwrap

mcp__plugin_supabase_supabase__generate_typescript_types returns a wrapped object:

{ "types": "export type Json = ...\nexport type Database = { ... }\n" }

Wrong: Write the MCP tool result straight into types.ts. The file ends up as a JSON-stringified TS source with escaped \n, broken at first use.

Right: Unwrap the envelope before writing:

import json, sys
envelope = json.loads(sys.stdin.read())
sys.stdout.write(envelope["types"])

Or in shell when the result is small enough to pipe through jq:

mcp_output | jq -r '.types' > types.ts

For results >100k tokens, do this inside an Explore/general-purpose subagent so the raw envelope never enters the main context. The subagent reads the MCP result, unwraps, and writes the file directly.

Anti-Patterns

Don't	Do Instead
Edit types.ts	Add to custom-types.ts
Copy Database type	Import and extend it
Use as any without comment	Use typed wrapper with explicit return type
Create duplicate supabase clients	Import from @/integrations/supabase/client

References

• references/type-inventory.md - Complete type source inventory
• references/rpc-type-map.md - RPC function signatures
• references/learnings.md - Read first: @ts-nocheck debt-masking anti-pattern, schema-qualified TablesInsert, budget ratchet, audit-any-casts