supabase-database

SQL execution lets you run ad-hoc queries directly against your Supabase database. Use mcp__supabase__execute_sql to perform SELECT, INSERT, UPDATE, or DELETE operations, retrieve data, and test schema changes in real time.

Migrations let you version-control schema changes systematically. Create migrations that define structural changes, then apply them via mcp__supabase__apply_migration to roll out updates consistently across environments while maintaining data integrity.

Yes. Type generation introspects your Supabase schema and produces TypeScript type definitions for core entities like locations and public_pois, eliminating manual type-writing and keeping types synchronized with schema changes.

Schema discovery tools list all tables and extensions to understand your data model structure. Advisor checks surface security and performance recommendations, while log retrieval exposes operational events for debugging and compliance.

The Skill enforces snake_case naming conventions, prohibits hard-coded IDs, and verifies Row Level Security policies, ensuring schemas follow security and maintainability standards aligned with production database governance.

This Skill is designed for the MyGGV GPS project's Supabase database. SQL execution, migrations, schema inspection, and type generation all target that specific project's data model and configuration.