Create typed SQL queries for PostgreSQL with @effect/sql and SqlSchema.
npx skills add https://github.com/lucas-barake/dotai --skill effect-sql
Please help me install this Agent Skill. Skill: effect-sql Source: https://github.com/lucas-barake/dotai/tree/main/canonical/skills/effect-sql Command: npx skills add https://github.com/lucas-barake/dotai --skill effect-sql
Enable safe, typed SQL queries for relational data in TypeScript applications using @effect/sql and SqlSchema.
Define a SqlSchema single query to fetch a user by id.
High-intent search queries and answers about installing and using this skill.
Typed SQL queries for PostgreSQL in TypeScript are written using @effect/sql and SqlSchema to enforce runtime validation. This approach supports single-result fetch, optional fetch, multi-row queries, and write operations across repositories and migrations.
Runtime validation of SQL query results in TypeScript is handled using SqlSchema patterns like .single, .findOne, and .findAll. These methods ensure that data returned from PostgreSQL queries matches the expected schema at runtime.
Database transactions with Effect are handled within the data access layer using the PostgreSQL client configuration. The Skill supports advanced features such as transactions, JSON handling, and SQL template helpers for complex write operations across repositories.
Yes, Effect SqlSchema can be used for optional fetch and multi-row queries in PostgreSQL. It provides specific patterns including .findOne for optional single results and .findAll for fetching multiple rows with runtime validation.
Yes, the typed SQL pattern supports JSON handling and SQL template helpers. These advanced features are integrated alongside PostgreSQL client configuration to manage complex data structures within TypeScript applications using @effect/sql.
GDSDNValidate database environment variables, SSL mode, pooler config, and PostgreSQL connectivity.
jnPiyushAutomate PostgreSQL database operations with EF Core migrations, indexing, and transactions.
qazuorStandardize PostgreSQL schema, relations, and queries with Drizzle ORM.
ShaulLavoProvide type-safe SQL ORM queries for TypeScript applications.
