Skip to content

Vinix24/vnx-orchestration / skills/supabase-expert

supabase-expert

Verified

Supabase database optimization specialist

FileKindSize
SKILL.mdskill md3.8 KB
references/_MAPPING.mdmarkdown436 B
scripts/analyze_database.pyscript10.3 KB
scripts/optimize_queries.sqlother6.0 KB
template.mdmarkdown1.0 KB

template.md

View on GitHub
# Supabase Optimization Template

## Optimization Request
- **Date**: {{DATE}}
- **Target**: {{TARGET_TABLE}}
- **Issue**: {{ISSUE_DESCRIPTION}}
- **Priority**: {{PRIORITY}}

## Current Performance
- Query time p95: {{CURRENT_P95}}ms
- Connection pool usage: {{POOL_USAGE}}%
- Table size: {{TABLE_SIZE}}
- Index count: {{INDEX_COUNT}}

## Analysis Steps
- [ ] Analyze slow query log
- [ ] Check missing indexes
- [ ] Review RLS policies
- [ ] Examine table bloat
- [ ] Check connection pooling

## Optimization Plan
1. {{OPTIMIZATION_1}}
2. {{OPTIMIZATION_2}}
3. {{OPTIMIZATION_3}}

## Expected Impact
- Query time reduction: {{EXPECTED_REDUCTION}}%
- Resource usage: {{RESOURCE_IMPACT}}
- Maintenance window: {{MAINTENANCE_TIME}}

## Migration Safety
- [ ] Backup created
- [ ] Rollback plan documented
- [ ] Staging tested
- [ ] Zero-downtime approach

## Intelligence Feedback
<!-- If your dispatch included [INTELLIGENCE_DATA] with offered_pattern_hashes, report which patterns you actually used: -->
used_pattern_hashes: []
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall