PostgreSQL

PostgreSQL is generally available in the DataSquares connection wizard. Connect with host, port and database credentials.

1. In DataSquares, open Data Sources and choose Add data source.

2. Pick PostgreSQL in the connector picker (search or browse by category).

3. Fill in the connection details below, then test the connection and save.

Connection details

Field	What to enter
Host	The hostname or IP address of your PostgreSQL server.
Port	Prefilled with 5432 (the PostgreSQL default) — change it if your server listens elsewhere.
Database	The database to connect to.
Username / Password	Credentials for a user with read access to the tables you want to analyze.
TLS	Enable if your server requires an encrypted connection.

Grant the connection user read-only access — DataSquares only ever reads from your source.

Grant read-only access

Create a dedicated user with SELECT on what DataSquares should see:

CREATE USER datasquares WITH PASSWORD '********';
GRANT CONNECT ON DATABASE analytics TO datasquares;
GRANT USAGE ON SCHEMA public TO datasquares;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO datasquares;
-- future tables too:
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO datasquares;

TLS

Managed Postgres (RDS, Cloud SQL, Azure, Neon, Supabase) generally requires TLS — turn the toggle on. For self-hosted servers, enable ssl = on in postgresql.conf or leave the toggle off on trusted networks.

Common errors

Error	Cause / fix
password authentication failed for user	wrong credentials, or the user isn’t allowed from this host — check pg_hba.conf
no pg_hba.conf entry for host	add a host rule for the DataSquares server’s IP (or your provider’s allowlist)
database "x" does not exist	the Database field wants the database name, not the schema
connection timeout	port 5432 not reachable — security group / firewall

Related

• Connector catalog — everything DataSquares connects to.
• Quickstart — from connection to shared dashboard.