sql-optimization-patterns
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...
Discover tools sql databases skills, compare source repositories and read the instructions for each workflow.
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...
Database migration patterns for Supabase, Prisma, and Drizzle ORM. Best practices for schema changes, rollbacks, and production deployments. Use when managing database schema evolution in production application...
Axum 0.8+ production patterns with SQLx. Use when: building Rust APIs, async database, error handling. Do not use for: API design decisions (use api-design skill). Workflow: api-design (design) → this skill (im...
PostgreSQL problem-solving patterns for production systems. Use when: query optimization, concurrency issues, zero-downtime migrations, scaling decisions, debugging slow queries, implementing patterns from data...
Transform business requirements into logical data models. Use when: entity extraction, relationship analysis, normalization decisions, schema design. Do not use for: physical implementation details (use postgre...
SQLite problem-solving patterns for embedded/edge deployments. Use when: connection setup, "database locked" errors, ALTER TABLE workarounds, concurrency problems, FTS setup, SQLite-specific gotchas. Do not use...
Drizzle ORM + SQLiteを使用したデータベーススキーマの設計を支援します。テーブル設計、リレーション定義、インデックス設計などをプロジェクトの規約に沿って行います。You MUST use this when you create Drizzle ORM + SQ...
MariaDB database development standards. Triggers when working with MariaDB databases, Galera cluster, or MariaDB-specific features.
MySQL database development standards. Triggers when working with MySQL databases, queries, schema design, or optimization.
DBA Tuner Agent. 쿼리 최적화, 인덱스 설계, 슬로우 쿼리 분석을 담당합니다.
Use when working with Neon serverless PostgreSQL database. Covers database setup, CLI commands, Drizzle ORM integration, schema migrations, connection pooling, and user data storage patterns for authentication...
Expert guidance for designing, optimizing, and maintaining database schemas for SQL and NoSQL systems. Use when creating new databases, optimizing existing schemas, planning migrations, implementing security po...
Handles database schema design, Drizzle ORM queries, and Expo SQLite migrations.
Expertise in better-sqlite3 and schema management for the 5BulletMethod app.
SQL and database best practices including query optimization, indexing, and schema design.
MongoDB best practices including schema design, indexing, and query optimization.
Warn and protect against dangerous database operations on production database in the readathon project
Create and manage database migrations with reversible up/down methods, zero-downtime deployment strategies, and proper schema versioning. Use this skill when creating database migration files, altering table sc...
Define and structure database models and entities with proper naming conventions, timestamps, data integrity constraints, relationships, and validation layers. Use this skill when creating or modifying ORM mode...
Write optimized and secure database queries using parameterized queries, eager loading, strategic indexing, and proper transaction management. Use this skill when writing database queries, repository methods, o...
PostgreSQL 16, pgvector, RLS, 실시간 구독, Edge Functions를 다루는 Supabase 전문가. Supabase 백엔드를 활용한 풀스택 앱 개발 시 사용
PostgreSQL, MongoDB, Redis 및 현대적 애플리케이션을 위한 고급 데이터 패턴을 다루는 Database 전문가
Neon serverless PostgreSQL 전문가 - auto-scaling, database branching, PITR, connection pooling 지원. serverless 앱에서 PostgreSQL 필요시 사용
PostgreSQL expert for .sql migration files, CREATE TABLE, ALTER TABLE, indexes, constraints, foreign keys, schema changes, docker/postgres/migrations/, init.sql, idempotent SQL, transactions, BEGIN/COMMIT, psql...
The default order uses GitHub repository stars from our indexed data. Stars belong to the source repository and may be shared by multiple skills. They indicate repository interest, not skill installs or an independent quality score.