Provide type-safe SQL ORM queries for TypeScript applications.
npx skills add https://github.com/ShaulLavo/ellie --skill drizzle-orm-shaullavo
Please help me install this Agent Skill. Skill: drizzle-orm Source: https://github.com/ShaulLavo/ellie/tree/main/.agents/skills/drizzle-orm Command: npx skills add https://github.com/ShaulLavo/ellie --skill drizzle-orm-shaullavo
This Skill simplifies database interactions in TypeScript applications by providing compile-time type safety and a developer-friendly query builder, eliminating runtime errors and boilerplate code.
users table schema and interact with it safely and efficiently.Use the drizzle-orm skill to insert a new user with the email '[email protected]' and name 'Test User' into the 'users' table.
High-intent search queries and answers about installing and using this skill.
Type-safe ORMs validate SQL queries against your defined schema at compile time. This eliminates runtime errors and boilerplate code by catching mismatches during the TypeScript build process.
Yes, this ORM integrates with PostgreSQL, MySQL, and SQLite. It provides a unified query builder and schema definition interface to interact safely across these various SQL databases.
You manage schema migrations using a dedicated migration tool included with the ORM. It facilitates database schema evolution by generating and applying SQL migration files based on your TypeScript schema definitions.
You query relations by defining one-to-one, one-to-many, or many-to-many relationships within your schema. The ORM then allows you to fetch related data safely while maintaining TypeScript type inference.
Yes, the ORM supports complex query patterns including subqueries and Common Table Expressions (CTEs). You can build these advanced SQL structures using a type-safe query builder in TypeScript.
To insert a record, use the ORM query builder to specify the target table and provide the data object. The ORM generates the SQL insert statement while validating the data types against your schema at compile time.
gil00pitaConstruct type-safe SQL queries in TypeScript with PostgreSQL, MySQL, and SQLite support.
jabrenaManage Flyway database migrations in Micronaut applications.
SebdysartAudit tRPC procedures for missing Zod validation and add schemas.
MacPhobosBuild type-safe SQL queries in TypeScript with zero runtime overhead.