A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
Alternatives To Knex
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
3 hours ago1,803apache-2.0Java
Free universal database tool and SQL client
Typeorm32,1941,9943,15410 hours ago741July 22, 20232,169mitTypeScript
ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Directus23,2871853 hours ago86July 25, 2023299otherTypeScript
The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
Knex18,05318,0963,349a day ago255July 12, 2023876mitJavaScript
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
Dbal9,17547,9463,9324 days ago120April 14, 2023206mitPHP
Doctrine Database Abstraction Layer
Usql8,238213a day ago152July 18, 202368mitGo
Universal command-line interface for SQL databases
Freesql3,77081746 days ago544August 13, 202361mitC#
🦄 .NET orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, QuestDB orm, MsAccess orm.
Xo3,43128a month ago2April 16, 202142mitGo
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
Pony3,31915 days ago3January 28, 2022312apache-2.0Python
Pony Object Relational Mapper
Requery3,0884642 years ago25May 06, 2019174apache-2.0Java
requery - modern SQL based query & persistence for Java / Kotlin / Android
Alternatives To Knex
Select To Compare

Alternative Project Comparisons


npm version npm downloads Coverage Status Dependencies Status Gitter chat

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

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

Node.js versions 12+ 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

Usage as ESM module

If you are launching your Node application with --experimental-modules, knex.mjs should be picked up automatically and named ESM import should work out-of-the-box. Otherwise, if you want to use named imports, you'll have to import knex like this:

import { knex } from 'knex/knex.mjs';

You can also just do the default import:

import knex from 'knex';

If you are not using TypeScript and would like the IntelliSense of your IDE to work correctly, it is recommended to set the type explicitly:

 * @type {Knex}
const database = knex({
  client: 'mysql',
  connection: {
    host: '',
    user: 'your_database_user',
    password: 'your_database_password',
    database: 'myapp_test',
Popular Oracle Projects
Popular Sqlite Projects
Popular Companies Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.
Query Builder