Implements type-safe SQL queries, schemas, and migrations with Drizzle ORM for TypeScript.
npx skills add https://github.com/Ishaq74/atomic --skill drizzle-orm-ishaq74
Please help me install this Agent Skill. Skill: drizzle-orm Source: https://github.com/Ishaq74/atomic/tree/main/.github/skills/drizzle Command: npx skills add https://github.com/Ishaq74/atomic --skill drizzle-orm-ishaq74
$inferSelect and $inferInsert. - Query & Relation Patterns: Build filters, joins, aggregations, CTEs, subqueries, and one-to-many or many-to-many relations with SQL-like syntax. - Migrations & Performance: Generate and apply SQL migrations with Drizzle Kit, configure connection pooling, cursor-based pagination, caching, and edge runtime integration. - Use Case: When building a Next.js or serverless API backed by PostgreSQL, use this Skill to define the schema, write optimized queries with relations, and generate migrations without a heavy ORM runtime. ## Quick Start Ask the AI to define a Drizzle schema for your tables and write a type-safe query with a migration using Drizzle Kit.High-intent search queries and answers about installing and using this skill.
Define tables using pgTable, mysqlTable, or sqliteTable with typed columns like serial, text, and timestamp. Drizzle infers TypeScript types automatically via $inferSelect and $inferInsert, giving compile-time safety without a code generation step.
Drizzle offers a smaller bundle (~35KB vs ~230KB), faster cold starts, and first-class raw SQL support, making it better for edge and serverless deployments. Prisma suits rapid prototyping and teams less comfortable with SQL.
Yes, Drizzle works in edge runtimes through HTTP-based drivers such as neon-http for Vercel Edge and the d1 driver for Cloudflare Workers. These avoid TCP connection pooling by sending each query as an HTTP request.
Configure drizzle.config.ts with your schema path and database credentials, then run drizzle-kit generate to create SQL migration files and drizzle-kit migrate to apply them. You can also introspect an existing database to generate a schema.
Use the relational query API with db.query.table.findMany and the with option to fetch relations in one query. Alternatively, apply the DataLoader pattern to batch foreign-key lookups across multiple parent records.
OFFSET scans all skipped rows, so performance degrades on large datasets. Use cursor-based pagination instead: filter with gt or lt on an indexed id or timestamp column, order by that column, and apply limit.
wichopsProvision and connect PostgreSQL, Redis, MySQL, and MongoDB databases on Railway.
valentinmatheyStandardize GraphQL endpoint construction with thin resolvers delegating to services.
Impertio-StudioTune MariaDB, Redis, Gunicorn, and RQ workers to resolve Frappe/ERPNext performance bottlenecks.
tankpkgStandardize Prisma ORM production patterns for TypeScript applications.