coldbox-orm-quick

Define Active Record entities and relationships for ColdBox applications with fluent queries and eager loading.

1|Updated Apr 10, 2026
One-click install
npx skills add https://github.com/ColdBox/skills --skill coldbox-orm-quick
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: coldbox-orm-quick
Source: https://github.com/ColdBox/skills/tree/main/orm/quick-orm
Command: npx skills add https://github.com/ColdBox/skills --skill coldbox-orm-quick

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides a clear, consistent way to define and operate database-backed entities in ColdBox applications so developers avoid repetitive SQL and manual relationship handling. It reduces boilerplate for CRUD operations, relationship management, eager loading, and common query patterns, helping teams build reliable data layers faster.

Core Features & Use Cases

  • Entity Modeling: Define Active Record entities with configurable table names, primary keys, fillable/hidden attributes, and type casts.
  • Relationships: Declare hasMany, belongsTo, hasOne, belongsToMany, and hasManyThrough relationships for navigable data models.
  • Fluent Querying & Eager Loading: Build expressive queries, apply scopes, eager-load relations to prevent N+1, paginate results, and perform bulk updates/deletes.
  • Accessors & Mutators: Transform attributes on read/write and encapsulate logic such as hashing or computed values.

Quick Start

Create a User entity with fillable firstName, lastName, email, and password, add hasMany posts and belongsTo role relations, and show a paginated query that eager-loads posts and role.

Frequently Asked Questions about coldbox-orm-quick

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I define Active Record entities and relationships in ColdBox?▼

You define Active Record entities in ColdBox by configuring table names, primary keys, and fillable attributes, then declare relationships like hasMany, belongsTo, hasOne, and belongsToMany to build navigable data models.

How do I prevent N+1 query problems when eager loading relationships in CFML?▼

To prevent N+1 query problems in CFML, use Quick ORM's fluent querying to eager-load relations, which retrieves related data in a single optimized query instead of issuing separate queries per entity.

How do I transform attribute values on read and write in ColdBox ORM?▼

You transform attribute values in ColdBox ORM by defining accessors and mutators on your entity, allowing you to encapsulate logic such as hashing passwords or computing derived values during read and write operations.

Can I use Quick ORM with BoxLang and CFML class conventions?▼

Yes, Quick ORM is compatible with BoxLang and CFML class conventions, allowing developers to integrate expressive fluent query APIs and Active Record modeling within standard ColdBox web applications and APIs.

What is the best way to paginate database records and apply query scopes in ColdBox?▼

The best way to paginate database records and apply query scopes in ColdBox is using Quick ORM's fluent query builder, which supports_paginating result sets and encapsulating reusable query logic into scopes.