Knex.js logo

Knex.js

SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle
179
401
+ 1
49

What is Knex.js?

Knex.js is a "batteries included" SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle designed to be flexible, portable, and fun to use. It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full featured query and schema builders, transaction support (with savepoints), connection pooling and standardized responses between different query clients and dialects.
Knex.js is a tool in the Database Tools category of a tech stack.
Knex.js is an open source tool with GitHub stars and GitHub forks. Here’s a link to Knex.js's open source repository on GitHub

Who uses Knex.js?

Companies
36 companies reportedly use Knex.js in their tech stacks, including Voiceflow, Finema, and Backend.

Developers
137 developers on StackShare have stated that they use Knex.js.

Knex.js Integrations

MySQL, PostgreSQL, SQLite, Oracle, and IndexedDB are some of the popular tools that integrate with Knex.js. Here's a list of all 9 tools that integrate with Knex.js.
Pros of Knex.js
11
Write once and then connect to almost any sql engine
10
Faster
8
Nice api, Migrations/Seeds
7
Flexibility in what engine you choose
7
Free
5
Multi support and easy to use
1
Simple query API

Knex.js's Features

  • SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle

Knex.js Alternatives & Comparisons

What are some alternatives to Knex.js?
Sequelize
Sequelize is a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL, MariaDB, SQLite and MSSQL and features solid transaction support, relations, read replication and more.
Slick
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
Spring Data
It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
Dataform
Dataform helps you manage all data processes in your cloud data warehouse. Publish tables, write data tests and automate complex SQL workflows in a few minutes, so you can spend more time on analytics and less time managing infrastructure.
DB
With DB you can very easily save, restore, and archive snapshots of your database from the command line. It supports connecting to different database servers (for example a local development server and a staging or production server) and allows you to load a database dump from one environment into another environment.
See all alternatives

Knex.js's Followers
401 developers follow Knex.js to keep up with related blogs and decisions.