Lightlines
By ccheney

postgres-drizzle

ccheney1.5k installs

PostgreSQL changes matched to your project's APIs.

What it does

Guides database changes and reviews to produce PostgreSQL SQL, Drizzle code, migrations, or performance diagnoses suited to the project's installed versions.

When to use it

Use for PostgreSQL and Drizzle schemas, queries, migrations, relations, indexing, pooling, or query performance, not unrelated databases or generic backend work.

How to use it

It changes how the agent writes and reviews database code by checking installed APIs, preserving migration history, and verifying the requested changes.

What you provide

  • An existing project

Uses

Latest review

What you need · 3

For Drizzle code, the guide works against the project's installed drizzle-orm version and driver rather than assuming an API version.

The Drizzle schema-change workflow uses drizzle-kit to generate migrations before reviewing their SQL.


Access · 5

This skill

PostgreSQL

Write

Applies authorized database migrations

production_db

Read

Copies production data for testing