futuregerald
@futuregerald
Public Skills
sql-optimization-patterns
by futuregerald
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
verification-before-completion
by futuregerald
Use when about to claim work is complete, fixed, or passing, before committing or creating PRs - requires running verification commands and confirming output before making any success claims; evidence before assertions always
adonisjs-best-practices
by futuregerald
Use when building AdonisJS v6 applications, implementing features in AdonisJS, or reviewing AdonisJS code. Covers routing, controllers, validation, authentication, database patterns, testing, and error handling.
baoyu-article-illustrator
by futuregerald
Smart article illustration skill. Analyzes article content and generates illustrations at positions requiring visual aids with multiple style options. Use when user asks to "add illustrations to article", "generate images for article", or "illustrate article".
agent-browser
by futuregerald
Automates browser interactions for web testing, form filling, screenshots, and data extraction. Use when the user needs to navigate websites, interact with web pages, fill forms, take screenshots, test web applications, or extract information from web pages.
systematic-debugging
by futuregerald
Use when encountering any bug, test failure, or unexpected behavior, before proposing fixes
api-design-principles
by futuregerald
Master REST and GraphQL API design principles to build intuitive, scalable, and maintainable APIs that delight developers. Use when designing new APIs, reviewing API specifications, or establishing API design standards.
error-handling-patterns
by futuregerald
Master error handling patterns across languages including exceptions, Result types, error propagation, and graceful degradation to build resilient applications. Use when implementing error handling, designing APIs, or improving application reliability.
programmatic-seo
by futuregerald
When the user wants to create SEO-driven pages at scale using templates and data. Also use when the user mentions "programmatic SEO," "template pages," "pages at scale," "directory pages," "location pages," "[keyword] + [city] pages," "comparison pages," "integration pages," or "building many pages for SEO." For auditing existing SEO issues, see seo-audit.
executing-plans
by futuregerald
Use when you have a written implementation plan to execute in a separate session with review checkpoints
writing-plans
by futuregerald
Use when you have a spec or requirements for a multi-step task, before touching code
receiving-code-review
by futuregerald
Use when receiving code review feedback, before implementing suggestions, especially if feedback seems unclear or technically questionable - requires technical rigor and verification, not performative agreement or blind implementation
architecture-decision-records
by futuregerald
Write and maintain Architecture Decision Records (ADRs) following best practices for technical decision documentation. Use when documenting significant technical decisions, reviewing past architectural choices, or establishing decision processes.
better-auth-best-practices
by futuregerald
Skill for integrating Better Auth - the comprehensive TypeScript authentication framework.
writing-skills
by futuregerald
Use when creating new skills, editing existing skills, or verifying skills work before deployment
brainstorming
by futuregerald
'You MUST use this before any creative work - creating features, building components, adding functionality, or modifying behavior. Explores user intent, requirements and design before implementation.'
finishing-a-development-branch
by futuregerald
Use when implementation is complete, all tests pass, and you need to decide how to integrate the work - guides completion of development work by presenting structured options for merge, PR, or cleanup
turso-best-practices
by futuregerald
Turso and libSQL best practices for SQLite-compatible cloud database development with edge distribution, embedded replicas, and vector search.
code-search
by futuregerald
Fast code search agent for finding patterns, understanding features, and exploring the codebase. Use when searching for code, finding usages, or understanding how something works.
ui-design
by futuregerald
Practical UI design principles for developers and non-designers. Use when creating web interfaces, components, dashboards, landing pages, or any visual design work. Covers hierarchy, spacing, typography, color, depth, and polish. Based on Refactoring UI methodology.
code-simplifier
by futuregerald
Simplifies and refines code for clarity, consistency, and maintainability while preserving all functionality. Focuses on recently modified code unless instructed otherwise.
requesting-code-review
by futuregerald
Use when completing tasks, implementing major features, or before merging to verify work meets requirements
copywriting
by futuregerald
When the user wants to write, rewrite, or improve marketing copy for any page — including homepage, landing pages, pricing pages, feature pages, about pages, or product pages. Also use when the user says "write copy for," "improve this copy," "rewrite this page," "marketing copy," "headline help," or "CTA copy." For email copy, see email-sequence. For popup copy, see popup-cro.
using-git-worktrees
by futuregerald
Use when starting feature work that needs isolation from current workspace or before executing implementation plans - creates isolated git worktrees with smart directory selection and safety verification
skill-creator
by futuregerald
Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's capabilities with specialized knowledge, workflows, or tool integrations.
create-auth-skill
by futuregerald
Skill for creating auth layers in TypeScript/JavaScript apps using Better Auth.
design-principles
by futuregerald
Enforce a precise, minimal design system inspired by Linear, Notion, and Stripe. Use this skill when building dashboards, admin interfaces, or any UI that needs Jony Ive-level precision - clean, modern, minimalist with taste. Every pixel matters.
frontend-design
by futuregerald
Create distinctive, production-grade frontend interfaces with high design quality. Use this skill when the user asks to build web components, pages, or applications. Generates creative, polished code that avoids generic AI aesthetics.
javascript-testing-patterns
by futuregerald
Comprehensive JavaScript/TypeScript testing patterns for Jest, Vitest, and AdonisJS/Japa. Use when writing tests, reviewing test code, or debugging test failures.
SQLite Database Expert
by futuregerald
Expert in SQLite, libSQL, and Turso database development for desktop and web applications with focus on SQL injection prevention, migrations, FTS search, edge deployments, and secure data handling
dispatching-parallel-agents
by futuregerald
Use when facing 2+ independent tasks that can be worked on without shared state or sequential dependencies
using-superpowers
by futuregerald
Use when starting any conversation - establishes how to find and use skills, requiring Skill tool invocation before ANY response including clarifying questions
marketing-psychology
by futuregerald
"When the user wants to apply psychological principles, mental models, or behavioral science to marketing. Also use when the user mentions 'psychology,' 'mental models,' 'cognitive bias,' 'persuasion,' 'behavioral science,' 'why people buy,' 'decision-making,' or 'consumer behavior.' This skill provides 70+ mental models organized for marketing application."
subagent-driven-development
by futuregerald
Use when executing implementation plans with independent tasks in the current session