Results for “drizzle”

Drizzle ORM (TypeScript ORM, drizzle-orm / drizzle-kit) の API リファレンス。 pgTable / mysqlTable / sqliteTable, `drizzle()`, `$inferSelect` / `$inferInsert`, RQB (Relational Queries) / `db.query`, `defineRelations`, magic `sql` operator, `drizzle-kit generate` / `push`, `drizzle.config.ts`, drizzle-zod, drizzle-seed, Drizzle Studio。SQL Server の低レベルドライバーは別スキル mssql。

The English summary is being prepared. Showing the original description.

Expert knowledge for Drizzle ORM - the lightweight, type-safe SQL ORM for edge and serverlessUse when "drizzle, drizzle orm, drizzle-kit, drizzle schema, drizzle migration, drizzle relations, sql orm typescript, edge database, d1 database, orm, database, typescript, sql, edge, serverless, d1, postgres, mysql, sqlite" mentioned.

The English summary is being prepared. Showing the original description.

Provision a PostgreSQL database with Neon Instagres and save connection settings for application use and migrations. Includes setup examples for Drizzle and Prisma, initial data loading, and claiming a temporary database to keep using it.

• Provision a PostgreSQL database for development
• Configure database access with Drizzle or Prisma
• Load a SQL file with initial data

Generate Drizzle database migrations on a fresh Neon branch and review their production safety. Check table sizes, locking order, execution time, and data transfer needs, with load testing for changes affecting busy or large tables.

• Generate migrations after changing a database schema
• Review locking risks before production deployment
• Rehearse large table changes under load

Zod (TypeScript-first スキーマバリデーションライブラリ) v4 リファレンス。 z.object / z.string / z.number / z.array / z.union / z.enum 等のスキーマ定義、 parse, safeParse, z.infer (型推論)、refine, transform, pipe、 default, optional, nullable、z.compile (AOT)・validate、z.toZod、 エラー処理、Zod 4 移行・Zod Mini (@zod/mini)。 createInsertSchema / createSelectSchema (drizzle-zod、Drizzle テーブルからのスキーマ生成) は別スキル drizzle。

The English summary is being prepared. Showing the original description.

Guide database structure changes in a project using Drizzle and node-pg-migrate. Covers generating and reviewing migration files, checking compatibility during deployment, handling indexes separately, and validating changes before applying them to shared databases.

• Adding or changing database tables and columns
• Creating or removing indexes on existing tables
• Reviewing compatibility during staged schema changes

Build web applications from a bundled Express, Vite, React, Tailwind CSS, and Drizzle ORM template. Follow a schema-first workflow to create pages, backend APIs, and connected forms, with guidance for styling, testing, and deployment.

• Building a dashboard with data displays
• Creating an admin panel with forms and APIs
• Prototyping an online store

Provides comprehensive Drizzle ORM patterns for schema definition, CRUD operations, relations, queries, transactions, and migrations. Proactively use for any Drizzle ORM development including defining database schemas, writing type-safe queries, implementing relations, managing transactions, and setting up migrations with Drizzle Kit. Supports PostgreSQL, MySQL, SQLite, MSSQL, and CockroachDB.

The English summary is being prepared. Showing the original description.

Explore and manage databases with Drizzle Studio. Use when a user asks to browse database contents visually, inspect tables and data, run ad-hoc queries, manage database records through a GUI, debug database issues, or use a lightweight alternative to pgAdmin or DBeaver. Covers setup with Drizzle ORM, standalone usage, data browsing, filtering, and inline editing.

The English summary is being prepared. Showing the original description.

Manage database schema with Drizzle ORM and SQLite migrations. Use when adding tables, modifying columns, creating indexes, or running migrations. Activates for database schema changes, migration generation, and Drizzle query patterns.

The English summary is being prepared. Showing the original description.

Manage database schema with Drizzle ORM and SQLite migrations. Use when adding tables, modifying columns, creating indexes, or running migrations. Activates for database schema changes, migration generation, and Drizzle query patterns.

The English summary is being prepared. Showing the original description.

Plan database schema and data changes for production systems. Use staged column replacements, concurrent index creation, and batched data updates to limit disruption, with migration workflows for PostgreSQL, Prisma, Drizzle, Kysely, Django, and golang-migrate.

