kysely

Implement type-safe SQL queries for PostgreSQL, MySQL, and SQLite with Kysely.

4|Updated Jan 15, 2026

Search Tags:#type safety #typescript #database #migrations #sql #orm #kysely

Ready to run

npx skills add https://github.com/mgd34msu/goodvibes-gemini --skill kysely-mgd34msu

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: kysely
Source: https://github.com/mgd34msu/goodvibes-gemini/tree/main/skills/kysely
Command: npx skills add https://github.com/mgd34msu/goodvibes-gemini --skill kysely-mgd34msu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a robust solution for writing type-safe SQL queries in TypeScript, bridging the gap between the flexibility of SQL and the safety of static typing.

Core Features & Use Cases

Type Safety: Ensures your SQL queries are type-checked at compile time, preventing runtime errors.
IntelliSense & Autocompletion: Offers full autocompletion for tables, columns, and functions.
Database Support: Works with PostgreSQL, MySQL, and SQLite.
Migrations & Seeding: Includes tools for managing database schema changes and populating data.
Use Case: When developing a new feature that requires complex data retrieval and manipulation from a database, use this Skill to write all your SQL queries with full TypeScript inference, ensuring data integrity and reducing debugging time.

Quick Start

Use the kysely skill to set up a new Kysely client for PostgreSQL with your database URL.

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?▼

Type-safe SQL queries in TypeScript are built using a query builder that enforces compile-time type checking for database tables and columns, preventing runtime errors and providing autocompletion during development.

Does this approach work with PostgreSQL, MySQL, and SQLite?▼

Yes, this type-safe query building approach works with PostgreSQL, MySQL, and SQLite, allowing you to maintain consistent compile-time type checking and IntelliSense across different relational database systems.

How do I set up a Kysely client for a PostgreSQL database?▼

To set up a Kysely client for PostgreSQL, you initialize the client by passing your database connection URL and configuration, which automatically enables type inference for your specific database schema.

Can I manage database migrations and seeding with type-safe SQL?▼

Yes, you can manage database migrations and seeding with type-safe SQL using included utilities, allowing you to handle schema changes and populate data while maintaining strict TypeScript type integrity.

What is the best way to prevent runtime errors in TypeScript database interactions?▼

The best way to prevent runtime errors in TypeScript database interactions is by using a compile-time type checking query builder that validates table and column references against your schema before execution.