Book a demo

PostgreSQL

Databases & warehousesUsername & passwordConnection test available

PostgreSQL database — SELECT 1 connectivity test.

OCNORA ships 1 typed PostgreSQL operation. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run.

Ask about PostgreSQL

Before you connect PostgreSQL

Authentication
Username & password
Credential
the password, or {"password": "…"}
Connection test
Available: the stored credential can be checked against the provider when you add it. This is not a record that a test was run or passed.

What you can do with PostgreSQL

Operations, grouped by what they do to your data.

Create and send 1

Nodes that use your PostgreSQL connection

Beyond its own nodes, these generic nodes accept your PostgreSQL credential. Each chooses the provider from the connection you select, so the same node also works with the other providers shown.

  • SQL Query
    db.query
    Run a parameterised SELECT/INSERT/UPDATE/DELETE against a Postgres or MySQL connection.
    Also works withMySQL
  • Vector: Create Collection
    vector.create_collection
    Create a collection (index / class / table) sized for one embedding model.
    Also works withPineconeQdrantWeaviateMongoDB
  • Vector: Delete
    vector.delete
    Delete records from a vector store by id, by metadata filter, or all of them.
    Also works withPineconeQdrantWeaviateMongoDB
  • Vector: Describe Collection
    vector.describe_collection
    Read one collection's width, metric and record count.
    Also works withPineconeQdrantWeaviateMongoDB
  • Vector: List Collections
    vector.list_collections
    List the collections a vector store holds.
    Also works withPineconeQdrantWeaviateMongoDB
  • Vector: Query
    vector.query
    Find the records nearest to a query text or vector, with metadata filtering.
    Also works withPineconeQdrantWeaviateMongoDB
  • Vector: Upsert
    vector.upsert
    Write documents and their vectors into a vector store, with metadata.
    Also works withPineconeQdrantWeaviateMongoDB

A sample PostgreSQL workflow

  1. 1
    A core trigger
    Start the run from a chat, form, manual, schedule, webhook, workflow trigger — no PostgreSQL trigger is needed.
  2. 2
    Run Querypostgres.query
    Run a parameterised SQL query against a PostgreSQL database.

An outline built from this provider’s node contracts, not a recorded run. Each step’s output fields are available to the next in the field picker.

Every node below has a reference page: what it does, the connection it needs, its config fields with types, constraints and examples, and the shapes it emits.

Operations 1

Solutions

PostgreSQL questions

How does OCNORA authenticate with PostgreSQL?
With a stored Username & password credential, shaped the password, or {"password": "…"}. A connection test can check it when you add it.
What can I automate with PostgreSQL?
1 typed operation, each with a reference page listing its config fields and the shapes it emits. The credential also drives 7 generic nodes.
What if the PostgreSQL operation I need is not listed?
Where PostgreSQL has an HTTP API, call it from the HTTP node with the same credential, or describe the step to the AI builder, which asks our team for a typed node when one is missing.
Are there templates that use PostgreSQL?
Not yet. Start from a blank workflow, or describe the workflow to Build with AI.
How are PostgreSQL calls controlled?
Every call and every run step is audited, runs count against the execution budget, and Workflow Health pre-flights the workflow when you save it.

More in Databases & warehouses

See your first PostgreSQL workflow run.

Book a technical demo. We add the connection, pick a template or describe the workflow to Build with AI, and Workflow Health checks it before it runs.

Book a technical demoTalk to sales