GORM ORM

What problem does it solve?

This Skill helps Go developers avoid repetitive, error-prone SQL by providing patterns and instructions to define models, initialize connections, run migrations, and perform reliable CRUD and association operations using GORM.

Core Features & Use Cases

• Model Definitions & Struct Tags: Guides on designing models, primary keys, timestamps, soft deletes, and JSON/db tags for predictable schema mapping.
• Connection Management: Initialization patterns for SQLite, MySQL, and PostgreSQL with sensible logger and configuration examples.
• CRUD, Queries & Preloading: Examples for common create, read, update, delete flows, filtered queries, ordering, pagination, and eager loading of associations.
• Associations, Transactions & Hooks: Best practices for one-to-one, one-to-many, nested preloads, transactional workflows, and lifecycle hooks.
• Migrations & Schema Operations: AutoMigrate usage, checking/creating tables, adding columns and indexes, and recommendations for production migrations.
• Use Case: Build a user management system with profiles and orders, ensure referential integrity with cascading deletes, and implement transactional order creation with rollback on failure.

Quick Start

Use the GORM ORM skill to initialize a database connection, auto-migrate User, Profile, and Order models, and perform a basic create-and-query cycle for a User record.