Add a database

Connecting your data is the first step to unlocking AI-powered insights in Toucan AI.

How-to: Data Connections - Add a Database

Objective

In this tutorial, you will learn how to connect a database to Toucan AI. We will demonstrate how to add a PostgreSQL database, but you can also connect other database types, such as BigQuery. Other connectors like MySQL, Redshift, Snowflake, and ClickHouse will be available soon.

Prerequisites

• You must be logged in to your Toucan AI account.

• A PostgreSQL database (or another available connector) to add.

Steps

1. Access the "Database" Section

• From the home page of Toucan AI, click on the Database tab.

• You will be redirected to an interface that lists all the databases currently connected to your space.

2. Add a New Database

• In the top-right corner, click the Add Database button.

• A list of available connectors (PostgreSQL, BigQuery) will appear.

3. Select the PostgreSQL Connector

• Select PostgreSQL to add a new PostgreSQL database.

Note: Other connectors will be added soon, and we encourage you to provide feedback on which connectors you need, such as MySQL, Redshift, Snowflake, ClickHouse, etc.

4. Complete the Connection Information

• Fill in the required fields:

  • Name: Give a name to your connector, such as "PostgreSQL Toucan".

  • Host: Enter the address of your PostgreSQL server.

  • Database: The name of your database.

  • Username: Your username for accessing the database.

  • Password: The password associated with your username.

  • Port: The port used for the connection (default is 5432 for PostgreSQL).

  • SSL: You can enable or disable the SSL option as needed.

5. Test the Connection

• After filling in the details, click the Test Connection button to check if the connection is successful.

• If the connection is valid, you will receive a success notification.

6. Connect to the Database

• Once the connection is successfully tested, click Connect to finalize the addition of the database, and Save.

• A small green pop-up saying "Database Added" will appear in the top-right corner of the interface.

Conclusion

Congratulations! You have successfully connected your PostgreSQL database to Toucan AI. You can now start analyzing your data and creating visualizations with AI.

Suggested Next Steps: discover how-to Analyse your database with AI!