name	waterline
description	Waterline ORM query language, model definitions, associations, and data access patterns for Sails.js. Use this skill when writing, reviewing, or debugging Waterline queries, model attributes, associations, lifecycle callbacks, validations, or any database interaction in a Sails.js application.
metadata	{"author":"sailscastshq","version":"1.0.0","tags":"waterline, sails, orm, database, query, models"}

Waterline ORM

Waterline is the datastore-agnostic ORM/ODM used by Sails.js. It provides a normalized API for interacting with any supported database (PostgreSQL, MySQL, MongoDB, SQLite, Redis) using a consistent query language.

When to Use

Use this skill when:

Defining Sails.js models (attributes, types, validations, associations)
Writing Waterline queries (find, create, update, destroy, count, etc.)
Using criteria objects with operators (contains, startsWith, in, nin, <, >, !=, or, and)
Setting up associations (one-to-one, one-to-many, many-to-many)
Handling query errors (.intercept(), .tolerate(), E_UNIQUE)
Working with transactions, streaming, aggregation, or collection manipulation
Configuring datastores and model settings

Rules

Read individual rule files for detailed explanations and code examples:

rules/getting-started.md - Core concepts, model definition, datastores, configuration
rules/query-language.md - WHERE operators, criteria modifiers, or/and, sort, limit, skip, select, omit
rules/model-methods.md - find, findOne, findOrCreate, create, update, destroy, and their variants
rules/associations.md - one-to-one, one-to-many, many-to-many, populate, cross-datastore
rules/attributes-and-validations.md - Types, validation rules, columnName, protect, encrypt, defaultsTo
rules/lifecycle-callbacks.md - beforeCreate, beforeUpdate, afterCreate, customToJSON
rules/error-handling.md - .intercept(), .tolerate(), E_UNIQUE, UsageError, AdapterError
rules/transactions.md - getDatastore().transaction(), .usingConnection(), leased connections
rules/aggregation-and-streaming.md - count, sum, avg, stream, eachRecord, eachBatch
rules/collections-and-advanced.md - addToCollection, removeFromCollection, replaceCollection, archive, native, meta

Waterline ORM

When to Use

Use this skill when:

Defining Sails.js models (attributes, types, validations, associations)

Writing Waterline queries (find, create, update, destroy, count, etc.)

Using criteria objects with operators (contains, startsWith, in, nin, <, >, !=, or, and)

Setting up associations (one-to-one, one-to-many, many-to-many)

Handling query errors (.intercept(), .tolerate(), E_UNIQUE)

Working with transactions, streaming, aggregation, or collection manipulation

Configuring datastores and model settings

Rules

Read individual rule files for detailed explanations and code examples:

rules/getting-started.md - Core concepts, model definition, datastores, configuration

rules/query-language.md - WHERE operators, criteria modifiers, or/and, sort, limit, skip, select, omit

rules/model-methods.md - find, findOne, findOrCreate, create, update, destroy, and their variants

rules/associations.md - one-to-one, one-to-many, many-to-many, populate, cross-datastore

rules/attributes-and-validations.md - Types, validation rules, columnName, protect, encrypt, defaultsTo

rules/lifecycle-callbacks.md - beforeCreate, beforeUpdate, afterCreate, customToJSON

rules/error-handling.md - .intercept(), .tolerate(), E_UNIQUE, UsageError, AdapterError

rules/transactions.md - getDatastore().transaction(), .usingConnection(), leased connections

rules/aggregation-and-streaming.md - count, sum, avg, stream, eachRecord, eachBatch

rules/collections-and-advanced.md - addToCollection, removeFromCollection, replaceCollection, archive, native, meta

waterline

Waterline ORM

When to Use

Rules

同仓库更多 Skills

同仓库更多 Skills

Waterline ORM

When to Use

Rules