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: