11.7. Connecting Your PostgreSQL Database
Last updated
Last updated
Connecting Your Database The AI2SQL plugin allows you to connect directly to your PostgreSQL database. Here's how to do it:
Open the ChatGPT application where you have installed the AI2SQL plugin.
Navigate to the AI2SQL plugin interface.
In the prompt field, type "Test Postgres Connection".
You will then be presented with a form to enter your PostgreSQL database details, which include:
Server Name: This is the IP address or domain name where your PostgreSQL database is hosted.
Database Name: This is the name of the specific PostgreSQL database to which you want to connect.
Username: This is the user account that has access to the PostgreSQL database.
Password: This is the password for the user account specified.
Port: The default PostgreSQL port is usually 3306, but it may be different depending on your setup.
After entering your PostgreSQL database credentials. The AI2SQL plugin will attempt to establish a connection with your database.
If the connection is successful, you will see a 'Successful' message.
If you encounter any problems during this process, please don't hesitate to contact us for assistance. Do note that certain connection issues might be due to network firewalls or incorrect database credentials. Ensure that your PostgreSQL server is configured to accept connections from the IP address of your ChatGPT application.
