drizzle

Define database schemas, write queries, and manage migrations with Drizzle ORM.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/jovivaspo/base-agent-next-app --skill drizzle-jovivaspo
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: drizzle
Source: https://github.com/jovivaspo/base-agent-next-app/tree/main/skills/drizzle
Command: npx skills add https://github.com/jovivaspo/base-agent-next-app --skill drizzle-jovivaspo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill simplifies and standardizes the process of defining database schemas, writing queries, and managing migrations with Drizzle ORM, ensuring type safety and efficient data operations.

Core Features & Use Cases

  • Schema Definition: Provides clear examples for defining tables, columns, and relationships using Drizzle's type-safe API.
  • Querying: Demonstrates how to perform select, insert, update, and delete operations with various operators and conditions.
  • Migrations: Guides on generating, pushing, and applying database migrations using drizzle-kit.
  • Use Case: When building a new feature that requires user data, use this Skill to quickly define the users and posts tables, write a query to fetch a user and their posts, and ensure migrations are correctly applied.

Quick Start

Use the drizzle skill to create a new schema for a 'products' table with 'id', 'name', and 'price' columns.

Frequently Asked Questions about drizzle

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I define database schemas and manage migrations with Drizzle ORM in TypeScript?

Drizzle ORM schemas are defined using a type-safe TypeScript API for tables and columns, while migrations are generated and applied using drizzle-kit to ensure efficient, type-safe database operations.

Does Drizzle ORM support PostgreSQL, MySQL, and SQLite for querying and relationships?

Yes, Drizzle ORM supports PostgreSQL, MySQL, and SQLite, enabling you to perform select, insert, update, and delete operations with advanced operators and relational queries across these databases.

What's the best way to generate and apply database migrations using drizzle-kit?

Database migrations using drizzle-kit are handled by generating schema changes, pushing updates, and applying migrations directly to ensure your database structure stays synchronized with your Drizzle ORM definitions.

Can I use Drizzle ORM with Supabase for database operations?

Yes, Drizzle ORM supports integration with Supabase, allowing you to streamline your database operations, schema definitions, and type-safe queries within a Supabase environment.

Do I need drizzle-kit to generate schemas and execute migrations?

Yes, both Drizzle ORM and drizzle-kit are required dependencies; drizzle-kit specifically handles the schema generation and migration execution needed to manage your database structure.