DB Schema Surgeon

What problem does it solve?

Prevents schema drift and broken RAG metadata by automatically creating missing tables, running idempotent migration steps, and keeping PostgreSQL metadata synchronized with remote vector stores so the platform stays consistent across startups.

Core Features & Use Cases

• Auto-Healing Startup: Runs create_all for new models and executes safe ALTER/INDEX statements to add missing columns or indexes without complex migration history.
• Idempotent Migrations: Provides SQL migration steps using IF NOT EXISTS patterns to safely evolve production schemas and avoid destructive operations.
• Hybrid RAG Management: Stores metadata locally in PostgreSQL while keeping embeddings in Supabase/pgvector and enforces a dual-delete protocol to maintain consistency.
• Multitenancy & Identity Safety: Enforces tenant resolution patterns (UUID→INT) and recommends indexed foreign keys and performance-oriented indices.

Quick Start

Restart the orchestrator so it runs create_all and the idempotent migration steps to create missing tables and apply safe ALTER statements.