Goal: Build an open-source RAG based chatbot that uses Supabase (for database + vector database) + AI SDK, on top of the devsForFun starterkit and document every step.

[CharanMN7]

The core tasks involved in this project are:

• Figuring out a database schema for this application that can be integrated into any other project without disturbing that project's existing schema.
• Write code that can easily be copied and pasted into a project that has the necessary dependencies (for now, it should work easily with projects that are built on top of the starterkit template.)

Things to explore:

• Supabase as a vector database (pgvector)
• Vercel's AI SDK

Some Guildelines:

• Always commit small changes with detailed commit messages (Human written are preferred but AI generated are also fine as long as they communicate the right thing) instead of committing massive changes or multiple files in a single commit. Doing this will help people going through the code to learn what's going on.
• To contribute, fork this repository, work on it, and create a Pull Request and add @CharanMN7 as reviewer.

[CharanMN7]

@rooney011 let me know if you have any questions.

[rooney011]

Okay 👍🏻

[rooney011]

• Should this schema include only chatbot data (messages, sessions, sources) or also vector embeddings?
• chatbot data be linked to auth.users, or is a standalone user table fine?

[CharanMN7]

@rooney011

1. Yes, it needs to include both the chatbot data and the vector embeddings. Also, do not worry if you're not sure how it is going to turn out. Once you create the PR, we can review it and make any changes if needed. You don't have to get it right, the very first time.
2. A separate profiles (i'm just calling it profiles instead of a standalone user table) table isn't a bad idea... Well, just link it to auth.users for the time being. A dedicated profiles table is only use-case specific anyway.

[CharanMN7]

@rooney011 Good work on #2 ! 👍

Next up is building a responsive chatbot UI that uses Vercel's AI SDK and Shacn UI components. Check out shadcn/ui and AI SDK.

Challenge: Make sure the components you write are modular, easy-to-understand, and reusable.

[rooney011]

yeah okay