db-gotchas - Review proven Supabase and PostGIS database pitfalls
Provides production-proven pitfalls and safeguards for Supabase, PostgreSQL, PostGIS, PostgREST, SQL migrations, RPCs, and query optimization.
Tags
Updated: 2026-10-16Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Identify database pitfalls
- Validate RPC configurations
- Check staging index parity
- Review materialized view swaps
- Inspect query plan risks
- Recommend timeout safeguards
Inputs
- SQL migrations
- RPC definitions
- PostGIS queries
- Query plans
- Ingestion procedures
Outputs
- Database migration guidance
- RPC implementation guidance
- Query optimization guidance
- Ingestion safeguard recommendations