skills.rest
ccheney
ccheneyCOMMUNITY
Explore all skills by this author →
𝕏@_cheneyGitHub

postgres-drizzle

Manage PostgreSQL schemas, queries, and migrations with Drizzle ORM.

58|3|Updated Jan 11, 2026
Search Tags:#typescript#database#migrations#sql#drizzle orm#orm#postgres
One-click install
npx skills add https://github.com/ccheney/robust-skills --skill postgres-drizzle-ccheney
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-drizzle
Source: https://github.com/ccheney/robust-skills/tree/main/skills/postgres-drizzle
Command: npx skills add https://github.com/ccheney/robust-skills --skill postgres-drizzle-ccheney

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines database interactions by providing type-safe schema definition, querying, and migration management for PostgreSQL using Drizzle ORM, reducing common errors and improving developer productivity.

Core Features & Use Cases

  • Type-Safe Schema: Define your database schema in TypeScript with Drizzle ORM, ensuring type safety for all database operations.
  • Efficient Querying: Write concise and performant queries using Drizzle's fluent API, including relational queries for nested data.
  • Automated Migrations: Generate and apply database migrations automatically using drizzle-kit.
  • Use Case: When building a new API backend, use this Skill to define your PostgreSQL schema, write all data access logic, and manage database schema evolution throughout development and deployment.

Quick Start

Use the postgres-drizzle skill to create a new users table with an id, email, and timestamps.

Frequently Asked Questions about postgres-drizzle

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

FAQPage Schema
How do I define a type-safe PostgreSQL schema in TypeScript?▼

To define a type-safe PostgreSQL schema in TypeScript, use Drizzle ORM to declare tables, columns, and relations. This approach ensures compile-time type safety for all subsequent database operations and queries.

What's the best way to manage PostgreSQL database migrations with Drizzle ORM?▼

The best way to manage PostgreSQL database migrations with Drizzle ORM is using drizzle-kit. It automates generating and applying schema migrations, streamlining database schema evolution throughout development.

Can I use Drizzle ORM with my existing node-postgres or postgres.js driver?▼

Yes, Drizzle ORM integrates natively with both postgres.js and node-postgres drivers. You can connect your existing PostgreSQL driver to execute type-safe queries and relational queries.

How do I write relational queries with nested data using Drizzle ORM?▼

You write relational queries with nested data in Drizzle ORM using its fluent API. This allows you to perform efficient joins and retrieve nested relational data concisely with full type safety.

Does Drizzle ORM support automated schema migration generation for PostgreSQL?▼

Yes, Drizzle ORM supports automated schema migration generation for PostgreSQL via drizzle-kit. It automatically generates and applies database migrations based on your TypeScript schema definitions.

Related Skills

Explore More Software Engineering Skills→
jezwebjezweb
961

cloudflare-hyperdrive

Connect Cloudflare Workers to PostgreSQL and MySQL databases via Hyperdrive.

Community
Intermediate
SyedaashnaghazanfarSyedaashnaghazanfar
3

drizzle-orm

Generates type-safe SQL queries and migrations for PostgreSQL in TypeScript applications.

Community
Intermediate
duwscanduwscan

postgres-drizzle

Define PostgreSQL schemas and write type-safe queries with Drizzle ORM.

Community
Advanced
zmh13928433602-syszmh13928433602-sys

drizzle

Define and manage PostgreSQL schemas and migrations with Drizzle ORM in TypeScript.

Community
Intermediate