UQL
The best ORM for TypeScript and modern JavaScript. Fast, safe, and easy.
npm install uql-ormWhy UQL?
Section titled “Why UQL?”| Feature | UQL | Others |
|---|---|---|
| Syntax | Serializable JSON: Pure data, perfect for APIs/Websockets. | Method-Chaining: Hard to transport over the wire. |
| Simplicity | Pure TypeScript: No codegen, no custom DSL, no build-step friction. | High: Requires codegen, proprietary DSLs, or extra build steps. |
| API | Unified & Intuitive: Same syntax for SQL & NoSQL. | Fragmented: SQL and Mongo feel like different worlds. |
| Intelligence | Deep Auto-Completion: IDE-powered inference for relations & operators at any depth. | Surface-level: Often loses types in complex joins. |
| Efficiency | Sticky Connections: Measured at 3.9M+ ops/s. | Heavy: Often generates “SQL Soup” that’s hard to debug. |
See also: Full 2026 comparison → · In Search of the Fastest TypeScript ORM → · Benchmark Repo (GitHub) →
Who is UQL for?
Section titled “Who is UQL for?”UQL shines when you need modern TypeScript ergonomics with hard performance guarantees:
- AI & RAG applications: Native vector search, distance projection, and JSON‑native queries make it easy to build semantic search and retrieval‑augmented generation pipelines.
- Multi-tenant SaaS & platforms: Unified schema and query model across PostgreSQL, MySQL/MariaDB, SQLite, LibSQL, Neon, D1, MongoDB, and Bun Native SQL with entity‑first migrations.
- High-concurrency APIs: Zero‑allocation query engine, sticky connections, and first‑class streaming support keep latency and resource usage predictable.
If you want Prisma‑level ergonomics with query‑builder performance, UQL is designed for you.
Explore the Documentation
Section titled “Explore the Documentation”🚀 The Fast Path
Section titled “🚀 The Fast Path”- Quick Start — Go from zero to your first UQL query in under 3 minutes.
- Switching to UQL — Migration guide for Prisma, Drizzle, and TypeORM users.
📚 Deep Dives
Section titled “📚 Deep Dives”- Core Concepts — Entities, relations, type abstractions, and lifecycle hooks.
- Querying & Transactions — Deep selection, filtering, sorting, and JSON operators.
- AI & Semantic Search — Add vector similarity and RAG‑style workflows.
- Migrations & Ops — Entity-first migrations and drift detection.
🛠️ Ecosystem
Section titled “🛠️ Ecosystem”- Extensions & Fullstack — Auto-generated REST APIs and type-safe browser queries.
🤍 Open-source · Production-trusted by Variability.ai — AI meeting and video intelligence platform.