JavaScripting

The definitive source of the best
JavaScript libraries, frameworks, and plugins.


  • ×

    A query builder for PostgreSQL, MySQL and SQLite3, designed to be flexible, portable, and fun to use.
    Filed under 

    • 🔾91%Overall
    • 13,563
    • 19 hours
    • 🕩1580
    • 👥28

    knex.js

    npm version npm downloads Coverage Status Dependencies Status Gitter chat Language Grade: JavaScript

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

    A batteries-included, multi-dialect (MSSQL, MySQL, PostgreSQL, SQLite3, Oracle (including Oracle Wallet Authentication)) query builder for Node.js, featuring:

    Node.js versions 10+ are supported.

    You can report bugs and discuss features on the GitHub issues page or send tweets to @kibertoad.

    For support and questions, join our Gitter channel.

    For knex-based Object Relational Mapper, see:

    To see the SQL that Knex will generate for a given query, you can use Knex Query Lab

    Examples

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

    const knex = require('knex')({
      client: 'sqlite3',
      connection: {
        filename: './data.db',
      },
    });
    
    try {
    
      // Create a table
      await knex.schema
        .createTable('users', table => {
          table.increments('id');
          table.string('user_name');
        })
        // ...and another
        .createTable('accounts', table => {
          table.increments('id');
          table.string('account_name');
          table
            .integer('user_id')
            .unsigned()
            .references('users.id');
        })
    
      // Then query the table...
      const insertedRows = await knex('users').insert({ user_name: 'Tim' })
    
      // ...and using the insert id, insert into the other table.
      await knex('accounts').insert({ account_name: 'knex', user_id: insertedRows[0] })
    
      // Query both of the rows.
      const selectedRows = await knex('users')
        .join('accounts', 'users.id', 'accounts.user_id')
        .select('users.user_name as user', 'accounts.account_name as account')
    
      // map over the results
      const enrichedRows = selectedRows.map(row => ({ ...row, active: true }))
    
      // Finally, add a catch statement
    } catch(e) {
      console.error(e);
    };
    

    TypeScript example

    import { Knex, knex } from 'knex'
    
    interface User {
      id: number;
      age: number;
      name: string;
      active: boolean;
      departmentId: number;
    }
    
    const config: Knex.Config = {
      client: 'sqlite3',
      connection: {
        filename: './data.db',
      },
    });
    
    const knexInstance = knex(config);
    
    try {
      const users = await knex<User>('users').select('id', 'age');
    } catch (err) {
      // error handling
    }
    
    Show All