Meta tags:
description=Kysely is the most powerful type-safe SQL query builder for TypeScript. Get unparalleled autocompletion and compile-time type safety for complex queries, joins, and subqueries. Used in production by Deno, Maersk, and Cal.com. Modern TypeScript, zero runtime overhead.;

Headings (most frequently used words):

what, with, your, is, for, you, sql, kysely, show, this, to, boss, the, internet, saying, try, it, out, yourself, looking, code, examples, type, safety, without, compromises, see, get, write, great, auto, completion, build, queries, unmatched, depth, query, any, database, run, anywhere, take, control, over, migrations, extend, plugins,

Text of the page (most frequently used words):
kysely (50), and (37), the (31), for (21), sql (19), creator (15), with (14), swe (13), you (9), great (9), use (8), queries (8), docs (7), #migrations (7), query (7), more (7), using (7), type (7), that (7), prisma (7), what (7), like (7), api (6), have (6), just (6), database (6), this (6), your (6), github (5), get (5), been (5), are (5), can (5), don (5), drizzle (5), really (5), team (5), types (4), started (4), out (4), but (4), builder (4), not (4), how (4), see (4), tools (4), safe (4), control (4), typescript (4), core (4), deno (4), any (4), examples (3), system (3), right (3), from (3), complex (3), awesome (3), best (3), even (3), orms (3), founder (3), without (3), into (3), now (3), needed (3), love (3), about (3), when (3), schemas (3), migration (3), vercel (3), names (3), run (3), within (3), through (3), other (2), community (2), delete (2), update (2), insert (2), where (2), select (2), plugin (2), dialects (2), getting (2), our (2), code (2), modify (2), view (2), generated (2), saying (2), writing (2), marvin (2), time (2), safety (2), was (2), adding (2), makes (2), much (2), having (2), though (2), good (2), too (2), user (2), postgresql (2), has (2), instead (2), codegen (2), works (2), raw (2), seen (2), prefer (2), orm (2), chat (2), ceo (2), simplicity (2), documenso (2), directly (2), most (2), experience (2), better (2), feels (2), also (2), quite (2), nice (2), here (2), edge (2), pretty (2), sst (2), its (2), codebase (2), cal (2), com (2), make (2), cloudflare (2), looks (2), maersk (2), node (2), wanted (2), say (2), abstraction (2), knex (2), official (2), compilation (2), box (2), write (2), over (2), ships (2), environment (2), including (2), functions (2), lovers (2), teams (2), sponsors, bluesky, discord, cte, transactions, join, generating, runtimes, recipes, playground, introduction, jump, finding, single, record, joins, quickly, looking, left, try, yourself, langtail, jiří, capaj, špác, many, times, already, probably, one, additions, tech, stack, enjoy, since, know, indie, hacker, superior, each, release, gets, mutano, alisson, thelinuxlich, agiani, amazing, river, gamma, sam, cook, went, because, did, waste, might, technical, capability, pull, off, however, sanitization, security, must, hence, fermion, mehul, mohan, shout, extensive, jsdoc, comments, above, methods, easier, figure, way, want, dig, thorium, nova, alex, anderson, happy, work, serverless, stripe, alberto, gimenete, gimeno, postgres, old, school, colyseus, endel, dreyer, currently, found, perfect, balance, imo, nango, algolia, samuel, bodin, testing, atlas, gazella, cto, nhost, johan, eliasson, seeing, lot, discussions, strongly, typed, builders, sweet, spot, total, freedom, decades, string, seasoned, partner, guga, guichard, btw, create, app, author, shoubhit, nexxel, dash, actually, sqs, consumer, maintainer, bbc, nicholas, griffin, dope, frontrunners, new, understand, needs, atm, uploadthing, theo, t3dotgg, browne, big, fan, import, everything, declaring, overall, lucia, pilcrow, fantastic, catalin, pit, lucid, would, recommend, everyone, presents, itself, delivers, 100, promise, adonisjs, harminder, virk, today, persistence, machinen, redwooksdk, durable, object, integration, uses, under, hood, typesafety, provided, redwoodjs, snaplet, peter, pistorius, think, they, similar, goals, dedicated, marketing, every, possible, kinda, care, part, than, auth, bereket, engida, querying, younger, warp, astro, ben, holmes, used, prod, highly, recommended, react, native, mathieu, acthernoene, provide, fine, grained, which, why, favorite, fnm, gal, schlezinger, excited, attention, banging, drum, while, integrated, deeply, incidentally, remains, ever, worth, poking, around, opencode, dax, thdxr, raad, some, sean, brydon, utterly, astounded, manages, all, typesafe, seems, matter, infer, correctly, trpc, julius, marminge, thank, tsup, chatwise, kevin, egoist, will, hono, devrel, yusuke, yusukebe, wada, søren, bramer, schmidt, neat, preact, hagemeister, made, strong, recommendation, internally, greenfield, service, very, solid, principal, guðmundur, bjarni, olafsson, planetscale, cursor, lee, leerob, robinson, production, inventory, niels, sandholt, busch, few, days, going, well, kudos, orta, therox, first, project, close, wish, affordances, modern, years, ago, were, stuck, es5, promises, weren, language, construct, yet, cypress, staff, eng, tim, griesser, developers, loving, power, internet, allows, tap, process, before, their, results, after, execution, opens, various, cases, such, transforming, camelcase, snake_case, vice, versa, extend, plugins, includes, optional, down, primitives, allowing, move, away, risky, black, own, ctl, terminal, pipeline, take, lightweight, both, commonjs, esm, zero, dependencies, avoids, specific, apis, javascript, bun, aws, lambda, workers, browsers, anywhere, driven, dialect, easy, implement, support, waiting, mysql, server, sqlite, pglite, supports, building, wide, range, clauses, expressions, merge, strings, structured, build, unmatched, depth, schema, flow, fluent, offering, typing, second, only, full, blown, ides, intelligent, context, aware, suggestions, table, column, auto, completion, thin, layer, crafted, focusing, familiarity, naming, structure, predictability, proficient, pick, productive, minutes, state, art, provides, precise, result, catches, errors, compile, giving, high, performing, confidence, ship, greater, velocity, source, compromises, show, boss, search, skip, main, content,

