;}%20.st6{fill:url(%23SVGID_00000021089067129159788970000008246765442136188072_);}%20.st7{fill:url(%23SVGID_00000117639240116366130650000015074833605515028638_);}%20.st8{opacity:0.4;fill:url(%23SVGID_00000101781798616409025840000016567063639337360777_);}%20.st9{opacity:0.4;fill:url(%23SVGID_00000052086836598721292040000002033117744178971046_);}%20.st10{opacity:0.4;fill:url(%23SVGID_00000159460939004760751800000002448009281983951536_);}%20.st11{opacity:0.4;fill:url(%23SVGID_00000013177830667419993080000017721442101626521532_);}%20.st12{opacity:0.4;fill:url(%23SVGID_00000152235521444854938490000006526001119318383285_);}%20.st13{opacity:0.4;fill:url(%23SVGID_00000119823135212293698520000012774889010992664993_);}%20%3c/style%3e%3cg%3e%3cpolygon%20class='st2'%20points='134.78,14.22%20114.31,48.21%20101.33,69.75%20158.22,69.75%20177.97,36.95%20191.67,14.22%20'/%3e%3cpolygon%20class='st3'%20points='227.55,69.75%20186.61,69.75%20101.33,69.75%20129.78,119.02%20158.16,119.02%20228.61,119.02%20256,119.02%20'/%3e%3cpolygon%20class='st3'%20points='136.93,132.47%20116.46,167.93%2073.82,241.78%20130.71,241.78%20144.9,217.2%20180.13,156.18%20193.82,132.46%20'/%3e%3cpolygon%20class='st3'%20points='121.7,131.95%20101.23,96.49%2058.59,22.63%2030.15,71.91%2044.34,96.49%2079.57,157.5%2093.26,181.22%20'/%3e%3cpolygon%20class='st2'%20points='64.81,131.95%2025.15,131.21%200,130.74%2028.44,180.01%2066.73,180.72%2093.26,181.21%20'/%3e%3cpolygon%20class='st2'%20points='165.38,181.74%20184.58,216.46%20196.75,238.47%20225.19,189.2%20206.66,155.69%20193.83,132.46%20'/%3e%3c/g%3e%3c/svg%3e)
Windmill HubPostgreSQL
Scripts
Building blocks, if none of the projects above fit. Fork one, run it, or call it as a step inside your own flow.
New Row
Script postgresql
Delete Row(s)
Script postgresql
Update Row
Script postgresql
Find Row
Script postgresql
Execute Query and return results
Script postgresql Verified
Postgres with TLS / SSL
Script postgresql Verified
Execute arbitrary Query in Bun
Script postgresql Verified
Execute arbitrary Query
Script postgresql Verified
python- connect to a database and query for data
Script postgresql
Backup postgres database and send to S3 with rotation
Script postgresql
Flows
Multi-step workflows that already wire PostgreSQL to something else.
+1
Upon new user signup, check for existence in postgres, hash password, add record to postgres and airtable, send an email to new user.
Flow postgresql airtable +1 Verified
See account data over the last 3 days as a pie chart
Flow showcase slack +1 Verified
+1
Ban a user, notify them by email, and us by Slack
Flow postgresql slack +1 Verified
Resource type
postgresql — the shape of the credential every script on this page expects.
| Field | Type | Required | What it is |
|---|---|---|---|
| accept_invalid_certs | boolean | No | Accept any certificate presented by the server, which disables TLS certificate verification and is not recommended. Only applies to verify-ca/verify-full. |
| dbname | string | Yes | The database name |
| host | string | No | The instance host |
| password | string | Yes | The postgres users password |
| port | integer | No | The instance port |
| region | string | No | AWS region for IAM auth (e.g. us-east-1). Falls back to AWS_REGION env var if not set. |
| root_certificate_pem | string | No | The root certificate in pe format |
| sslmode | string | No | Most cloud databases (Heroku, AWS, Supabase, etc.) require SSL. Self-hosted databases typically don't. |
| use_iam_auth | boolean | No | Use IAM authentication (AWS RDS/Aurora). When enabled, the password field is ignored and a short-lived IAM token is generated instead. |
| user | string | Yes | The postgres username |