# kysely

Typesafe SQL for TypeScript.

Source: [Console review](<https://console.dev/tools/kysely>)

Website: [https://github.com/koskimas/kysely](<https://github.com/koskimas/kysely>)

Profile updated: 2026-10-16

Category: [Database management](<https://console.dev/tools/categories/database-management>)

## Supported tech stack

Research checked: 2026-10-11

### Runs on

- Bun (Runtime)
- Deno (Runtime)
- Node.js (Runtime)

### Integrates with

- MySQL (Integration)
- PGlite (Integration)
- PostgreSQL (Integration)
- SQL Server (Integration)
- SQLite (Integration)
- TypeScript (Language)

Source: [Research source](<https://kysely.dev/docs/getting-started?dialect=postgresql>)

Documented compatibility; coverage may be incomplete. Written in describes implementation, not user-project language support.

TypeScript query builder supports Node.js, Bun and Deno, with PostgreSQL, MySQL, SQL Server, SQLite and PGlite dialects.

## Console’s review — 2023-02-09

Reviewed: 2023-02-09

Author: [David Mytton](<https://console.dev/about#david-mytton>)

Citation: [This review](<https://console.dev/tools/kysely#review_c4c29b6ee6c1ab002141e8dce0fb99fb8a4d117b5e1fe183cc6ae1cddfe7897b>)

### What we like

Prevents mistakes by providing types for SQL queries. Understands fields types, joins, subqueries, aliases, and other advanced SQL features. Also supports dialects from databases like Planetscale, D1, AWS, etc. Enables autocomplete in your IDE. Migrations can also be written in TypeScript.

### Tradeoffs

Only works with Postgres, MySQL & SQLite. A third-party project is needed if you want to auto-generate schema definitions.

This review reflects Console’s assessment at publication on 2023-02-09. Features and limitations may have changed since the review date.

## Is kysely a fit?

Based on [Console’s review published on 2023-02-09](<https://console.dev/tools/kysely#review_c4c29b6ee6c1ab002141e8dce0fb99fb8a4d117b5e1fe183cc6ae1cddfe7897b>).

Summary updated: 2026-10-16

### Who it’s for

Developers using TypeScript and specific databases should consider this tool for writing SQL queries

### Why consider it

Prevents mistakes by providing types for SQL queries

### Keep in mind

It has limited database support

[Selection criteria](<https://console.dev/selection-criteria>) · [About Console](<https://console.dev/about>) · [Browse tools](<https://console.dev/tools>)
