aicoolies logo
Kysely logo

Kysely

Type-safe SQL query builder for TS

Share
open-sourceOpen Source
Visit Website →

Type-safe SQL query builder for TypeScript that provides auto-completion and compile-time type checking without the abstraction overhead of a traditional ORM. Write queries that map directly to SQL while getting full TypeScript inference from your database schema. Supports PostgreSQL, MySQL, and SQLite with migrations, transactions, and raw SQL escape hatches. Lightweight with zero dependencies. Ideal for developers who want SQL control with TypeScript safety. Growing Knex.js alternative.

Kysely is a type-safe TypeScript SQL query builder that provides unparalleled autocompletion and compile-time safety for database queries. Inspired by Knex.js but built from the ground up with TypeScript in mind, Kysely ensures that you can only reference tables and columns that actually exist in your database schema, catching errors before your code ever runs. It runs on Node.js, Deno, Bun, Cloudflare Workers, and web browsers, making it a versatile choice for modern JavaScript runtimes.

Kysely stands out as a thin abstraction layer over SQL, designed by SQL enthusiasts who want predictable one-to-one query compilation rather than magical ORM behavior. It provides smart column inference that restricts field access to only the columns visible in each part of a query, ensuring result types include only selected columns with correct types and aliases. Kysely supports the full range of SQL operations including SELECT, INSERT, UPDATE, DELETE, MERGE, WITH clauses, and complex subqueries, all with complete type safety and autocompletion support.

Kysely is targeted at TypeScript developers and teams proficient in SQL who want the safety of type checking without sacrificing control over their queries. It is used in production by companies like Deno, Maersk, and Cal.com, demonstrating its readiness for enterprise workloads. Kysely integrates with PostgreSQL, MySQL, and SQLite through dialect-specific drivers, and its plugin system allows extending functionality with custom transformations, making it an excellent choice for projects where type safety and SQL familiarity are top priorities.

Pricing

Free

Platforms

Node.js, Deno, Bun

Categories

Tags

Use Cases

Alternatives

Related Tools

VectorChord logo

VectorChord

High-recall Postgres vector search at billion scale

VectorChord is a Postgres extension from the supervc-stack/VectorChord project that brings high-recall vector search to PostgreSQL. As the spiritual successor to pgvecto.rs, it combines IVF indexes with RaBitQ quantization to deliver Pinecone-class performance at billion-vector scale while keeping all data inside a single Postgres database — no separate vector store, no two-system sync, no rewrites when the workload grows.

open-sourceOpen Source
Infinity logo

Infinity

AI-native database for hybrid RAG retrieval

Infinity is an AI-native database from InfiniFlow that unifies dense vectors, sparse vectors, tensors, and full-text search in a single engine. Built for retrieval-augmented generation (RAG) at scale, it powers hybrid search workflows where lexical matching, semantic similarity, and reranking all happen against one storage layer instead of four loosely coupled services.

open-sourceOpen Source
sqlite-vec logo

sqlite-vec

Vector search extension for SQLite that runs anywhere

sqlite-vec is a lightweight vector search extension for SQLite written in pure C with zero dependencies. It brings nearest-neighbor search capabilities directly into SQLite databases, enabling AI applications to store and query embeddings without running a separate vector database. The extension works everywhere SQLite runs including Linux, macOS, Windows, WebAssembly in browsers, and even Raspberry Pi devices. Sponsored by Mozilla Builders, Fly.io, and Turso.

freeOpen Source
WeKnora logo

WeKnora

Enterprise RAG framework by Tencent

WeKnora is a Tencent-developed LLM-powered knowledge management and Q&A framework for enterprise document understanding and semantic retrieval. Supports 10+ document formats including PDF, Word, Excel, and images with seamless IM platform integration for WeCom, Feishu, Slack, and Telegram. Offers Quick Q&A mode using RAG pipelines and Intelligent Reasoning mode with ReACT agents for complex multi-step reasoning tasks across organizational knowledge bases.

open-sourceOpen Source
Pixeltable logo

Pixeltable

Declarative multimodal AI data infrastructure

Pixeltable is a declarative data infrastructure for multimodal AI that stores video, audio, images, and documents as first-class column types. Define Python computed columns for inference and transformations, and Pixeltable auto-orchestrates execution with incremental updates. Built-in vector search eliminates the need for separate vector databases while supporting RAG and semantic search workflows.

open-sourceOpen Source
USearch logo

USearch

Fast embeddable vector search engine

USearch is a high-performance vector search engine implementing HNSW algorithms for approximate nearest neighbor queries across C++, Python, JavaScript, Rust, Java, Go, and more. It supports user-defined distance metrics, memory-mapped persistence for datasets larger than RAM, and filtered search with predicates. Used by YugabyteDB and ScyllaDB as their production vector indexing backend.

open-sourceOpen Source