Data analysis

Skill bg-szy/TOP-SKILLS/skills/marketplace/data-analysis

AI-powered data analysis for Empathy Ledger - themes, quotes, story suggestions, transcript analysis.From its SKILL.md

Install

npx -y skills add bg-szy/TOP-SKILLS --skill data-analysis

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
4 stars4 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

2.1 KB, 477 tokens by cl100k_base, as published. Nobody here has run it

Data Analysis

Patterns for AI-powered analysis: themes, quotes, summaries, and story suggestions.

When to Use

Adding quotes to story cards
Implementing story suggestions/related content
Building theme-based filtering or search
Creating analytics dashboards
Integrating AI analysis results

Quick Reference

Analysis Pipeline

Transcript → AI Analysis → themes[], key_quotes[], ai_summary
Story → Connections → Related Stories, Suggested Content

Key Tables

Table	Analysis Fields
`transcripts`	`themes`, `key_quotes`, `ai_summary`, `ai_processing_status`
`stories`	`themes`, `cultural_tags`, `featured_quote`
`storytellers`	`expertise_themes`, `connection_strength`

Theme Categories

cultural: identity, heritage, tradition, language, ceremony
family: kinship, elders, children, ancestors, community
land: country, connection, seasons, wildlife, sacred-sites
resilience: survival, adaptation, strength, healing, hope
knowledge: wisdom, teaching, learning, stories, dreams

Common Queries

-- Stories with matching theme
SELECT * FROM stories WHERE themes && ARRAY['identity', 'heritage'];

-- Theme frequency
SELECT unnest(themes) as theme, count(*) FROM stories GROUP BY theme ORDER BY count DESC;

API Endpoints

Endpoint	Purpose
`POST /api/transcripts/{id}/analyze`	Trigger AI analysis
`GET /api/stories/{id}/suggestions`	Get related stories
`GET /api/themes`	List themes with counts

Reference Files

Topic	File
Code patterns	`refs/analysis-patterns.md`
SQL queries	`refs/supabase-queries.md`
Theme hierarchy	`refs/theme-taxonomy.md`
Sync status	`refs/sync-status.md`

Related Skills

database-navigator - Database exploration
supabase-connection - Database clients
design-component - UI patterns for analysis display

What ships with it: 5 files

71.8 KB alongside SKILL.md