Skip to main content

PostgreSQL

To add a PostgreSQL connection, click on the PostgreSQL option in Connect a data source section. connect

Connect

Fill in the connection settings: postgresql

Connecting from a local PostgreSQL database

For MacOS and Windows users connecting from a local PostgreSQL database, simply use host.docker.internal as the host to establish the connection.

You can refer to this blog post, which includes detailed steps for your reference.

Display name

The display name for the database in the Wren AI interface.

Host

Your PostgreSQL database's IP address or domain name.

Port

Your PostgreSQL database port.

Username

The database username for the account that you want to use to connect to your PostgreSQL database.

Password

The password for the username that you use to connect to the database.

Database name

The name of the database you want to connect to.

Click Next to start connection and go to the next step.

Select Tables

All tables of your connected PostgreSQL dataset will be listed in this step. Select which tables you want to use in Wren AI. Each selected table will be created as a data model. See the Modeling documentations to learn more about what is data models. select_table

Define relationships

Define the relationships among selected tables in this step. If you have defined primary keys and foreign keys in your PostgreSQL dataset, we will list suggested relationships based on the information. If not, you can also add relationships by clicking the Add relationships button on the table blocks. relationship

Define following properties in a relationship:

  • From: Select the left side table and column of this relationship.
  • To: Select the right side table and column of this relationship.
  • Relationship Type: Select the type of relationship. add_relationship

Find more information about relationship in Modeling - Working with Relationships

You can also skip this step and finish connection.