@loop/database

pnpm add @loop/database

import { createClient, createAdminClient, getClient, getAdminClient } from '@loop/database';
 
// Public client (respects RLS)
const client = createClient(supabaseUrl, anonKey);
 
// Admin client (bypasses RLS)
const adminClient = createAdminClient(supabaseUrl, serviceKey);
 
// Singleton getters
const client = getClient();
const admin = getAdminClient();

import { createRepositories } from '@loop/database';
 
const repos = createRepositories(supabaseClient);
 
// Available repositories
repos.users          // UserRepository
repos.stacks         // StackRepository
repos.labs           // LabRepository
repos.biomarkers     // BiomarkerRepository
repos.orders         // OrderRepository
repos.cart           // CartRepository
repos.products       // ProductRepository
repos.notifications  // NotificationRepository
repos.coas           // COARepository
repos.embeddings     // EmbeddingRepository
repos.faqs           // FAQRepository
repos.researchPapers // ResearchPaperRepository

import {
  generateEmbedding,
  searchKnowledgeBase,
  upsertArticleChunks,
} from '@loop/database';
 
// Generate embedding
const embedding = await generateEmbedding('How does BPC-157 work?');
 
// Search knowledge base
const results = await searchKnowledgeBase('peptide benefits', { limit: 5 });
 
// Index content
await upsertArticleChunks(articleId, chunks);