Owner

knex

4 indexed repositories · View on GitHub

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

JavaScript · 20345 stars
documentation
Knex Documentation Builder (Moved to https://github.com/knex/knex)

Vue · 399 stars
knex-schema-inspector
Utility for extracting information about existing DB schema

TypeScript · 109 stars
casbin-knex-adapter
Knex adapter for Casbin

TypeScript · 17 stars

Beginner friendly Everything

Open All

Allow `readonly string[]` for `withRecursive` column names Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

knex/knex#6528 · Opened Sep 3, 2026
Expose QueryBuilder and Raw classes from the main entry point (deep import into knex/lib/* has no types) Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

knex/knex#6524 · 1 comment · Opened Aug 30, 2026
PG: toPathForJson complex path Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

knex/knex#6522 · Opened Aug 27, 2026
v3.3.0 (oracledb): "DPI-1011: connection was not acquired from a session pool" on destroyRawConnection Open

Difficulty 2/5 1-3 hours Newbie friendliness 70/100

knex/knex#6519 · Opened Aug 25, 2026
How to use `LifecycleHook` in practice Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

knex/knex#6518 · 1 comment · Opened Aug 23, 2026
QOL Feat: Infer types from typed raw in keyed select Open

Difficulty 3/5 1-2 days Newbie friendliness 58/100

knex/knex#6513 · Opened Aug 11, 2026
[Security] SQL Injection via JSON default values in formatDefault() (CWE-89) Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

knex/knex#6509 · Opened Jul 31, 2026
onConflict().merge() without column args emits invalid SQL — columns===true guard missing in _merge() Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

knex/knex#6504 · Opened Jul 22, 2026
Could not resolve "mariadb/callback" Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

knex/knex#6498 · 1 reaction · Opened Jul 2, 2026
sqlite3: spurious `connection.filename` warning when `connection` is a function Open

Difficulty 2/5 1-3 hours Newbie friendliness 76/100

knex/knex#6495 · Opened Jun 29, 2026
Proposal: commit a lockfile and use npm ci for reliable CI Open

knex/knex#6469 · 1 assignee · Opened Jun 11, 2026
Feature request: dropIndexIfExists schema builder method Open

Difficulty 4/5 3-5 days Newbie friendliness 58/100

knex/knex#6467 · Opened Jun 10, 2026
Enable creating gist_trgm_ops indexes Open

Difficulty 3/5 1-2 days Newbie friendliness 62/100

knex/knex#6459 · 1 comment · Opened May 31, 2026
Type mismatch in transaction callback when manually calling trx.commit(value) Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

knex/knex#6435 · Opened Apr 26, 2026
[Security] SQL injection in MSSQL and Oracle DDL operations Open

knex/knex#6432 · 1 assignee · Opened Apr 10, 2026
idea: migration-aware backward compatible flags or aliases Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

knex/knex#6425 · 1 reaction · Opened Apr 1, 2026
Ability to create a schema "dump" Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

knex/knex#6424 · 1 comment · 2 reactions · Opened Apr 1, 2026
Meta: 4.0 Release Ideas Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

knex/knex#6409 · 5 comments · 6 reactions · Opened Mar 25, 2026
`TracingChannel` Proposal for observability Open

NG_feature_request

Difficulty 5/5 Over a week Newbie friendliness 38/100

knex/knex#6394 · 1 comment · 2 reactions · Opened Mar 17, 2026
Switch docs deployment to GitHub Pages official actions Open

NG_bug NG_documentation

Difficulty 3/5 1-2 days Newbie friendliness 48/100

knex/knex#6367 · Opened Jan 23, 2026
Website documentation has unpublished features Open

NG_bug NG_documentation

knex/knex#6366 · 2 comments · 1 assignee · Opened Jan 23, 2026
Fix escaped placeholder parsing in raw SQL bindings across dialects (\\?, \\:name, etc) Open

NG_bug

knex/knex#6363 · 2 comments · 1 assignee · Opened Jan 20, 2026
Proposal: ecosystem.md criteria Open

knex/knex#6361 · 3 comments · 1 reaction · 1 assignee · Opened Jan 17, 2026
Table builder index "predicate" option doesn't capture bindings (for postgres?) Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

knex/knex#6354 · Opened Dec 31, 2025
`whereJsonPath` throws on Redshift (`statement.path` is undefined) Open

NG_bug

knex/knex#6351 · 1 assignee · Opened Dec 27, 2025
Fix every inconsistency between docs, database support and knex support of Query Building features (report) Open

knex/knex#6348 · 1 assignee · Opened Dec 26, 2025
Fix every inconsistency between docs, database support and knex support of Schema Building features (report) Open

knex/knex#6347 · 1 assignee · Opened Dec 26, 2025
Major modernisation of codebase Open

NG_feature_request

knex/knex#6338 · 5 reactions · 1 assignee · Opened Dec 22, 2025
Better error for unsupported lock modes Open

NG_bug

knex/knex#6337 · 1 comment · 1 assignee · Opened Dec 21, 2025
Make WITH RECURSIVE behaviour more consistent across dialects Open

NG_dialect_alignment NG_feature_request

Difficulty 5/5 Over a week Newbie friendliness 25/100

knex/knex#6335 · Opened Dec 21, 2025
Consider porting some Postgre-only query builder features Open

NG_dialect_alignment NG_feature_request

Difficulty 5/5 Over a week Newbie friendliness 20/100

knex/knex#6334 · Opened Dec 21, 2025
Add gating for doc-specified dialect-specific query builder features Open

NG_bug NG_dialect_alignment

Difficulty 5/5 Over a week Newbie friendliness 38/100

knex/knex#6333 · Opened Dec 21, 2025
Standardise DB-version detection & feature gating across dialects (connection-level, strict/non-strict) Open

NG_dialect_alignment NG_feature_request

Difficulty 5/5 Over a week Newbie friendliness 20/100

knex/knex#6330 · 1 comment · Opened Dec 18, 2025
Allow to skip rechoir/interpret autoload Open

NG_difficulty_easy NG_feature_request

Difficulty 4/5 3-5 days Newbie friendliness 45/100

knex/knex#6329 · 5 comments · Opened Dec 17, 2025
pgnative tests fail Open

NG_documentation NG_feature_request

knex/knex#6325 · 3 comments · 1 assignee · Opened Dec 12, 2025
Get involved! Get on Discord, tackle critical bugs Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

knex/knex#6322 · 2 comments · 4 reactions · Opened Dec 9, 2025
Knex: The grand plan! Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

knex/knex#6321 · 2 comments · 30 reactions · Opened Dec 9, 2025
Support for IS NULL / IS NOT NULL for whereJsonPath operator Open

NG_feature_request

Difficulty 3/5 1-2 days Newbie friendliness 42/100

knex/knex#6312 · 1 comment · Opened Nov 15, 2025
Use jsonb_path_query_first for jsonExtract with singleValue=true on PostgreSql Open

NG_bug

Difficulty 3/5 1-2 days Newbie friendliness 48/100

knex/knex#6308 · 1 comment · Opened Nov 10, 2025
Proposal: feature-driven dialects Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

knex/knex#6306 · 2 comments · Opened Nov 3, 2025
Schema V2: A Parallel, Opt‑In Schema API for Knex Core Open

NG_expert_feedback_needed NG_feature_request

Difficulty 5/5 Over a week Newbie friendliness 25/100

knex/knex#6305 · 10 comments · 1 reaction · Opened Oct 30, 2025
Cloudflare Hyperdrive Hono Postgres - this.driver.Client is not a constructor (with fix) Open

NG_documentation

Difficulty 4/5 3-5 days Newbie friendliness 35/100

knex/knex#6302 · 4 comments · Opened Oct 28, 2025
Reject pool.propagateCreateError=false and throw a clear startup error Open

NG_feature_request

Difficulty 2/5 1-3 hours Newbie friendliness 52/100

knex/knex#6300 · Opened Oct 28, 2025
Docs: Postgres timestamps don’t auto‑update; add trigger example Open

NG_documentation

Difficulty 2/5 1-3 hours Newbie friendliness 68/100

knex/knex#6297 · Opened Oct 24, 2025
Update vs Insert Behavior Inconsistencies Open

NG_meta

Difficulty 5/5 Over a week Newbie friendliness 25/100

knex/knex#6294 · 2 comments · 2 reactions · Opened Oct 18, 2025
Migration System Meta-Issue Open

NG_meta NG_PRIORITY

Difficulty 5/5 Over a week Newbie friendliness 15/100

knex/knex#6293 · Opened Oct 18, 2025
Proposal: Experimental Pooling Integration Mode (selectable, backwards-compatible) Open

NG_feature_request NG_meta

Difficulty 5/5 Over a week Newbie friendliness 25/100

knex/knex#6292 · 1 reaction · Opened Oct 18, 2025
`toSQL()` method returns incomplete SQL for SQLite3 DDL operations Open

NG_bug

Difficulty 4/5 3-5 days Newbie friendliness 35/100

knex/knex#6291 · 2 comments · Opened Oct 16, 2025
Knex does not transform flat SQL result sets into nested objects Open

NG_documentation

Difficulty 2/5 1-3 hours Newbie friendliness 48/100

knex/knex#6289 · 3 comments · 2 reactions · Opened Oct 14, 2025
Bug: Race condition in acquiring connection after stream error, losing track of used connection Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

knex/knex#6288 · 2 comments · Opened Oct 13, 2025

Showing the newest 100

This page lists what was indexed most recently. Advanced filter has the whole inventory, narrowed by language, difficulty and how long a task takes.

Open advanced filter

knex

Showing the newest 100

Get new issues in your inbox