What problem does it solve?
Indexes are essential for reducing query latency and preventing full table scans, but designing and applying the right indexes is error prone and can hurt write performance if done incorrectly. This Skill documents how to declare indexes in GORM model tags and apply them safely so queries that use WHERE, JOIN, or ORDER BY run significantly faster without unnecessary overhead.
Core Features & Use Cases
- Declarative index definitions: Define basic and named indexes, unique constraints, and multiple indexes directly on struct fields using model tags.
- Composite and shared indexes: Create multi-column indexes, control column ordering via priority, and use shared composite naming for embedded structs to avoid duplicates.
- Advanced index options: Configure partial indexes, expression indexes, index type and class, collation, prefix length, comments, and database-specific options such as concurrent creation or parsers.
- Practical use cases: Speed up search and lookup queries, enforce uniqueness across columns, reduce cost of frequent joins, and implement efficient partial indexes for active subsets of data.
Quick Start
Tag your model fields with index or uniqueIndex (and additional options) and run AutoMigrate to create the indexes in the database.
