Define TypeScript database schemas, write type-safe queries, and manage migrations.
npx skills add https://github.com/dotlab-hq/medisync --skill drizzle-orm-dotlab-hq
Please help me install this Agent Skill. Skill: drizzle-orm Source: https://github.com/dotlab-hq/medisync/tree/main/.agents/skills/drizzle-orm Command: npx skills add https://github.com/dotlab-hq/medisync --skill drizzle-orm-dotlab-hq
This Skill simplifies database interactions in TypeScript applications by providing a type-safe way to define schemas, write queries, and manage migrations, eliminating runtime errors and improving developer productivity.
user_preferences table in Drizzle's schema, write type-safe insert and select queries, and generate the corresponding SQL migration to apply to your database.Use the drizzle-orm skill to define a new 'users' table with 'id', 'email', and 'name' columns.
High-intent search queries and answers about installing and using this skill.
Type-safe schema definition involves declaring database tables and columns directly in TypeScript, ensuring compile-time consistency between your code and database to eliminate runtime type errors.
This ORM supports PostgreSQL, MySQL, and SQLite databases, enabling you to build type-safe data layers with compile-time safety and zero runtime overhead across these platforms.
You generate and apply database schema migrations using Drizzle Kit, which automates creating and executing SQL migrations to update your database structure after schema changes.
Writing type-safe SQL queries is best done using a TypeScript ORM that provides SQL-like query building with full type checking, supporting complex operations like joins, subqueries, and transactions.
This type-safe ORM operates with zero runtime overhead, providing compile-time safety during development without adding performance costs to your TypeScript application at runtime.
You should use a TypeScript ORM when you need type-safe schema definitions, automated migrations, and query autocompletion to improve productivity and eliminate runtime errors in your data layer.
FindMalekConfigure Prisma for multiple database providers and set up the client.
thechandanbhagatWrite and optimize SQL queries for relational databases.
devturcoStandardize TypeScript database schemas, relations, and drizzle-kit migrations for PostgreSQL.
sckrollDefine TypeScript database schemas and queries for PostgreSQL, MySQL, and SQLite.