kysely

Construct type-safe SQL queries in TypeScript with PostgreSQL, MySQL, and SQLite support.

Updated Apr 12, 2026
One-click install
npx skills add https://github.com/gil00pita/lanify --skill kysely-gil00pita
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: kysely
Source: https://github.com/gil00pita/lanify/tree/main/.agents/skills/kysely
Command: npx skills add https://github.com/gil00pita/lanify --skill kysely-gil00pita

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Type-safe SQL generation in TypeScript helps catch errors at compile time and improves DX by providing full autocompletion and inference for SQL queries.

Core Features & Use Cases

  • Type-safe SQL queries with full TypeScript inference and autocompletion.
  • Schema migrations and type-safe schema management for reliable deployments.
  • Multi-database support with a lightweight ORM alternative that keeps SQL in your control.

Quick Start

Install kysely, configure a database dialect, and start writing type-safe queries immediately.

Frequently Asked Questions about kysely

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write type-safe SQL queries in TypeScript with full autocompletion?

Type-safe SQL queries in TypeScript provide full inference and autocompletion by defining your database schema types, enabling the query builder to validate columns, tables, and joins at compile time. This prevents runtime SQL errors and improves developer experience.

What is the best way to manage schema migrations for PostgreSQL and MySQL in TypeScript?

Schema migrations for PostgreSQL, MySQL, and SQLite can be managed using programmable migration files. This approach ensures reliable, verifiable database operations by applying type-safe schema definitions during deployment, keeping SQL fully under your control.

Does a lightweight TypeScript query builder work without a heavy ORM?

Yes, a lightweight query builder acts as an ORM alternative that keeps SQL in your control without heavy abstractions. It connects to PostgreSQL, MySQL, and SQLite via configurable dialects, providing type-safe schema management without overhead.

How do I set up multi-database connectivity for a TypeScript SQL query builder?

Multi-database connectivity is configured by installing the query builder, selecting and configuring a specific database dialect for PostgreSQL, MySQL, or SQLite, and then immediately writing type-safe queries inferred from your schema definitions.

Why should I use type-safe schema definitions for database operations?

Type-safe schema definitions catch database errors at compile time rather than runtime. By enforcing strict TypeScript inference across your SQL queries and migrations, they ensure reliable deployments and provide immediate autocompletion feedback during development.