Knex.js

knexjs.org

Batteries-included SQL query builder for JavaScript

Visit
Knex.js screenshot
/ About /

Knex.js is an open-source SQL query builder for JavaScript and Node.js that supports multiple databases including PostgreSQL, MySQL, SQLite3, MSSQL, and Amazon Redshift. It provides a unified API with promise and callback interfaces, schema building, transaction support, and connection pooling. TypeScript bindings are included, and it can also be used in the browser for learning purposes.

/ How it works /

Developers install Knex via npm and use its fluent JavaScript API to compose SQL queries that are translated into the appropriate dialect for the configured database client.

/ Who it's for /

JavaScript and Node.js developers building database-driven applications

/ More info /

Background.

Status
launched
Business model
open-source
/ Discovered patterns /

Similar projects.

Coming soonSpektrail’s read on Dev Tools

Editorial take on the space this project sits in — momentum signals, adjacent moves, our call on whether the wedge is real. Get pinged when we publish a new read or when the landscape shifts.

Coming soon

Have a take on this space?

Tell us what you’d build differently, where you think the incumbents miss, or what we’ve gotten wrong about this project. Comments + reactions are coming soon.