Skip to content
database-navigator logo

Database Navigator

database-navigator

Navigate and understand the Empathy Ledger database schema, migrations, functions, and relationships.

SKILL.md

Full skill instructions

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

GroupTables
Usersprofiles, organizations, organization_members
Contentstories, storytellers, transcripts
Mediamedia_assets, media_usage
Culturalcultural_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

TopicFile
Query examplesrefs/​queries.md
Connection setuprefs/​connection.md
Full documentationdocs/​04-database/​SUPABASE_COMPLETE_OVERVIEW.md

Related Skills

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