PostgreSQL

Import PostgreSQL actions from automate.ax/postgres. Action inputs accept plain values or compatible signals.

import { automation, onHttpRequest } from "automate.ax"
import { runQuery } from "automate.ax/postgres"

export default automation("Read active customers", () => {
  onHttpRequest({ scope: "automation" })
  runQuery({
    sql: "select id, email from customers where active = $1",
    parameters: [true],
  })
})

Leave account unset to use the project’s default PostgreSQL binding, or pass a named binding or postgresAccount(...) declaration. The account stores the database connection string; it never enters action inputs or signals.

Run query

Execute one parameterized statement and inspect rows and PostgreSQL metadata.

⌘I

Get started

Concepts

Reference

Run query