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


    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


    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 => {
        // ...and another
        .createTable('accounts', table => {
      // 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', '', 'accounts.user_id')
        .select('users.user_name as user', 'accounts.account_name as account')
      // map over the results
      const enrichedRows = => ({ ...row, active: true }))
      // Finally, add a catch statement
    } catch(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