Claude-skill-registry database-navigator
Navigate and understand the Empathy Ledger database schema, migrations, functions, and relationships.
install
source · Clone the upstream repo
git clone https://github.com/majiayu000/claude-skill-registry
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/majiayu000/claude-skill-registry "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/data/database-navigator" ~/.claude/skills/majiayu000-claude-skill-registry-database-navigator && rm -rf "$T"
manifest:
skills/data/database-navigator/SKILL.mdsource content
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 | |
| Connection setup | |
| Full documentation | |
Related Skills
- Database clients and migrationssupabase-connection
- SQL operationssupabase-sql-manager
- Analysis patternsdata-analysis