• Add columns or indexes to large tables
• Plan a staged column rename without downtime
• Split existing-data updates into batches

Generates complete CRUD modules for NestJS applications with Drizzle ORM. Use when building server-side features in NestJS that require database operations, including creating new entities with full CRUD endpoints, services with Drizzle queries, Zod-validated DTOs, and unit tests. Triggered by requests like "generate a user module", "create a product CRUD", "add a new entity with endpoints", or when setting up database-backed features in NestJS.

The English summary is being prepared. Showing the original description.

| Type-safe ORM for Cloudflare D1 databases using Drizzle. Use when: building D1 database schemas, writing type-safe SQL queries, managing migrations with Drizzle Kit, defining table relations, implementing prepared statements, using D1 batch API, or encountering D1_ERROR, transaction errors, foreign key constraint failures, or schema inference issues.

The English summary is being prepared. Showing the original description.

Rules for Drizzle ORM schema design, query patterns, migration workflows, and relational query usage. Ensures type-safe, production-ready database interactions.

The English summary is being prepared. Showing the original description.

Expert in Drizzle ORM for TypeScript — schema design, relational queries, migrations, and serverless database integration. Use when building type-safe database layers with Drizzle.

The English summary is being prepared. Showing the original description.

mssql (node-mssql, Node.js 向け Microsoft SQL Server クライアント) の API リファレンス。 tedious / msnodesqlv8 ドライバー、SQL Server / T-SQL / TDS 接続、ConnectionPool、 `sql.query` タグ付きテンプレート、bulk insert、Table-Valued Parameter (TVP)、 prepared statement、isolation level、Diagnostics Channel、Azure AD 認証、CLI。 Drizzle ORM 経由の SQL Server 利用 (drizzle-orm/mssql-core) は別スキル drizzle が対象。

The English summary is being prepared. Showing the original description.

Type-safe ORM for Cloudflare D1 using Drizzle. Use when building D1 schemas, writing type-safe queries, generating migrations with Drizzle Kit, defining relations, using db.batch, or hitting D1_ERROR, BEGIN TRANSACTION failures, foreign key constraints, env.DB undefined, or schema inference issues.

The English summary is being prepared. Showing the original description.

Plan database structure changes and existing data updates for production systems. Provides migration patterns for adding columns and indexes, switching applications in stages, and documenting recovery steps while accounting for downtime and database locks.

• Adding columns or indexes to production tables
• Updating large datasets in batches
• Planning a staged column replacement without downtime

Guides development with Neon, a managed Postgres database platform, using official documentation. Covers project setup, connection choices, local development, authentication, data APIs, and resource management through command-line tools and programming libraries.

• Set up a Neon project and database connection
• Choose a connection method for serverless or edge functions
• Integrate Neon authentication and data APIs

Generate a starting project for a subscription web app with Next.js, including sign-in, database schemas, billing routes, and a dashboard. The workflow also covers staged validation and reference documents for customization and common setup problems.

• Starting a subscription web app
• Setting up authentication and billing together
• Building a dashboard and pricing page

Turn plain language requirements into SQL, investigate slow queries, document database structures, and prepare migration templates with rollback plans. Support everyday database development and ORM use, where libraries connect application code to database tables.

• Writing SQL for reports and data retrieval
• Investigating slow queries and repeated database calls
• Preparing schema changes and rollback plans

Generate Drizzle ORM schemas for Cloudflare D1 databases with correct D1-specific patterns. Produces schema files, migration commands, type exports, and DATABASE_SCHEMA.md documentation. Handles D1 quirks: foreign keys always enforced, no native BOOLEAN/DATETIME types, 100 bound parameter limit, JSON stored as TEXT. Use when creating a new database, adding tables, or scaffolding a D1 data layer.

The English summary is being prepared. Showing the original description.

Provides comprehensive NestJS framework patterns with Drizzle ORM integration for building scalable server-side applications. Generates REST/GraphQL APIs, implements authentication guards, creates database schemas, and sets up microservices. Use when building NestJS applications, setting up APIs, implementing authentication, working with databases, or integrating Drizzle ORM.

The English summary is being prepared. Showing the original description.