Try our Interactive Data Client: a revolutionary, AI-Powered, custom data retrieval tool. Retrieve ANY data on ANY subject within seconds: Start Now!

Using PostgreSQL with Interzoid

Connecting Interzoid to your PostgreSQL database is straightforward. All you need is a connection string that tells Interzoid how to reach your Postgres instance. You can copy and paste the format below and replace the placeholders with your own values.

Basic Connection String


postgres://{user}:{password}@{host}:{port}/{database}?sslmode=require
            

Replace {user}, {password}, {host}, {port}, and {database} with your own values. The parameter sslmode=require ensures the connection is secure. This is all you need to get started.


Advanced: Granting Read-Only Access

For additional security, we recommend creating a dedicated read-only user account. This enables you to only provide the data that you want to Interzoid to be able to view for processing.

  • Create a new PostgreSQL role just for Interzoid (for example, interzoid_app_ro).
  • Grant that role read-only permissions on the database or specific tables you want Interzoid to use.
  • Use that role in your connection string instead of a regular user.

Read-Only Connection String Example


postgres://interzoid_app_ro:StrongPassword123@pg-host.mycompany.com:5432/interzoid_db?sslmode=require
            

Using a dedicated read-only user keeps your database secure and ensures third parties only have the level of access you allow.


Key Notes

  • You remain in full control of your PostgreSQL database.
  • You can revoke third party access at any time by disabling the read-only role or removing privileges.
  • Connection strings for your specific setup can also be found in your PostgreSQL configuration or cloud provider portal (e.g., AWS RDS, Azure, or GCP).

Questions? Contact support@interzoid.com.