Introducing mysql-orm-promise

December 31, 2015

  • database
  • Javascript
  • node
  • module
  • plugin
  • mysql
  • nodejs
  • operations
  • orm
  • promise
  • query


A node.js based ORM to communicate with your MySQL database.

After trying several npm packages for interacting with MySQL, I decided to create a cleaner and robust version of my own. I have come across packages which follow the callback as well as the promise based implementations, but query chaining was something which felt missing from those packages. I needed something which would be a shameless mockery of the mongoosejs package(a pure model implementation on schema basis, and allow me to chain my queries in an easy and cleaner way), but for MySQL.

Enter mysql-orm-promise

Using this package can be as easy as eating a pie(smirks). So let’s begin.

npm install mysql-orm-promise
var MysqlORM = require('mysql-orm-promise')
    host     : '<hostname>',
    user     : '<username>',
    password : '<password>',
    database : '<database_name>'
A simple query - retrieving all records
var UserModel = MysqlORM.model('user')
    // usersData is the array of results
    // The attributes of the records can be accessed as `usersData[0].attributes`
    // In order to get the `name` attribute of the user, you will have to execute the following code
Query Chaining
UserModel.where({"name": "Jack"})
    // handle the result data here

Moving Forward

mysql-orm-promise currently only allows you execute read operations on your database. Write operations are still a work in progress. You can check out the links below for future updates


Mumbai, Maharashtra, India


Copyright © 2021