aiox-data-engineer

Design secure database schemas by modeling domains and defining tables, then validate Supabase RLS policies to enforce least-privilege access and defense-in-depth security. This ensures data access patterns remain correct and restricted across your PostgreSQL architecture.

Execute zero-downtime PostgreSQL schema migrations by creating snapshot-first migration plans with rollback strategies. Apply changes using idempotent operations and run smoke tests to verify data integrity and prevent unsafe schema evolution.

Query optimization for production PostgreSQL databases works by analyzing query performance using explain/analyze-driven analysis. It identifies hot paths and ensures schema and indexing choices align with real usage to tune database performance effectively.

You can use this database architecture approach for existing Supabase projects to refactor data modeling and configure RLS validation. It applies snapshot-first safety and idempotent operations to ensure secure, performant schema evolution without breaking current workflows.

Supabase RLS rules may fail due to incorrectly configured least-privilege behavior or missing defense-in-depth security validation. Validate your RLS policies against actual access patterns and ensure schema relationships enforce correct data isolation.

You need snapshot-first safety for database schema migrations when applying changes to production PostgreSQL systems. It enables rollback strategies and ensures zero-downtime schema evolution by verifying idempotent operations before full execution.