10 Best Node.js Query Builders Libraries

List hand-picked by Openbase Experts
Learn More

prisma

Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)

License Icon
License: Apache-2.0
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User Rating
4.7/ 5
10
Top Feedback
9Great Documentation
6Easy to Use
5Performant
GitHub Stars
18K
Weekly Downloads
276K
Last Commit
7d ago

@prisma/client

Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)

License Icon
License: Apache-2.0
TypeScript Icon
TypeScript Definitions: Built-In
User Rating
4.7/ 5
12
Top Feedback
7Great Documentation
7Easy to Use
2Poor Documentation
GitHub Stars
18K
Weekly Downloads
270K
Last Commit
7d ago

knex

A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: Built-In
User Rating
4.3/ 5
25
Top Feedback
18Great Documentation
13Easy to Use
12Performant
GitHub Stars
15K
Weekly Downloads
816K
Last Commit
8d ago
bod

bodybuilder

An elasticsearch query body builder 💪

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: Built-In
User Rating
5.0/ 5
2
Top Feedback
N/A
GitHub Stars
1K
Weekly Downloads
50K
Last Commit
3mos ago

objection

An SQL-friendly ORM for Node.js

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: Built-In
User Rating
3.3/ 5
3
Top Feedback
3Great Documentation
2Easy to Use
1Performant
GitHub Stars
6K
Weekly Downloads
115K
Last Commit
1mo ago
edt

elastic-dsl-typescript

Typescript ElasticSearch search query builder

License Icon
License: GPL-3.0
TypeScript Icon
TypeScript Definitions: Built-In
User Rating
5.0/ 5
1
Top Feedback
1Great Documentation
GitHub Stars
3
Weekly Downloads
13
Last Commit
3mos ago
sqb

solr-query-builder

solr query builder

License Icon
License: Unknown
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User Rating
5.0/ 5
1
Top Feedback
N/A
GitHub Stars
N/A
Weekly Downloads
277
Last Commit
N/A
mqu

mquery

Expressive MongoDB query builder

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
427
Weekly Downloads
2M
Last Commit
3mos ago

es-alchemy

Simplification of Elasticsearch interactions

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
2
Weekly Downloads
80
Last Commit
9d ago
eb

elastic-builder

A Node.js implementation of the elasticsearch Query DSL 👷‍♂️

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: Built-In
User RatingN/A
Top Feedback
N/A
GitHub Stars
399
Weekly Downloads
44K
Last Commit
4mos ago

sql-bricks

Transparent, Schemaless SQL Generation

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
157
Weekly Downloads
23K
Last Commit
3mos ago

knex-node-firebird

A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
15K
Weekly Downloads
2
Last Commit
8d ago
mu

mysql-utilities

Query builder for node-mysql with introspection, etc.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
104
Weekly Downloads
2K
Last Commit
4mos ago

@moccacoders/node-obremap

Laravel's Eloquent ORM for nodejs

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
7
Weekly Downloads
12
Last Commit
2mos ago

@sqorn/pg

A Javascript library for building SQL queries

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
2K
Weekly Downloads
2K
Last Commit
3yrs ago

fxsql

Node.js Functional SQL Query Builder & ORM

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
176
Weekly Downloads
23
Last Commit
6mos ago

pelias-query

geospatial queries used by the pelias api

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
11
Weekly Downloads
54
Last Commit
3mos ago
eb

es-builder

Elasticsearch query builder for Node.js

License Icon
License: ISC
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
20
Weekly Downloads
637
Last Commit
4yrs ago
nq

node-querybuilder

Node QueryBuilder Adapter for Node.js (tags: nodejs, node, mysql, active record, activerecord, querybuilder, query builder)

License Icon
License: Unknown
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
43
Weekly Downloads
182
Last Commit
2yrs ago

esq

Simple query builder for elasticsearch

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
57
Weekly Downloads
85
Last Commit
6yrs ago

anydb-sql

Minimal node ORM for mysql, postgresql and sqlite with complete arbitrary SQL query support

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: Built-In
User RatingN/A
Top Feedback
N/A
GitHub Stars
38
Weekly Downloads
53
Last Commit
3yrs ago

