# \[Announce\] Postgres Migration Node

**URL:** https://discourse.nodered.org/t/announce-postgres-migration-node/98058
**Category:** Share Your Nodes
**Created:** [9 July 2025 18:25 UTC](https://discourse.nodered.org/t/announce-postgres-migration-node/98058 "2025-07-09T18:25:39Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![mlschuh](https://avatars.discourse-cdn.com/v4/letter/m/ce73a5/32.png) [@mlschuh](https://discourse.nodered.org/u/mlschuh)
#### Post date: [9 July 2025 18:25 UTC](https://discourse.nodered.org/t/announce-postgres-migration-node/98058/1 "2025-07-09T18:25:39Z")

</div>

Hi everyone,

I keep running into situations where I'd like to manage migrations of a Postgres database in my Node-RED projects but existing tooling is centered around files in a filesystem. This node applies database migrations in the same manner as `sql` files but with the SQL defined in `msg.migrations`. That way the migrations are stored and versioned with the Node-RED flow and self contained.

For disclosure, I used Gemini to get the ball rolling and to make useful documentation.

Seeing as this is my first (public) node, please be gentle with any feedback.

> **[@smartmonkeysinc/node-red-contrib-postgres-migrations](https://flows.nodered.org/node/@smartmonkeysinc/node-red-contrib-postgres-migrations)**
>
> A Node-RED node to run PostgreSQL migrations from a msg.migrations array using Knex.