To integrate Max with PostgreSQL, you need to establish a connection that allows Max to access and interact with your PostgreSQL database. Here’s a step-by-step guide on how to set up a new PostgreSQL connection:

Step-by-Step Guide

1. Navigate to the Data Page: Access the Data page within Max where all connections are managed.

2. Initiate New Connection:

   • Click the + button in the bottom left of the connections left panel to start the process of creating a new connection.

3. Fill in Connection Details:

   • Connection Name: Enter a unique name for the connection to help identify it within Max.
   • Description (optional): Provide a brief description of what this connection will be used for.
   • Connection Type: Select PostgreSQL from the dropdown menu.

4. Database Details:

   • Database Host: Enter the hostname or IP address of the database server.
   • Database Name: Specify the name of the PostgreSQL database to connect to.
   • Database Schema: Enter the target schema within the database that you want to query.
   • Port: Specify the port number for the connection; this is optional unless you are using a proxy server.

5. Authentication:

   • Database User: Provide the username that Max will use to access the database.
   • Password: Enter the password associated with the database user.

6. Test and Create:

   • Click the Test Connection button to verify that Max can connect to the PostgreSQL database with the provided settings.
   • If the test is successful, click the Create button to finalize the connection.

Important Notes

• Ensure that all connection details, especially the host, database name, and authentication credentials, are entered correctly to avoid connectivity issues.
• Adjust the port settings if your database configuration requires a specific port that differs from the default PostgreSQL port.

Setting up this connection allows Max to perform data operations directly on your PostgreSQL databases, enabling robust data analysis and interaction.