drizzle-postgres

Define and manipulate PostgreSQL/PostGIS schemas with type-safe drizzle-orm queries.

Updated Jan 11, 2026

Search Tags:#typescript #postgresql #drizzle #orm #postgis #database-migrations #spatial-queries

Ready to run

npx skills add https://github.com/ohall/thesituation --skill drizzle-postgres

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: drizzle-postgres
Source: https://github.com/ohall/thesituation/tree/main/.skills/drizzle-postgres
Command: npx skills add https://github.com/ohall/thesituation --skill drizzle-postgres

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Drizzle ORM patterns simplify building robust, type-safe database schemas and queries for PostgreSQL and PostGIS, reducing boilerplate and errors.

Core Features & Use Cases

Strong type-safe schema definitions with drizzle-orm for PostgreSQL/PostGIS.
Upsert, spatial queries, and migrations to keep data consistent across deployments.
Use case: build a geo-aware incident tracking system with efficient reads and spatial filters.

Quick Start

Run the Drizzle-based setup to scaffold your schema and perform migrations against a PostGIS-enabled database.

Frequently Asked Questions about drizzle-postgres

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

FAQPage Schema

How do I use Drizzle ORM for type-safe PostGIS spatial queries in TypeScript?▼

Drizzle ORM PostGIS spatial queries are executed using custom geometry types and spatial indexing patterns. You can filter and query geographic data efficiently while maintaining strict TypeScript type safety across your database schemas.

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

PostgreSQL database migrations with Drizzle ORM are managed by scaffolding type-safe schema definitions and applying them sequentially. This approach ensures your database structure stays consistent across deployments without manual SQL boilerplate.

Does Drizzle ORM support PostGIS geometry types and spatial indexing?▼

Yes, drizzle-postgres supports custom PostGIS geometry types and spatial indexing. It enables developers to define robust, type-safe schemas for geographic data and execute pattern-based spatial queries natively.

How do I perform database upserts using Drizzle ORM in Node.js?▼

Database upserts using Drizzle ORM in Node.js are handled through specific upsert patterns provided by the Skill. These patterns ensure data consistency by seamlessly inserting new records or updating existing ones during migration operations.

Can I build a geo-aware incident tracking system using Drizzle ORM and PostGIS?▼

Yes, you can build a geo-aware incident tracking system using Drizzle ORM and PostGIS. The Skill provides type-safe schema definitions, spatial filters, and efficient reads required for tracking incidents with geographic data.