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.md
source 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

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 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