PostgreSQL

Gather your connection details

You'll need: host, port (default 5432), database name, username, and password. For cloud-hosted Postgres, whitelist your CipherSense Agents server's IP in the database's firewall or security group rules.

Create a least-privilege user (recommended)

For security, create a read-only database user instead of sharing admin credentials.

-- Create read-only user
CREATE USER CipherSense Agents_ro WITH PASSWORD 'your-password';
GRANT CONNECT ON DATABASE your_db TO CipherSense Agents_ro;
GRANT USAGE ON SCHEMA public TO CipherSense Agents_ro;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO CipherSense Agents_ro;

-- Grant access to future tables automatically
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT SELECT ON TABLES TO CipherSense Agents_ro;

Add the integration in CipherSense Agents

Navigate to your Project > Integrations > Add Integration > PostgreSQL. Fill in your host, port, database name, username, and password. Click Save & Test to verify the connection.

Use in a workflow

Drag a PostgreSQL node into the Visual Designer. Select your configured integration, choose an operation (query, insert, update), write your SQL, and map the results to downstream Agent node variables.