Database Schema Patterns for AI Applications

Production-ready PostgreSQL/Supabase database schemas optimized for AI applications including chat systems, RAG (Retrieval-Augmented Generation), multi-tenancy, and usage tracking.

Instructions

1. Identify Required Pattern Type

Ask the user which schema pattern they need:

• chat: Conversation and messaging systems
• rag: Document storage with vector embeddings (pgvector)
• multi-tenant: Organization-based multi-tenancy
• user-management: Extended user profiles and metadata
• ai-usage: Token tracking, costs, and rate limiting
• complete: All patterns combined

2. Generate Schema