FEATURE REQUEST: Database Configuration

[smokeyScraper]

🌟 Feature Description

Implement a hybrid database architecture using Supabase and Weaviate to create two main knowledge bases:

1. User_Info_collection: Store unified user profiles with Discord/GitHub linked identities, contribution stats, and skill analysis
2. GitHubInfoDB: Store repository codebase with fine-grained chunking for code search and analysis

Both databases will support RAG (Retrieval Augmented Generation) for the DevRel agent to provide intelligent assistance.

🔍 Problem Statement

The current system only uses Supabase with basic vector storage (100-dimension embeddings). This limits:

• Complex semantic search across large codebases
• Efficient multi-modal data storage (structured + vector data)
• Scalable vector search for thousands of code chunks
• Rich metadata filtering for user profiles and code snippets
• Cross-platform user identity management

Expected Design/Workaround

🎯 Expected Outcome

A hybrid database system where:

• Supabase stores structured metadata, relationships, and acts as the source of truth
• Weaviate handles high-dimensional vector embeddings (384+ dimensions) with efficient similarity search
• Both databases are synchronized with foreign key relationships
• RAG-enabled search across user profiles and codebases
• Seamless identity linking between Discord/GitHub accounts

[Eli4479]

Hi @smokeyScraper ! 👋 I'd like to work on this issue. Could you please assign it to me? Thanks!