ashwin-desikan/metro-power-rankings
Skill Claude CodeCodex
Refresh api-football standings/fixtures and the footballlookup club crosswalk (scripts/apifootball) that feed Supabase-backed team pages. Use when the user wants to 'sync the Lookup sheet to Supabase', 'run the football standings refresh', 'check for UNMATCHED teams', or asks why a club's standings page is missing or…
ashwin-desikan/metro-power-rankings
Skill Claude CodeCodex
Sync the Champions League workbook's Lookup sheet into Supabase public.footballlookup, safely and with a reviewable diff. Use this whenever Ashwin says any of: 'sync the Lookup sheet', 'sync ChampionsLeague.xlsx to Supabase', 'the Lookup sheet changed', 'I added a club to Lookup', 'update the football mappings', 'the…
ashwin-desikan/metro-power-rankings
Skill Claude CodeCodex
Read and update HANDOFF.md, the async coordination log between the Windows and Mac-mini Claude Code instances working this repo. Use at the start of any nontrivial civic/data-pipeline work (read for open threads before touching mayors/governors/Congress/civic refreshes, or before assuming you're the only active…
ashwin-desikan/metro-power-rankings
Skill Claude CodeCodex
Refresh the CompaniesMarketCap -> Supabase market-cap pipeline (scripts/mktcap). Use whenever the user wants to 'run the mktcap refresh', 'update market caps', 'refresh company valuations', 'check the metro curation queue', or asks about new unmapped companies from CompaniesMarketCap.com / CB Insights unicorns. Chains…
ashwin-desikan/metro-power-rankings
Skill Claude CodeCodex
Run the full Metro Area Project data refresh pipeline end to end. Use whenever the user says they updated MetroAreas.xlsx, edited a league workbook (NFLall.xlsx, NBA.xlsx, NHL.xlsx, MLB.xlsx), wants to 'sync the workbook', 'rebuild the data', 'refresh the JSON', 'rerun the ETL', regenerate metro boundaries, or…
ashwin-desikan/metro-power-rankings
Instructions file
Claude Code instructions for ashwin-desikan/metro-power-rankings, covering claude.md, what this is, session model — know what you can and can't verify, the working loop for data/pipeline fixes and deploy discipline (this one costs real money — see below).
ashwin-desikan/metro-power-rankings
MCP server Claude CodeCodexCursor
Query 4,300+ ranked metros across sixteen dimensions: profiles, search, and head-to-head comparisons. Remote server at rankings.citizenofnowhere.org.