postgres-query-optimization-skill

saasify audits an existing app, confirms scope, and adds missing SaaS foundations in dependency order. It covers authentication, organizations and database-enforced RLS isolation, RBAC, plans and billing, invites, and onboarding. The skill works with Claude Code, Cursor, Codex, and other coding agents, with adaptable templates and checks for Stripe, HYP, license, or credit-based billing.

The skill first asks domain questions and produces an ADR covering aggregates, commands, events, projectors, and reactors for review. After approval, it generates tests first, then the domain code and migrations, and runs the suite. It targets greenfield Laravel domains using Spatie Event Sourcing v7 rather than converting existing CRUD code.

Ask Claude for Laravel work ranging from routing, Eloquent, queues, authentication, caching, and file storage to complete API or background-job examples. The skill is specifically oriented toward Laravel 13 additions, including the AI SDK, MCP server support, Laravel Boost, JSON:API resources, and attribute-based patterns. Its main value is keeping generated code aligned with the newer framework instead of falling back to Laravel 10 or 11 habits.

This Claude Code skill scaffolds an audit table, activity page, API route, and logging helper for a Next.js and Supabase admin dashboard. Developers wire the helper into successful admin actions and can add manual entries for deployments or operational work. RLS protects client access and blocks updates and deletions, while the server helper assumes an already admin-gated route. The templates expect a specific App Router, auth, UI, and Supabase structure, and logging failures do not block the underlying action.