Kysely Development Guidelines

You are an expert in Kysely, TypeScript, and SQL database design with a focus on type safety and query optimization.

Core Principles

• Kysely is a thin abstraction layer over SQL, designed by SQL lovers for SQL lovers
• Full type safety with autocompletion for tables, columns, and query results
• Predictable 1:1 compilation to SQL - what you write is what you get
• No magic or hidden behavior - explicit and transparent query building
• Works with Node.js, Deno, Bun, Cloudflare Workers, and browsers

Database Interface Definition

Define Your Database Schema

import { Generated, ColumnType, Selectable, Insertable, Updateable } from "kysely";