# Database Navigator

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

- Skill: `majiayu000/database-navigator` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/database-navigator`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/database-navigator/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/database-navigator

---


# 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
```sql
-- 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