Postgres Database

The Postgres Resource is a relational database solution for the Noop platform. It provides a no-configuration way to connect application services to the powerful, open-source object-relational database, Postgres.

Key Features

• All data is encrypted at rest and in-transit using industry standard AES-256 encryption and SSL/TLS respectively.
• Browse, query, and debug your data with the Resource Explorer for Postgres in the Noop Console.
• Manage access automatically for all Components referencing the Resource from the Blueprint Manifest (blueprint.yaml) file.

Usage

To add Postgres to your application, insert an entry in your Blueprint Manifest (blueprint.yaml) under resources. Specify the type as postgresql and include an alphanumeric name. The name is used to reference the Resource from other Noop services or tasks.

Here’s a complete Blueprint Manifest (blueprint.yaml) example:

components:
  - name: ApiService
    type: service
    root: api-service/
    image: node:24-alpine
    build:
      steps:
        - copy: package*.json
          destination: ./
        - run: npm ci
        - copy: index.js
        - copy: lib/
    runtime:
      command: npm start
      resources:
        - MyDatabase
      variables:
        DATABASE_URL:
          $resources: MyDatabase.url
routes:
  - pattern: /**
    target:
      component: ApiService
resources:
  - name: MyDatabase
    type: postgresql

When a Resource is connected to a Noop service, the following dynamic variables are available to use within the Blueprint Manifest:

• host
• port
• username
• password
• database
• url

To reference a Resource property, use the special $resources key. See the following example:

components:
  # ...
  - runtime:
      resources:
        - MyDatabase
      variables:
        DATABASE_URL:
          $resources: MyDatabase.url

As with all Noop resources, the Resource Explorer allows you to query and browse all data stored in Postgres. The Resource Explorer is available on the Resource page within the Noop Console. Note: the Postgres database is not accessible via the public internet.

Limitations

• Database backups are not enabled by default. Use a Noop Task to schedule a database backup routine.
• Supported database version is 16.