A skill for optimizing SQL queries, focusing on PostgreSQL. It provides a checklist for query analysis, guidance on reading EXPLAIN plans, and patterns for common optimization problems like N+1 queries, JOINs, and pagination. Includes templates for benchmarking and recommending indexes. Use this skill when a user wants to improve the performance of a SQL query.
Use when user needs database query optimization, performance tuning, index strategies, execution plan analysis, or scalability across PostgreSQL, MySQL, MongoDB, Redis, and other database systems.
Writes, edits, and creates dbt models following best practices. Use when user needs to create new dbt SQL models, update existing models, or convert raw SQL to dbt format. Handles staging, intermediate, and mart models with proper config blocks, CTEs, and documentation.
PostgreSQL schema design with SQLModel. Use when designing database schemas, creating ERDs, defining models, planning migrations, or reviewing table structures. Triggers on tasks involving database tables, relationships, indexes, or data modeling for PostgreSQL.
Implements PlanetScale serverless MySQL with branching workflows, non-blocking schema changes, and Prisma integration. Use when building apps with PlanetScale, implementing database branching, or needing serverless MySQL.
Prisma ORM patterns for MiGestion - multi-tenant queries, migrations, seed. Trigger: When writing Prisma queries, migrations, or schema changes.
Database specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applications
Database schema migration patterns and best practices. Use when creating database migrations, implementing zero-downtime schema changes, version control for databases, or managing data migrations.
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
Database schema migration patterns for Aurora MySQL including reconciliation migrations, idempotent operations, and MySQL-specific gotchas.
Comprehensive SQLModel skill for Python database operations with SQL databases. Use when working with SQLModel for (1) Designing database models and table schemas, (2) Creating relationships between tables (foreign keys, one-to-many, many-to-many), (3) Integrating SQLModel with FastAPI for CRUD APIs, (4) Writing queries with select, where, joins, and filtering, (5) Implementing best practices for session management, migrations, and performance optimization. Covers the multiple model pattern (Base, Table, Create, Public, Update), dependency injection, pagination, error handling, and production-ready patterns.
Comprehensive SQLModel development assistance including model creation, relationship handling, database operations, and integration with FastAPI. Use when Claude needs to work with SQLModel projects for: (1) Creating data models with SQLModel, (2) Setting up database connections and sessions, (3) Implementing relationships between models, (4) Performing CRUD operations, (5) Handling advanced features like UUIDs and Decimals, or any other SQLModel database operations.
PostgreSQL memory system for AI agents. Use when: (1) Storing memories (decisions, learnings, observations, errors) (2) Retrieving context from past sessions (3) Searching memories or sources via full-text search (4) Ingesting external sources (docs, podcasts, blogs, Obsidian notes) (5) Tracking costs, tokens, or command analytics Triggers: "pgm", "remember this", "add to memory", "store memory", "search memories", "ingest source", "pg-memory"
Create database migrations following Laravel best practices with reversible up/down methods, focused single-purpose changes, proper index management, and clear naming conventions. Use this skill when creating new database tables, adding or modifying columns in existing tables, creating or dropping indexes, implementing foreign key constraints, renaming tables or columns, or managing database schema changes. This skill applies when working on migration files in database/migrations/ directory, generating new migrations via artisan commands, or ensuring zero-downtime deployments with backwards-compatible schema changes.
Manage database operations, migrations, RLS policies, and performance optimization
Create and manage database migrations following best practices for schema changes and data migrations. Use this skill when creating database migration files, modifying database schemas, adding or removing tables and columns, working with migration files (prisma/migrations/*, db/migrate/*, migrations/*), implementing reversible migrations with rollback methods, managing database indexes, handling zero-downtime deployments, separating schema changes from data migrations, or ensuring backwards compatibility during schema updates. Apply this skill when setting up new database tables, altering existing database structures, creating migration scripts, or reviewing migration safety and rollback strategies.
Database migration toolkit for Supabase projects. Use when: (1) Creating new migration files, (2) Writing schema changes (CREATE TABLE, ALTER, etc.), (3) Adding indexes, triggers, or RLS policies, (4) Fixing RLS performance issues (auth function wrapping, policy consolidation), (5) Validating migration conventions, (6) Running migrations locally, (7) Naming database objects
Database optimization, query performance, indexing strategies, and caching patterns. Use when optimizing queries, designing database schemas, or improving application performance.
SQL query patterns, optimization techniques, and best practices for efficient database operations
SQL query optimization, indexing strategies, and EXPLAIN analysis for database performance. WHEN: MUST use for slow queries, EXPLAIN analysis, index design, N+1 problems. Invoke with "/sql-optimization-patterns" or "optimize this query", "analyze EXPLAIN", "fix slow query". WHEN NOT: ORM-specific patterns (use framework skills), application-level caching, database migrations.
Database design, schema optimization, indexing strategies, and migration management.
Safe database migration creation and management for Supabase PostgreSQL
Rails migrations - schema changes, data migrations, migration commands. Use when creating or modifying database migrations.
