supabase-postgres-best-practices
Optimize Postgres performance with Supabase's best practices for queries, schema design, and database configs.

Build resilient data ingestion pipelines from APIs. Use when creating scripts that fetch paginated data from external APIs (Twitter, exchanges, any REST API) and need to track progress, avoid duplicates, handle rate limits, and support both incremental updates and historical backfills. Triggers: 'ingest data from API', 'pull tweets', 'fetch historical data', 'sync from X', 'build a data pipeline', 'fetch without re-downloading', 'resume the download', 'backfill older data'. NOT for: simple one-shot API calls, websocket/streaming connections, file downloads, or APIs without pagination.
npx skills add shipshitdev/libraryOptimize Postgres performance with Supabase's best practices for queries, schema design, and database configs.

Process PDF files including text extraction, merging, splitting, and form filling.

This skill handles spreadsheet files (.xlsx, .csv, .tsv) for reading, editing, and converting tabular data.

Set up, improve, or audit analytics tracking and measurement for GA4, UTM parameters, conversion tracking, and event tracking.

Detects patterns, anomalies, and trends in code and data using regex, AST analysis, and statistical methods.
