Connecting to PostgreSQL

You can connect your PostgreSQL database to Livedocs from the Data tab in your workspace.

How to Connect

1. Go to the Data tab in your workspace.
2. Click Connect a Database.
3. In the Database Type dropdown, select Postgres.
4. Fill in the connection details (see below).
5. Click Connect to Database.

Connection Fields Explained

• Name – A friendly name for this connection (e.g., Marketing DB).
• Host – The hostname or IP address of your Postgres server (e.g., db.example.com).
• Port – Default is 5432.
• Database Name – The name of the database you want to connect to.
• Username – Your Postgres username.
• Password – Your Postgres password.
• Connect using URL – Optionally, you can check this to provide a full PostgreSQL connection string instead of filling out the individual fields. Format:

  postgres://username:password@host:port/database

Whitelisting IPs

Some databases require you to whitelist the IP address that Livedocs will connect from. If that’s the case:

• Copy the IP shown in the Whitelist IPs section of the modal.
• Add it to your database or hosting provider’s IP allowlist.

Additional Options

• Allow Inserts and Updates – Check this if you want to allow write access from Livedocs to your database.
• Don’t Have Credentials? – You can invite a teammate who has database credentials to connect the data for you.

Next Steps:

• Querying Data in SQL Cells
• Supported Databases