sql-bricks-sqlite

Transparent, Schemaless SQL Generation for the SQLite dialect

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
2
Weekly Downloads
46
Last Commit
7yrs ago

xql

SQL builder and utilities library for node.js (runs in browser as well).

License Icon
License: Unlicense
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
17
Weekly Downloads
37
Last Commit
3yrs ago
eqb

@forter/elasticsearch-query-builder

ElasticSearch Query Builder

License Icon
License: Apache-2.0
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
N/A
Weekly Downloads
17
Last Commit
N/A
eo

elasticsearch-odm

Like Mongoose but for Elasticsearch. Define models, preform CRUD operations, and build advanced search queries.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
74
Weekly Downloads
13
Last Commit
5yrs ago
ksb

knex-schema-builder

A schema builder module for knex.js, handles schema initialization and migration

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
47
Weekly Downloads
3
Last Commit
8mos ago
eo5

elasticsearch-odm-5

Like Mongoose but for Elasticsearch. Define models, preform CRUD operations, and build advanced search queries.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
8
Weekly Downloads
4
Last Commit
3yrs ago
mod

modelar

An expressive ORM with query builder and supports multiple kinds of database.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: Built-In
User RatingN/A
Top Feedback
N/A
GitHub Stars
53
Weekly Downloads
3
Last Commit
3yrs ago
aqb

active-query-builder

🐸 Simple and flexible way to write your next MySQL queries.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
2
Weekly Downloads
3
Last Commit
3yrs ago
str

strongman

a node module for composing elasticsearch queries

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
N/A
Weekly Downloads
2
Last Commit
5yrs ago
sm

sql-mysql

Complex queries can be written with normal SQL, including the values needs to be bound and prefixed with the `sql` tag.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
N/A
Weekly Downloads
2
Last Commit
3yrs ago
flu

fluorite

Lightweight ORM based on Knex.js query builder.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
6
Weekly Downloads
2
Last Commit
4yrs ago
nq

node-qsb

Node.js Database Query String Builder (QSB) for Mysql/MariaDB

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
2
Weekly Downloads
2
Last Commit
5yrs ago
jmq

js-mysql-querybuilder

Node QueryBuilder Adapter for Node.js (tags: nodejs, node, mysql, active record, activerecord, querybuilder, query builder)

License Icon
License: Unknown
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
N/A
Weekly Downloads
2
Last Commit
4yrs ago
equ

equery

Query builder for elasticsearch (Node.js / Javascript)

License Icon
License: Apache-2.0
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
12
Weekly Downloads
2
Last Commit
6yrs ago
eo2

elasticsearch-odm-2

Like Mongoose but for Elasticsearch. Define models, preform CRUD operations, and build advanced search queries.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
8
Weekly Downloads
2
Last Commit
3yrs ago

solr-query-io-ts

(Unofficial) query builder for Solr Standard Query parser

License Icon
License: Apache-2.0
TypeScript Icon
TypeScript Definitions: Built-In
User RatingN/A
Top Feedback
N/A
GitHub Stars
4
Weekly Downloads
0
Last Commit
2yrs ago

sqorn-pg

A Javascript library for building SQL queries

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
2K
Weekly Downloads
1
Last Commit
3yrs ago
sqb

sql-query-builder

Define models and associations and let QB write your SQL.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
4
Weekly Downloads
0
Last Commit
7yrs ago
cqh

couchdb-query-helper

A module to help query couch DB in node applications

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
1
Weekly Downloads
0
Last Commit
2yrs ago
sb

sequel-builder

Ported query library from php yii2 to nodejs. currently only supporting mysql.

License Icon
License: ISC
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
N/A
Weekly Downloads
1
Last Commit
N/A
oe

owc-elasticsearch

An ORM of elasticsearch indexes with built in query body builder to allow you manipulate data in elasticsearch like a relational db.

License Icon
License: MIT
TypeScript Icon
TypeScript Definitions: DefinitelyTyped
User RatingN/A
Top Feedback
N/A
GitHub Stars
N/A
Weekly Downloads
0
Last Commit
2yrs ago