Text of the page (random words):
kysely skip to main content kysely docs github api docs search kysely the type safe sql query builder for typescript getting started view on github show this to your boss type safety without compromises kysely s state of the art type safe api provides precise result types and catches errors within queries at compile time giving high performing teams the confidence to ship at greater velocity use kysely codegen to make the database the source of types what you see is what you get kysely is a thin abstraction layer over sql crafted by sql lovers for sql lovers focusing on familiarity through naming and structure and predictability through 1 1 compilation teams proficient in sql can pick up kysely and be productive in minutes write with great auto completion your database schema types flow through kysely s fluent api offering a typing experience that s second only to full blown database ides get intelligent context aware suggestions for functions table names and column names as you type build sql queries with unmatched depth kysely supports building a wide range of sql queries clauses functions and expressions including select insert update delete merge with and more when needed you can also use raw sql strings even within structured queries query any sql database kysely s community driven dialect system makes it easy to implement support for any sql database without waiting for the core team it ships with official dialects for postgresql mysql ms sql server sqlite and pglite right out of the box run anywhere kysely is lightweight ships both commonjs and esm has zero dependencies and avoids any environment specific apis it can run in any javascript environment including node js deno bun aws lambda cloudflare workers and browsers take control over your migrations kysely includes optional up down migration primitives allowing you to move away from risky black box migration tools and write your own migrations use kysely ctl to run your migrations directly in the terminal or within your ci cd pipeline extend with plugins kysely s plugin system allows you tap into the process and modify queries before compilation and or their results after execution this opens up various use cases such as transforming camelcase names to snake_case and vice versa what the internet is saying developers are loving kysely for its simplicity and power tim griesser knex js creator cypress staff eng first just wanted to say this project looks awesome pretty close to what i wish knex was if i started it now with the affordances of modern typescript instead of 10 years ago when we were stuck in es5 and promises weren t even really an official language construct yet orta therox ex typescript team been using kysely for a few days in deno and node just wanted to say it s been going really well and it feels like a nice abstraction kudos niels sandholt busch maersk swe we are using kysely in production at maersk inventory control lee leerob robinson cursor vp dx ex vercel type safe sql queries with planetscale and kysely guðmundur bjarni olafsson vercel principal swe ex github i made a strong recommendation internally for using kysely for a greenfield service that s in the works looks very solid marvin hagemeister preact core team deno swe we re using kysely as an orm here at deno it s quite neat søren bramer schmidt prisma ceo kysely is great yusuke yusukebe wada hono creator cloudflare devrel kysely is great d1 will be great this is great kevin egoist tsup creator chatwise founder thank you kysely julius marminge trpc core team t3 chat swe utterly astounded by how kysely manages to make all of this typesafe seems like no matter how complex you get it can infer it correctly sean brydon cal com swe we are using kysely for some of our more complex queries in cal com where we needed more control of the sql generated dax thdxr raad sst opencode core team really excited to see kysely get more attention been banging this drum for a while and we ve integrated pretty deeply with it at sst incidentally its codebase remains the best typescript codebase i have ever seen worth poking around gal schlezinger fnm creator vercel swe i love sql and i love migrations most tools don t provide good migration tools and fine grained control like kysely which is why it s my favorite mathieu acthernoene react native edge to edge creator used in prod here highly recommended ben holmes warp swe ex astro i really like prisma for schemas and kysely for querying drizzle feels younger for schemas but also quite nice bereket engida better auth creator i don t think they have similar goals from what i see drizzle is more dedicated into marketing and having every user possible like prisma but kysely kinda just don t care about that for most part and in my experience prisma kysely is better than drizzle peter pistorius redwoodjs creator ex snaplet today i ll be adding persistence to machinen using redwooksdk s durable object database integration it uses kysely under the hood typesafety is directly provided by migrations harminder virk adonisjs creator if not lucid kysely is what i would recommend everyone use it presents itself as a type safe sql query builder and delivers 100 on that promise catalin pit documenso swe kysely is fantastic we use it at documenso with prisma pilcrow lucia creator ok so i m not a big fan of drizzle i don t like how i have to import everything when declaring schemas and queries and i just prefer the simplicity and the overall api of kysely theo t3dotgg browne uploadthing creator t3 chat ceo kysely is dope too drizzle and kysely are the frontrunners for new db tools that really understand js needs atm nicholas griffin sqs consumer maintainer bbc swe i don t actually like prisma that much i prefer kysely not an orm though shoubhit nexxel dash create t3 app author kysely is great btw guga guichard string ts creator seasoned partner i ve been seeing a lot of discussions about orms vs raw sql what about strongly typed sql query builders kysely is in the sweet spot best dx with total freedom i ve seen in decades johan eliasson gazella cto nhost founder instead of prisma i m testing kysely kysely codegen and atlas works great samuel bodin nango swe ex algolia im currently in love with kysely it has found the perfect balance api imo endel dreyer colyseus creator i just use postgres kysely and old school migrations as needed alberto gimenete gimeno stripe swe ex github i m a happy kysely user it s great to see that the code i m writing now can work with serverless postgresql now r alex anderson thorium nova creator shout out to kysely for adding extensive jsdoc comments above the methods it makes it much easier to figure out how to use it the way i want without having to dig into the docs though the docs are vv good too mehul mohan fermion founder we went with query builder because we did not have more time to waste on orms orms might be great but we have the technical capability to pull off just using a query builder however we type safety and sanitization for dx and security was a must hence kysely sam cook river creator gamma io swe kysely is amazing alisson thelinuxlich c agiani mutano creator kysely is superior and with each release gets even more awesome marvin indie hacker i ve been saying it many times already but it s probably one of the best additions to my tech stack i enjoy writing sql since i know kysely jiří capaj špác langtail swe kysely is awesome try it out for yourself modify the query on the left and view the generated sql on the right looking for code examples from finding a single record to complex joins our docs have examples to get you started quickly jump right in docs introduction getting started playground migrations recipes other runtimes dialects generating types plugin system examples select where join insert update delete transactions cte community discord bluesky other github api docs sponsors