Knex.js (pronounced/kəˈnɛks/) is a "batteries included" SQL query builder forPostgreSQL,CockroachDB,MSSQL,MySQL,MariaDB,SQLite3,Better-SQLite3,Oracle, andAmazon Redshift designed to be flexible, portable, and fun to use.

It features both traditional node stylecallbacks as well as apromise interface for cleaner async flow control,a stream interface, full-featuredquery andschema builders,transaction support (with savepoints), connectionpooling and standardized responses between different query clients and dialects.