sql
This skill should be used when the user asks to "write SQL", "optimize a query", "explain this SQL", or needs help with database queries and SQL best practices.
Découvrez les skills tools sql databases, comparez leurs dépôts et consultez leurs instructions.
This skill should be used when the user asks to "write SQL", "optimize a query", "explain this SQL", or needs help with database queries and SQL best practices.
Complete knowledge of the PostgreSQL schema, Prisma ORM patterns, indexes, and migration workflows.
Analyze McDougall-style fuel business data (SQLite via Laravel) to answer business questions, build KPIs, propose dashboards, and deliver actionable insights for operations leadership.
Neon PostgreSQL serverless database - connection pooling, branching, serverless driver, and optimization. Use when deploying to Neon or building serverless applications.
Lint PostgreSQL functions against schema, analyze usage, and generate fix reports; use when detecting broken functions, validating schema contracts, or cleaning up unused database functions
Drizzle ORM patterns for PostgreSQL.
Design efficient Eloquent relationships with proper eager loading, scopes, and query optimization. Use this when working with models, relationships, or database queries.
Advanced SQLModel patterns and comprehensive database migrations with Alembic. Use when creating SQLModel models, defining relationships (one-to-many, many-to-many, self-referential), setting up database migrat...
Generate Drizzle migrations with composite indexes, multi-tenancy support (organization_id), and timestamp triggers. Use when creating tables, adding columns, or implementing tenant isolation.
Comprehensive guide to optimizing database queries, understanding EXPLAIN plans, indexing strategies, and eliminating N+1 queries
Zero-downtime patterns for production schema changes and large backfills, including expand/contract, batching, verification, and rollback strategies
Understanding and implementing database locking mechanisms for concurrency control.
Continuous monitoring and diagnostics for ensuring high availability, performance, and stability of database systems.
Comprehensive guide to database transactions, ACID properties, isolation levels, locking, and distributed transactions.
Implementing and optimizing database connection pools for high-performance applications.
Strategies for managing data structures, versioning, and evolutions across databases and event streams.
Generate repository class for SQLite data access with CRUD methods, row mapping, and TypeScript types. Use when creating new database tables or data access layers.
GLOWマスタデータのスキーマ調査とSQL分析。jqでテーブル構造確認、DuckDBでCSVクエリ。マスタデータ、CSV、スキーマで使用。
Modify Drizzle ORM database schema safely. Use when user mentions "add table", "new column", "database schema", "migration", or "drizzle".
Performance monitoring and optimization. Use when user needs N+1 detection, slow query analysis, memory profiling, or says "performance issue", "slow queries", "N+1 problem", "optimize performance", "memory lea...
Database maintenance and health checks. Use when user needs migration safety, data integrity, index optimization, or says "check database", "optimize DB", "migration rollback", "data consistency", "database hea...
PostgreSQL database operations specialist using Drizzle ORM for schema management, queries, and migrations
Validates SQL schema files for compliance with internal safety and naming policies.
Explore PostgreSQL and DuckDB schemas, tables, and sample data. Use when investigating data issues, checking table structures, or when user asks "DB 구조 알려줘", "데이터 확인해줘".
Le classement utilise les étoiles du dépôt GitHub indexé. Plusieurs skills peuvent partager ce nombre : ce n’est ni un nombre d’installations ni une note de qualité.