AgentSkillsCN

database-navigator

导航并深入理解 Empathy Ledger 的数据库表结构、迁移流程、函数定义以及各表之间的关系。

SKILL.md
--- frontmatter
name: database-navigator
description: Navigate and understand the Empathy Ledger database schema, migrations, functions, and relationships.

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

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

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