knex

A batteries-included SQL query & schema builder for Postgres, MySQL and SQLite3 and the Browser

knex.js

A SQL query builder that is flexible, portable, and fun to use!

A batteries-included, multi-dialect (MySQL, PostgreSQL, SQLite3, WebSQL) query builder for Node.js and the Browser, featuring:

Read the full documentation to get started!

For support and questions, join the #bookshelf channel on freenode IRC

For an Object Relational Mapper, see: http://bookshelfjs.org

We have several examples on the website. Here is the first one to get you started:

var knex = require('knex')({
  dialect: 'sqlite3',
  connection: {
    filename: './data.db'
  }
});
 
// Create a table 
knex.schema.createTable('users', function(table) {
  table.increments('id');
  table.string('user_name');
})
 
// ...and another 
.createTable('accounts', function(table) {
  table.increments('id');
  table.string('account_name');
  table.integer('user_id').unsigned().references('users.id');
})
 
// Then query the table... 
.then(function() {
  return knex.insert({user_name: 'Tim'}).into('users');
})
 
// ...and using the insert id, insert into the other table. 
.then(function(rows) {
  return knex.table('accounts').insert({account_name: 'knex', user_id: rows[0]});
})
 
// Query both of the rows. 
.then(function() {
  return knex('users')
    .join('accounts', 'users.id', 'accounts.user_id')
    .select('users.user_name as user', 'accounts.account_name as account');
})
 
// .map over the results 
.map(function(row) {
  console.log(row);
})
 
// Finally, add a .catch handler for the promise chain 
.catch(function(e) {
  console.error(e);
});