A simple, sane and modern ORM library for Node.js
Last updated 4 years ago by haukur .
MIT · Repository · Bugs · Original npm · Tarball · package.json
$ cnpm install ormur 
SYNC missed versions from official npm registry.


Package Version Build Status Test Coverage License

A simple, sane & modern ORM library for Node.js


  • High extensibility and behaviour customization via inheritance.
  • Schema validation and custom field validations.
  • High-level query interface along with a Knex instance for custom queries.
  • Use promises instead of callbacks to interact with the database.
  • Default values and value transformations before creating records.
  • Automatic snake_case (for the database) and camelCase (for JavaScript) handling.
  • Safe JSON serialization by omitting private fields.

And much more - see the example below to get an idea.


Requires Node.js v4.0.0 or higher.

npm install ormur


Check out the basic example for an example of a minimal base model and an example model inheriting from it.

For an example of how you may share schema between models, check the advanced example.

The User model defined in the above examples could be used like this, assuming that the relevant database table exists:

const User = require('./example/basic/user');

// Create an instance
const user = new User({ name: 'Hawk', email: 'test@example.com', password: 'password' });

// Persist it to the database
user.save().then(user => {
  console.log(`User ${user.name} with id ${user.id} saved.`);

// Find users with the name "Hawk"
User.where({ name: 'Hawk' }).then(users => {
  // Array of User instances.

// Find a user by its primary key and remove it from the database
User.find(1).then(user => user.destroy());

// Or, maybe more succintly


Documentation pending.

Static methods

  • Ormur.find - Find row by primary key.
  • Ormur.where - Find rows by attributes.
  • Ormur.create - Create row with attributes.
  • Ormur.destroy - Remove row by primary key.

Instance methods

  • Ormur#validate - Validate attributes.
  • Ormur#save - Insert row into database with attributes from instance.
  • Ormur#update - Update existing row in database with attributes from instance.
  • Ormur#destroy - Remove row from database by primary key of instance.
  • Ormur#setDefaults - Set default values to instance attributes.
  • Ormur#merge - Merge two objects (inheritance helper).

Current Tags

  • 0.2.0                                ...           latest (4 years ago)

2 Versions

  • 0.2.0                                ...           4 years ago
  • 0.1.0                                ...           4 years ago
Maintainers (1)
Today 0
This Week 0
This Month 0
Last Day 0
Last Week 0
Last Month 0
Dependencies (4)
Dev Dependencies (6)
Dependents (0)

Copyright 2014 - 2016 © taobao.org |