PostgreSQL

Connect to PostgreSQL databases, including managed services like Neon, Supabase, and Amazon RDS.

Prerequisites

Before creating a connection, you need:

A PostgreSQL database that is publicly accessible from the internet
A database user with read permissions on the tables you want to query

Creating a read-only database user

For security, create a dedicated read-only user for Reeflow rather than using an admin account. This limits the potential impact if credentials are compromised.

PostgreSQL 14+
PostgreSQL 13 and earlier

PostgreSQL 14 introduced the pg_read_all_data role, which grants read access to all tables regardless of which user creates them:

-- Create the user
CREATE USER reeflow_reader WITH PASSWORD 'your-secure-password';

-- Grant read access to all data
GRANT pg_read_all_data TO reeflow_reader;

For older PostgreSQL versions, grant permissions manually on each schema:

-- Create the user
CREATE USER reeflow_reader WITH PASSWORD 'your-secure-password';

-- Grant connection access
GRANT CONNECT ON DATABASE your_database TO reeflow_reader;

-- Grant schema access (repeat for each schema)
GRANT USAGE ON SCHEMA public TO reeflow_reader;

-- Grant SELECT on all existing tables
GRANT SELECT ON ALL TABLES IN SCHEMA public TO reeflow_reader;

-- Grant SELECT on future tables (run as the table owner)
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON TABLES TO reeflow_reader;

Configuration

When creating a PostgreSQL connection in Reeflow, provide the following:

Field	Description
Host	Database server hostname or IP address
Port	Database server port (default: 5432)
Database	Name of the database to connect to
User	The read-only user you created (e.g., `reeflow_reader`)
Password	Password for the database user
SSL	Enable SSL/TLS encryption for the connection

Creating a connection

Create a PostgreSQL connection

Add a PostgreSQL database as a data source in Reeflow.