---
title: "GET /api/v2/secret-rotations/postgres-credentials"
method: GET
path: "/api/v2/secret-rotations/postgres-credentials"
tags: ["Secret Rotations"]
---

# GET /api/v2/secret-rotations/postgres-credentials

`GET /api/v2/secret-rotations/postgres-credentials`

List the PostgreSQL Credentials Rotations for the specified project.

## Query parameters

- `projectId` string, required

## Response `200`

Default Response

- object
  - `secretRotations` object[], required
    - `id` string, uuid, required
    - `name` string, required
    - `description` string, nullable
    - `isAutoRotationEnabled` boolean
    - `activeIndex` number
    - `folderId` string, uuid, required
    - `connectionId` string, uuid, required
    - `createdAt` string, date-time, required
    - `updatedAt` string, date-time, required
    - `rotationInterval` number, required
    - `rotationStatus` string, required
    - `lastRotationAttemptedAt` string, date-time, required
    - `lastRotatedAt` string, date-time, required
    - `lastRotationJobId` string, nullable
    - `nextRotationAt` string, date-time, nullable
    - `isLastRotationManual` boolean
    - `connection` object, required
      - `app` 'postgres', required
      - `name` string, required
      - `id` string, uuid, required
    - `environment` object, required
      - `slug` string, required
      - `name` string, required
      - `id` string, uuid, required
    - `projectId` string, required
    - `folder` object, required
      - `id` string, required
      - `path` string, required
    - `rotateAtUtc` object, required
      - `hours` number, required
      - `minutes` number, required
    - `lastRotationMessage` string, nullable
    - `type` 'postgres-credentials', required
    - `parameters` object, required
      - `username1` string, required — The username of the first login to rotate passwords for. This user must already exists in your database.
      - `username2` string, required — The username of the second login to rotate passwords for. This user must already exists in your database.
      - `rotationStatement` string — The SQL template query used for rotation.
      - `passwordRequirements` object — The password requirements to use when generating the new password.
        - `length` number, required — The length of the password to generate.
        - `required` object, required
          - `digits` number, required — The amount of digits to require in the generated password.
          - `lowercase` number, required — The amount of lowercase characters to require in the generated password.
          - `uppercase` number, required — The amount of uppercase characters to require in the generated password.
          - `symbols` number, required — The amount of symbols to require in the generated password.
        - `allowedSymbols` string — The allowed symbols to use in the generated password (defaults to "-_.~!*").
    - `secretsMapping` object, required
      - `username` string, required — The name of the secret that the active username will be mapped to.
      - `password` string, required — The name of the secret that the generated password will be mapped to.

## Other responses

- `400` — Default Response
- `401` — Default Response
- `403` — Default Response
- `404` — Default Response
- `422` — Default Response
- `500` — Default Response

---

[API](https://skmtc.net/infisical/apis/infisical-api.md) · [All operations](https://skmtc.net/infisical/apis/infisical-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/infisical/infisical-api/versions/885aef3e6c11/schema)