Tooling
GitHub Actions
PostgreSQL

Postgres

The Postgres action depends on the python psycopg2 library. You can find complete documentation about the library here (opens in a new tab).

Fields

FieldRequiredDefaultDescription
db-hostyesThe database host
db-portno5432The database port
db-database-nameyesThe database name
db-useryesThe database user
db-passwordyesThe database password

Example

on:
  - pull_request
name: PostgreSQL
jobs:
  test_postgres:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout
        uses: actions/checkout@v4
      - name: Run Grai Action
        uses: grai-io/grai-actions/postgres@master
        with:
          namespace: my_apps_grai_namespace
          api-key: my_grai_api_key
          action: tests
          source-name: prod-db
          grai-api-url: https://api.grai.io
          db-host: prod.db.com
          db-port: '5432'
          db-database-name: my_database
          db-user: my_user
          db-password: my_password
MySQLRedshift