Can I use this for complex relationships?

Absolutely. It includes patterns for one-to-one, one-to-many, many-to-many (with or without junction models), and self-referential associations.

Does it include transaction management?

Yes, it covers both managed and unmanaged transaction patterns, including isolation level configuration to ensure data consistency.

Does this skill support PostgreSQL-specific types?

Yes, it provides detailed mappings for Postgres-specific types like JSONB, BIGINT, UUID, and ARRAY, along with appropriate indexing strategies.

How does it help with query performance?

It provides specific patterns for eager loading to prevent N+1 problems, as well as guidance on using scopes and efficient attribute selection.

Sequelize Model Expert

Name: Sequelize Model Expert
Author: francanete

byfrancanete

データベース管理

Standardizes Sequelize ORM model definitions and best practices for high-performance PostgreSQL implementations.

概要

The Sequelize Model Expert skill provides Claude with specialized knowledge for architecting robust database schemas using the Sequelize ORM. It focuses on PostgreSQL-specific optimizations, including precise data type mappings (like JSONB and BIGINT), complex association patterns, and advanced model features such as scopes, hooks, and custom validations. This skill is essential for developers looking to build scalable Node.js backends with clean, maintainable, and performant data layers while avoiding common pitfalls like N+1 query issues and insecure transaction handling.

主な機能

0 GitHub stars
Advanced lifecycle hooks for automation and audit logging
Query optimization techniques including eager loading and indexing
PostgreSQL-specific data type mappings and ID patterns
Comprehensive association logic (One-to-Many, Many-to-Many, Self-Referential)
Built-in and custom validation patterns for data integrity

ユースケース

Refactoring existing Sequelize models to follow industry best practices
Optimizing database performance through strategic indexing and transaction management
Designing complex relational database schemas from scratch

概要

主な機能

0 GitHub stars
Advanced lifecycle hooks for automation and audit logging
Query optimization techniques including eager loading and indexing
PostgreSQL-specific data type mappings and ID patterns
Comprehensive association logic (One-to-Many, Many-to-Many, Self-Referential)
Built-in and custom validation patterns for data integrity

ユースケース

Refactoring existing Sequelize models to follow industry best practices
Optimizing database performance through strategic indexing and transaction management
Designing complex relational database schemas from scratch