Define and manipulate PostgreSQL/PostGIS schemas with type-safe drizzle-orm queries.
npx skills add https://github.com/ohall/thesituation --skill drizzle-postgres
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
Drizzle ORM patterns simplify building robust, type-safe database schemas and queries for PostgreSQL and PostGIS, reducing boilerplate and errors.
Run the Drizzle-based setup to scaffold your schema and perform migrations against a PostGIS-enabled database.
High-intent search queries and answers about installing and using this skill.
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.
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.
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.
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.
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.
aussiegingersnapSet up PostgreSQL databases in Node.js/TypeScript projects using Drizzle ORM with versioned migrations.
Imad-OuteAnalyze and visualize geographic vector data with GeoPandas in Python.
MolcajeteAIConfigure Drizzle ORM for Node.js with PostgreSQL schema and migrations.
blockmaticBuild type-safe SQL queries and migrations for PostgreSQL, MySQL, and SQLite in TypeScript.
