Universal relational database theory - normalization, keys, constraints, and anti-patterns that apply to ALL relational databases (PostgreSQL, MySQL, SQL Server, SQLite, etc.). Use when designing schemas, reviewing database structures, or discussing relational concepts.
Resend email API expertise for transactional emails, notifications, and batch sends. Triggers when sending emails, implementing email notifications, password resets, order confirmations, or any file importing from resend. Use for email sending, webhooks, templates, deliverability, and error handling.
Score any artifact on a 1-100 rubric with auto-iteration to a target score (e.g. /stone-giant:score 90). Builds a tailored rubric, identifies what would raise the score, and can auto-apply improvements. Built-in guardrails prevent gaming.
Audit and improve a site's visibility in search and AI answer engines (SEO, GEO, AEO). Use when asked to assess SEO/GEO/AEO, check AI-search / AI-Overview visibility, generate an optimization playbook, or track ranking and citation progress over time. Runs as /stone-giant:seo-geo-aeo…
Sign-up and sign-in UX as a design + copy discipline. Use when building or reviewing any auth surface — sign-up, sign-in, OTP, magic-link, passkey enrollment, forgot-password, recovery, or lockout. Owns the user-facing experience (copy, error states, recovery affordances, persona tests); defers integration mechanics…
SQL Server query performance optimization: SARGability, index strategy (ESR rule), parameter sniffing, execution plans, TVF/view patterns, concurrency, TempDB, compression, and diagnostic DMVs. Use when writing or reviewing T-SQL queries, stored procedures, table-valued functions, or views for performance.
SQL Server safety patterns that prevent production incidents: division guards, error handling, silent failures, injection, transaction safety. Use when editing .sql files with T-SQL syntax or TypeScript files with raw SQL queries ($executeRaw, $queryRaw, EXEC, BEGIN TRAN).
SQL Server and Azure SQL database design with proper types, naming conventions, indexing strategies, temporal tables, dynamic data masking, and T-SQL patterns. Use when designing schemas, writing DDL, or working with SQL Server or Azure SQL databases.
Write clear technical documentation — READMEs, runbooks, how-to guides, API references, procedures. Sentence discipline from ASD-STE100 principles (one instruction per sentence, one term one meaning), Diátaxis doc types, and a fresh-reader review step. Use when writing or reviewing documentation, a runbook, a…
Pragmatic testing guidance for JS/TS, React, and React Router. Focuses on confidence-to-effort ratio, behavioral testing, and avoiding brittle implementation-detail tests. Use when writing Vitest, Playwright, or React Testing Library code.
Writes and edits lint-compliant markdown files following markdownlint rules and best practices. Owns formatting and lint compliance only. Use when creating, editing, or reviewing the markdown mechanics of any .md file. For a document's content and structure (doc types, READMEs, runbooks, procedures) pair with…
Write persuasive marketing copy for landing pages, emails, ads, and sales materials using proven principles from legendary copywriters like David Ogilvy, Gary Halbert, Eugene Schwartz, and Bill Bernbach. Use when creating landing pages, email campaigns, sales letters, advertisements, headlines, taglines, value…
Suggests mindful breaks for wellness during long coding sessions. Triggers on fatigue signals, stress expressions, extended work, explicit requests ("need a break", "zen break"), or proactively during long conversations.
Zod schema design for form validation in React Router v7 apps using Conform or TanStack Form. Triggers when editing files that import from zod, working with form validation, creating schemas for Conform or TanStack Form, or defining input validation for route actions.