https://kysely.dev/llms.txt

# Kysely > The most powerful type-safe SQL query builder for TypeScript - [Kysely](https://kysely.dev/index.md) ## docs ### category #### comparisons Compare SQL query builders, ORMs, SQL embedded in TypeScript, and typed SQL files, and explore the tradeoffs between libraries. - [Comparisons](https://kysely.dev/docs/category/comparisons.md): Compare SQL query builders, ORMs, SQL embedded in TypeScript, and typed SQL files, and explore the tradeoffs between libraries. #### cte Short and simple examples of how to use Common Table Expressions (CTE) in queries. - [CTE](https://kysely.dev/docs/category/cte.md): Short and simple examples of how to use Common Table Expressions (CTE) in queries. #### delete Short and simple examples of how to write DELETE queries. - [DELETE](https://kysely.dev/docs/category/delete.md): Short and simple examples of how to write DELETE queries. #### examples Short and simple examples of how to use Kysely to achieve common tasks. - [Examples](https://kysely.dev/docs/category/examples.md): Short and simple examples of how to use Kysely to achieve common tasks. #### insert Short and simple examples of how to write INSERT queries. - [INSERT](https://kysely.dev/docs/category/insert.md): Short and simple examples of how to write INSERT queries. #### integrations Kysely integrations with other libraries, ORMs, and AI assistants. - [Integrations](https://kysely.dev/docs/category/integrations.md): Kysely integrations with other libraries, ORMs, and AI assistants. #### join Examples of queries that use JOINs. - [JOIN](https://kysely.dev/docs/category/join.md): Examples of queries that use JOINs. #### merge Short and simple examples of how to write MERGE queries. - [MERGE](https://kysely.dev/docs/category/merge.md): Short and simple examples of how to write MERGE queries. #### other-runtimes Use Kysely in browsers to build type-safe queries and compile SQL without a database connection. - [Other runtimes](https://kysely.dev/docs/category/other-runtimes.md): Use Kysely in browsers to build type-safe queries and compile SQL without a database connection. #### recipes Explore Kysely recipes for reusable helpers, expressions, nested relations, database schemas, logging, and advanced TypeScript types. - [Recipes](https://kysely.dev/docs/category/recipes.md): Explore Kysely recipes for reusable helpers, expressions, nested relations, database schemas, logging, and advanced TypeScript types. #### select Short and simple examples of using the SELECT methods. - [SELECT](https://kysely.dev/docs/category/select.md): Short and simple examples of using the SELECT methods. #### transactions Short and simple examples of how to use transactions. - [Transactions](https://kysely.dev/docs/category/transactions.md): Short and simple examples of how to use transactions. #### update Short and simple examples of how to write UPDATE queries. - [UPDATE](https://kysely.dev/docs/category/update.md): Short and simple examples of how to write UPDATE queries. #### where Short and simple examples of how to use the where method to add a WHERE statement. While most of the examples show a SELECT query, the where method works exactly the same in UPDATE and DELETE queries too. - [WHERE](https://kysely.dev/docs/category/where.md): Short and simple examples of how to use the where method to add a WHERE statement. While most of the examples show a SELECT query, the where method works exactly the same in UPDATE and DELETE queries too. ### comparisons #### kysely-vs-drizzle Kysely vs Drizzle ORM for TypeScript: compile-time reference checks, typed JSON and CASE, safe query reuse, and migrating from Drizzle one query at a time. - [Kysely vs Drizzle ORM](https://kysely.dev/docs/comparisons/kysely-vs-drizzle.md): Kysely vs Drizzle ORM for TypeScript: compile-time reference checks, typed JSON and CASE, safe query reuse, and migrating from Drizzle one query at a time. #### kysely-vs-knex Compare Kysely and Knex SQL query builders: TypeScript inference through joins, aliases, and nested results, immutable query reuse, explicit execution, dialect-specific SQL, plugins, and a gradual migration plan. - [Kysely vs Knex](https://kysely.dev/docs/comparisons/kysely-vs-knex.md): Compare Kysely and Knex SQL query builders: TypeScript inference through joins, aliases, and nested results, immutable query reuse, explicit execution, dialect-specific SQL, plugins, and a gradual migration plan. #### kysely-vs-sequelize Kysely vs Sequelize: a Sequelize alternative that type-checks query references, infers result types from the selection, and migrates one query at a time. - [Kysely vs Sequelize](https://kysely.dev/docs/comparisons/kysely-vs-sequelize.md): Kysely vs Sequelize: a Sequelize alternative that type-checks query references, infers result types from the selection, and migrates one query at a time. #### kysely-vs-typeorm Kysely vs TypeORM: a TypeORM alternative that type-checks query references, infers result types from the selection, and migrates one query at a time. - [Kysely vs TypeORM](https://kysely.dev/docs/comparisons/kysely-vs-typeorm.md): Kysely vs TypeORM: a TypeORM alternative that type-checks query references, infers result types from the selection, and migrates one query at a time. #### query-builder-vs-orm Compare SQL query builders and ORMs with TypeScript examples. Learn how Kysely composes typed SQL and when to choose it over a model-based API. - [SQL query builder vs ORM in TypeScript](https://kysely.dev/docs/comparisons/query-builder-vs-orm.md): Compare SQL query builders and ORMs with TypeScript examples. Learn how Kysely composes typed SQL and when to choose it over a model-based API. #### query-builder-vs-raw-sql Compare Kysely with raw SQL in TypeScript: SQL templates, SafeQL, and typed SQL files from PgTyped, Prisma TypedSQL, and sqlc. When a query builder earns its place. - [SQL query builder vs raw SQL in TypeScript](https://kysely.dev/docs/comparisons/query-builder-vs-raw-sql.md): Compare Kysely with ra