skills.rest
aussiegingersnap
aussiegingersnapCOMMUNITY
Explore all skills by this author →
𝕏@jasontoevsGitHub

db-postgres

Set up PostgreSQL databases in Node.js/TypeScript projects using Drizzle ORM with versioned migrations.

9|2|Updated Jan 31, 2026
Search Tags:#typescript#postgresql#migrations#docker#nodejs#drizzle-orm#database-schema
One-click install
npx skills add https://github.com/aussiegingersnap/cursor-skills --skill db-postgres
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-postgres
Source: https://github.com/aussiegingersnap/cursor-skills/tree/main/skills/db-postgres
Command: npx skills add https://github.com/aussiegingersnap/cursor-skills --skill db-postgres

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Set up and maintain PostgreSQL databases for Node.js/TypeScript projects using Drizzle ORM, with versioned migrations and local Docker development.

Core Features & Use Cases

  • Versioned migrations with Drizzle ORM
  • Type-safe queries and schema patterns
  • Local development support with Docker and environment configuration

Quick Start

Install dependencies, configure DATABASE_URL, start local PostgreSQL with Docker, then generate and apply migrations to initialize your schema.

Frequently Asked Questions about db-postgres

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

FAQPage Schema
How do I set up PostgreSQL with Drizzle ORM and versioned migrations in a Node.js TypeScript project?▼

To set up PostgreSQL with Drizzle ORM, install dependencies, configure the DATABASE_URL environment variable, start local PostgreSQL with Docker, then generate and apply migrations to initialize your schema.

What is the best way to configure a local PostgreSQL database for Node.js development using Docker?▼

The best way to configure a local PostgreSQL database is using Docker with environment configuration. You set the DATABASE_URL, start the container, then apply versioned migrations to establish your database schema.

Does Drizzle ORM support type-safe queries and singular naming conventions for database schemas?▼

Yes, Drizzle ORM supports typed, safe query patterns and enforces singular naming conventions for database schemas, ensuring type safety in Node.js and TypeScript projects throughout your migration workflows.

How do I generate and apply database migrations using Drizzle ORM in TypeScript?▼

You generate and apply database migrations using Drizzle ORM by configuring your schema, running the migration generation command, and applying the versioned output to your PostgreSQL database to update its structure.

Can I use this PostgreSQL setup for project boilerplates and local Docker-based development?▼

Yes, this PostgreSQL setup is specifically applicable to project boilerplates, migration workflows, and local Docker-based development, providing environment configuration and typed query patterns for Node.js.

Related Skills

Explore More Software Engineering Skills→
Nick777-PixelNick777-Pixel

drizzle

Generate TypeScript ORM migrations and models from Drizzle schema definitions for PostgreSQL projects.

Community
Intermediate
rally19rally19

drizzle-orm

Provide type-safe SQL access for TypeScript applications with zero runtime dependencies.

Community
Advanced
ayesha-aziz123ayesha-aziz123
2

drizzle-orm

Provide type-safe SQL queries and schema migrations for TypeScript projects.

Community
Intermediate
lobehublobehub
81.4k

drizzle

Define TypeScript database schemas and generate migrations with Drizzle ORM.

Official
Intermediate