Build type-safe SQL queries for TypeScript applications with Kysely generics.
npx skills add https://github.com/Hollowvyn/cognipace-v2 --skill kysely-hollowvyn
Please help me install this Agent Skill. Skill: kysely Source: https://github.com/Hollowvyn/cognipace-v2/tree/main/.agents/skills/kysely Command: npx skills add https://github.com/Hollowvyn/cognipace-v2 --skill kysely-hollowvyn
Kysely eliminates the tedium and risk of writing database code without reliable TypeScript guarantees by keeping query inputs and results strongly typed end-to-end, from your schema to executed SQL.
Use it when you’re building a production-grade data layer in TypeScript, especially for complex querying and schema evolution where you want SQL control without ORM overhead (e.g., migrating an existing codebase, implementing advanced reporting queries, or adding transactional writes).
Use the kysely skill to generate a type-safe SELECT and INSERT flow for your database by defining your Database interface, creating a Kysely instance with the correct dialect/driver, and writing queries with execute to obtain correctly typed results.
High-intent search queries and answers about installing and using this skill.
Type-safe SQL queries in TypeScript are built by mapping schema-defined table types to compile-time checked query results using a query builder, preventing common type mismatches from schema to executed SQL without ORM overhead.
Managing SQL migrations and transactions in a TypeScript backend is handled through reversible up/down migrations for schema evolution and wrapping multi-step operations in typed transactions to ensure data integrity.
Raw SQL for complex constructs like CTEs and window functions is supported through typed raw SQL via sql template tags, allowing targeted raw SQL execution while maintaining end-to-end static type requirements.
Type inference for SQL query results works by inferring the return shape directly from your table definitions and selected fields, ensuring that CRUD operations, joins, and aggregations return strongly typed data end-to-end.
This type-safe query builder approach works for local-first apps and backend services by supporting dialect-specific execution across common SQL databases, applying typed generics to satisfy static type requirements.
tejovanthnValidate and infer TypeScript runtime data with Zod schemas.
timequityOptimize data warehouse queries and storage across Snowflake, BigQuery, and Redshift.
bughqConstruct type-safe SQL queries with a fluent API for Stacks applications.
dotlab-hqDefine TypeScript database schemas, write type-safe queries, and manage migrations.
