Configure Supabase

We are going to use Supabase as the backend and database portion of the chatbot. You should have already completed the pre-requisites and have a Supabase account. If not, please create one now.

Once logged in, if you haven’t created a Project already, tap New Project and select the Organization which you created previously. Name the project, “AirbyteAIBot” and Tap “Create new project”.

[!NOTE] If you can not name your project upon initial set up, you can always do it later. Don’t worry, the name is not important for any of the code we will write.

Once your project is created, there are a few important things to note, especially when creating Destination connectors from Airbyte, in particular, Project URL and API Key. You will need these shortly. You can always access these keys, via Settings > API (under Configuration) if you need them.

Supabase automatically creates a database on your behalf. Tapping on the database icon on the left navigation, and ensuring you have the public schema selected, Supabase currently shows no tables have been created yet. Don’t worry, these will be automatically created by Airbyte when you sync data for the first time.

Enable PGVector Extension

One thing you do need to do is enable PGVector. PGVector is an extension to Postgres to allow it to create and store embeddings. Tap Extensions in the database submenu, and type “PGVector” into the search box, then enable the extension via the toggle.