Database Navigator

Navigate the complex database architecture - tables, functions, views, indexes, and policies.

When to Use

• Exploring database tables and relationships
• Finding database functions and triggers
• Understanding migration history
• Reviewing RLS policies
• Documenting database subsystems

Quick Reference

Key Table Groups

| Group | Tables | |-------|--------| | Users | profiles, organizations, organization_members | | Content | stories, storytellers, transcripts | | Media | media_assets, media_usage | | Cultural | cultural_backgrounds, protocols |

Migration Location

supabase/migrations/ - SQL files with timestamps

Common Operations

-- List all tables
SELECT table_name FROM information_schema.tables
WHERE table_schema = 'public';

-- Find table columns
SELECT column_name, data_type FROM information_schema.columns
WHERE table_name = 'your_table';

-- Check RLS policies
SELECT * FROM pg_policies WHERE tablename = 'your_table';

Reference Files

| Topic | File | |-------|------| | Query examples | refs/queries.md | | Connection setup | refs/connection.md | | Full documentation | docs/04-database/SUPABASE_COMPLETE_OVERVIEW.md |

Related Skills

• supabase-connection - Database clients and migrations
• supabase-sql-manager - SQL operations
• data-analysis - Analysis patterns