SQL query templates for DB Steward integrity checks. Load when running /db-check or /db-fix. Covers schema drift, duplicates, stale status, orphaned rows, RLS, seed data, and capacity integrity.
nocturnaljojo/fijifish
SkillsMP has collected 16 skills from nocturnaljojo/fijifish. Open a skill to review its source and details.
- Latest recorded source activity
- SkillsMP catalog refreshed
- skills collected
- 16
- GitHub stars
- 0
- GitHub forks
- 0
Skills in this repository
Showing 16 of 16 collected skills.
Flight-driven order window business rules. Use when building or modifying order lifecycle, window state transitions, closing time calculations, or any logic involving Fiji Airways timetable and order cutoffs.
QA the FijiFish app using Playwright browser automation. Use when asked to test, verify, review, or QA any feature. Opens the running app in a real browser, tests against FIJIFISH-WEBAPP-SPEC-v3.md requirements, and reports pass/fail with screenshots.
Full quality check — TypeScript types, lint, build, and security audit. Run before any commit to main or before starting a new feature. Returns pass/fail with specific errors to fix.
Stripe payment integration for fish orders. Use when building checkout flow, payment processing, refund handling, or webhook receivers. AU buyers only.
Run before every commit. Catches regressions, type errors, lint issues, and ensures docs are updated. ALWAYS run this before committing.
Clerk authentication and role management. Use when building any auth flow, protected route, role check, or Clerk-Supabase sync. NEVER use Supabase Auth.
Catch photo and delivery proof workflows. Use when building photo upload, approval, or image display.
Driver delivery portal — route optimisation, photo proof, communal delivery, distance tracking, admin escalation. Use when building any driver feature.
BICON import permits, export health certificates, cold chain requirements, and food safety compliance. Use when building compliance-related features, documentation pages, or admin checklists.
FlightRadar24 embed for shipment tracking. Use when building tracking page flight display.
Geo-based AUD/FJD price switching and AU-only purchase gate. Use when building price display or checkout.
SMS, WhatsApp, email notifications via Twilio + broadcast messaging. Use when building any notification or broadcast feature.
Seasonal fish availability logic. Use when building the homepage fish display, search filters, or any query that shows available fish.
Write and apply Supabase database migrations safely. Use when creating tables, altering schema, adding RLS policies, or seeding data.
WorldView HUD design system. Use when building ANY UI component or page. Defines colours, typography, spacing, component patterns. NEVER use generic white dashboards.