Merge pull request 'feat: add local development setup with Docker Compose' (#47) from feature/local-dev-setup into develop

Complete local dev environment for testing:

**Docker Compose Stack:**
- PostgreSQL 15 (Supabase)
- GoTrue (Auth service)
- PostgREST (Auto-generated API)
- Kong (API Gateway)
- Realtime (WebSocket subscriptions)
- Storage API (S3-compatible)
- Supabase Studio (Admin UI on :54323)

**Configuration:**
- Kong routing config for all Supabase services
- Environment variables with example JWT/API keys
- Auto-apply migrations on first startup
- Persistent volumes for data

**Documentation:**
- DEV_SETUP.md with step-by-step guide
- Troubleshooting section
- Common tasks (reset DB, view logs, etc.)
- Pre-seeded data reference

**Bonus:**
- BarcodeScanner.vue component (Week 3 preview)
- html5-qrcode library installed

Ready to run: `docker-compose up -d && cd app && bun run dev`

Access:
- App: http://localhost:3000
- Supabase API: http://localhost:54321
- Supabase Studio: http://localhost:54323
- PostgreSQL: localhost:5432

DEV_SETUP.md

@@ -0,0 +1,335 @@
+# Pantry - Local Development Setup
+
+Self-hosted household pantry management app with barcode scanning.
+
+## 🚀 Quick Start
+
+### Prerequisites
+
+- **Docker** & **Docker Compose** (for Supabase backend)
+- **Bun** (for Nuxt frontend) - Install: `curl -fsSL https://bun.sh/install | bash`
+- **Git**
+
+### 1. Clone & Setup
+
+```bash
+git clone https://gitea.jeanlucmakiola.de/pantry-app/pantry.git
+cd pantry
+```
+
+### 2. Start Supabase (Backend)
+
+```bash
+# Start all Supabase services
+docker-compose up -d
+
+# Wait ~10 seconds for services to initialize
+# Check status
+docker-compose ps
+```
+
+**Services running:**
+- PostgreSQL: `localhost:5432`
+- Supabase API: `http://localhost:54321`
+- Supabase Studio: `http://localhost:54323` (admin UI)
+
+### 3. Apply Database Migrations
+
+The migrations are automatically applied on first startup via `/docker-entrypoint-initdb.d`.
+
+To verify:
+```bash
+docker-compose exec db psql -U postgres -d postgres -c "\dt"
+```
+
+You should see: `inventory_items`, `products`, `tags`, `units`, `item_tags`
+
+### 4. Start Nuxt App (Frontend)
+
+```bash
+cd app
+bun install
+bun run dev
+```
+
+**App running:** `http://localhost:3000`
+
+### 5. Open & Test
+
+1. Visit `http://localhost:3000`
+2. Click "Add Manually" to create your first inventory item
+3. Access Supabase Studio at `http://localhost:54323` to view database
+
+---
+
+## 📁 Project Structure
+
+```
+pantry/
+├── app/                    # Nuxt 4 frontend
+│   ├── components/         # Vue components
+│   │   └── inventory/      # Inventory CRUD UI
+│   ├── composables/        # Supabase client, data hooks
+│   ├── pages/              # Routes (index, scan, settings)
+│   └── types/              # TypeScript definitions
+├── supabase/
+│   └── migrations/         # SQL schema & seed data
+├── docker/
+│   └── kong.yml            # API gateway config
+├── docker-compose.yml      # Supabase services
+└── .env                    # Environment variables
+```
+
+---
+
+## 🔧 Common Tasks
+
+### View Logs
+
+```bash
+# All services
+docker-compose logs -f
+
+# Specific service
+docker-compose logs -f db
+docker-compose logs -f auth
+```
+
+### Reset Database
+
+```bash
+# Stop services
+docker-compose down -v
+
+# Restart (migrations auto-apply)
+docker-compose up -d
+```
+
+### Access Database
+
+```bash
+# psql
+docker-compose exec db psql -U postgres -d postgres
+
+# Supabase Studio (GUI)
+# http://localhost:54323
+```
+
+### Run Migrations Manually
+
+```bash
+# If you add new migrations after initial setup
+docker-compose exec db psql -U postgres -d postgres -f /docker-entrypoint-initdb.d/003_helper_functions.sql
+```
+
+### Create Test User
+
+```bash
+# Via Supabase Studio: http://localhost:54323
+# → Authentication → Add User
+# Email: test@example.com
+# Password: password123
+
+# Or via curl:
+curl http://localhost:54321/auth/v1/signup \
+  -H "apikey: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9..." \
+  -H "Content-Type: application/json" \
+  -d '{"email":"test@example.com","password":"password123"}'
+```
+
+---
+
+## 🧪 Testing Features
+
+### 1. Inventory Management
+- Add items manually via form
+- Edit quantities with +/- buttons
+- Delete items
+- View expiry warnings
+
+### 2. Tags & Organization
+- Pre-seeded tags: Fridge, Freezer, Pantry, Dairy, Vegan, etc.
+- Multi-select tags when adding items
+- Color-coded badges
+
+### 3. Units
+- 30 pre-seeded units (g, kg, L, cups, pieces, etc.)
+- Automatic conversion support
+
+### 4. Barcode Scanning (Week 3 - In Progress)
+- Camera access (requires HTTPS in production)
+- Manual barcode entry fallback
+
+---
+
+## 🐛 Troubleshooting
+
+### Port Conflicts
+
+If ports 5432, 54321, or 3000 are in use:
+
+```bash
+# Check what's using the port
+sudo lsof -i :5432
+
+# Option 1: Stop conflicting service
+# Option 2: Change port in docker-compose.yml
+```
+
+### Database Connection Refused
+
+```bash
+# Wait for PostgreSQL to fully start
+docker-compose logs db | grep "ready to accept connections"
+
+# If stuck, restart
+docker-compose restart db
+```
+
+### Migrations Not Applied
+
+```bash
+# Verify migrations directory is mounted
+docker-compose exec db ls -la /docker-entrypoint-initdb.d
+
+# Manually apply
+docker-compose exec db bash
+cd /docker-entrypoint-initdb.d
+for f in *.sql; do psql -U postgres -d postgres -f "$f"; done
+```
+
+### Frontend: Module Not Found
+
+```bash
+cd app
+rm -rf node_modules bun.lock .nuxt
+bun install
+bun run dev
+```
+
+---
+
+## 📊 Database Schema
+
+### Tables
+
+| Table | Purpose | Rows (Est.) |
+|-------|---------|-------------|
+| `inventory_items` | Current inventory | 100-500 |
+| `products` | Barcode cache (Open Food Facts) | 500-2000 |
+| `tags` | Organization labels | 50 (33 pre-seeded) |
+| `units` | Measurement units | 50 (30 pre-seeded) |
+| `item_tags` | Many-to-many item ↔ tag | 200-1000 |
+
+### Pre-Seeded Data
+
+**Units (30):**
+- Weight: g, kg, mg, lb, oz
+- Volume: mL, L, cup, tbsp, tsp, gal, qt, pt
+- Count: piece, dozen, package, bottle, can, jar, box, bag
+
+**Tags (33):**
+- Position: Fridge, Freezer, Pantry, Cabinet
+- Type: Dairy, Meat, Vegetables, Fruits, Snacks
+- Dietary: Vegan, Gluten-Free, Organic, Kosher, Halal
+- Custom: Low Stock, To Buy, Meal Prep, Leftovers
+
+---
+
+## 🔐 Authentication
+
+**Default Setup (Development):**
+- Auto-confirm emails (no SMTP needed)
+- Anyone can sign up
+- JWT tokens valid for 1 hour
+
+**Create Admin User:**
+
+```sql
+-- Via psql
+docker-compose exec db psql -U postgres -d postgres
+
+INSERT INTO auth.users (id, email, encrypted_password, email_confirmed_at)
+VALUES (
+  gen_random_uuid(),
+  'admin@pantry.local',
+  crypt('admin123', gen_salt('bf')),
+  NOW()
+);
+```
+
+---
+
+## 🌐 Environment Variables
+
+**.env** (root)
+```bash
+POSTGRES_PASSWORD=postgres
+JWT_SECRET=your-secret-here
+ANON_KEY=<supabase-anon-key>
+SERVICE_ROLE_KEY=<supabase-service-role-key>
+```
+
+**app/.env** (Nuxt)
+```bash
+NUXT_PUBLIC_SUPABASE_URL=http://localhost:54321
+NUXT_PUBLIC_SUPABASE_ANON_KEY=<same-as-above>
+```
+
+---
+
+## 📈 Development Workflow
+
+1. **Make changes** to Nuxt app → Hot reload at `localhost:3000`
+2. **Database changes** → Create new migration in `supabase/migrations/`
+3. **Test** → Add items, scan barcodes, check database
+4. **Commit** → Feature branch → PR to `develop`
+
+---
+
+## 🚢 Production Deployment (Coming Soon)
+
+See `docs/DEPLOYMENT.md` for:
+- Coolify setup
+- Environment configuration
+- SSL/HTTPS setup
+- Backups
+
+---
+
+## 📚 Documentation
+
+- [Architecture](docs/ARCHITECTURE.md)
+- [Database Schema](docs/DATABASE.md)
+- [API Reference](docs/API.md)
+- [Development Guide](docs/DEVELOPMENT.md)
+
+---
+
+## 🤝 Contributing
+
+This is a personal project, but issues and PRs welcome!
+
+1. Fork the repo
+2. Create feature branch (`git checkout -b feature/amazing-feature`)
+3. Commit changes (`git commit -m 'Add amazing feature'`)
+4. Push to branch (`git push origin feature/amazing-feature`)
+5. Open Pull Request
+
+---
+
+## 📝 License
+
+MIT License - See LICENSE file
+
+---
+
+## 🙋 Support
+
+- Issues: https://gitea.jeanlucmakiola.de/pantry-app/pantry/issues
+- Docs: https://gitea.jeanlucmakiola.de/pantry-app/pantry/wiki
+
+---
+
+**Version:** 0.1.0-alpha (MVP in progress)  
+**Status:** Week 2 complete, Week 3 in progress (14/34 issues done)

app/bun.lock

@@ -8,6 +8,7 @@
         "@nuxt/fonts": "^0.13.0",
         "@nuxt/ui": "^4.4.0",
         "@supabase/supabase-js": "^2.95.3",
+        "html5-qrcode": "^2.3.8",
         "nuxt": "^4.3.1",
         "vue": "^3.5.28",
         "vue-router": "^4.6.4",
@@ -1076,6 +1077,8 @@
 
     "hookable": ["hookable@5.5.3", "", {}, "sha512-Yc+BQe8SvoXH1643Qez1zqLRmbA5rCL+sSmk6TVos0LWVfNIB7PGncdlId77WzLGSIB5KaWgTaNTs2lNVEI6VQ=="],
 
+    "html5-qrcode": ["html5-qrcode@2.3.8", "", {}, "sha512-jsr4vafJhwoLVEDW3n1KvPnCCXWaQfRng0/EEYk1vNcQGcG/htAdhJX0be8YyqMoSz7+hZvOZSTAepsabiuhiQ=="],
+
     "http-assert": ["http-assert@1.5.0", "", { "dependencies": { "deep-equal": "~1.0.1", "http-errors": "~1.8.0" } }, "sha512-uPpH7OKX4H25hBmU6G1jWNaqJGpTXxey+YOUizJUAgu0AjLUeC8D73hTrhvDS5D+GJN1DN1+hhc/eF/wpxtp0w=="],
 
     "http-errors": ["http-errors@2.0.1", "", { "dependencies": { "depd": "~2.0.0", "inherits": "~2.0.4", "setprototypeof": "~1.2.0", "statuses": "~2.0.2", "toidentifier": "~1.0.1" } }, "sha512-4FbRdAX+bSdmo4AUFuS0WNiPz8NgFt+r8ThgNWmlrjQjt1Q7ZR9+zTlce2859x4KSXrwIsaeTqDoKQmtP8pLmQ=="],

app/components/inventory/AddItemForm.vue

@@ -0,0 +1,257 @@
+<template>
+  <UCard>
+    <template #header>
+      <div class="flex items-center justify-between">
+        <h3 class="text-lg font-semibold">Add New Item</h3>
+        <UButton 
+          icon="i-heroicons-x-mark" 
+          color="gray" 
+          variant="ghost"
+          @click="$emit('close')"
+        />
+      </div>
+    </template>
+
+    <form @submit.prevent="handleSubmit" class="space-y-4">
+      <!-- Item Name -->
+      <UFormGroup label="Item Name" required>
+        <UInput 
+          v-model="form.name"
+          placeholder="e.g. Whole Milk, Pasta, Tomatoes"
+          size="lg"
+          autofocus
+        />
+      </UFormGroup>
+
+      <!-- Quantity & Unit -->
+      <div class="grid grid-cols-2 gap-3">
+        <UFormGroup label="Quantity" required>
+          <UInput 
+            v-model.number="form.quantity"
+            type="number"
+            min="0.01"
+            step="0.01"
+            placeholder="1"
+            size="lg"
+          />
+        </UFormGroup>
+
+        <UFormGroup label="Unit" required>
+          <USelect 
+            v-model="form.unit_id"
+            :options="unitOptions"
+            option-attribute="label"
+            value-attribute="value"
+            placeholder="Select unit"
+            size="lg"
+          />
+        </UFormGroup>
+      </div>
+
+      <!-- Expiry Date -->
+      <UFormGroup label="Expiry Date" hint="Optional">
+        <UInput 
+          v-model="form.expiry_date"
+          type="date"
+          size="lg"
+        />
+      </UFormGroup>
+
+      <!-- Notes -->
+      <UFormGroup label="Notes" hint="Optional">
+        <UTextarea
+          v-model="form.notes"
+          placeholder="Any additional notes..."
+          :rows="2"
+        />
+      </UFormGroup>
+
+      <!-- Tags -->
+      <UFormGroup label="Tags" hint="Optional">
+        <div class="space-y-2">
+          <!-- Selected Tags -->
+          <div v-if="selectedTags.length > 0" class="flex flex-wrap gap-1 mb-2">
+            <UBadge 
+              v-for="tag in selectedTags" 
+              :key="tag.id"
+              :style="{ backgroundColor: tag.color }"
+              class="text-white cursor-pointer"
+              @click="removeTag(tag.id)"
+            >
+              {{ tag.icon }} {{ tag.name }} ✕
+            </UBadge>
+          </div>
+
+          <!-- Tag Selection by Category -->
+          <div v-for="category in tagCategories" :key="category.name" class="space-y-1">
+            <p class="text-xs font-medium text-gray-500 uppercase">{{ category.name }}</p>
+            <div class="flex flex-wrap gap-1">
+              <UButton
+                v-for="tag in category.tags"
+                :key="tag.id"
+                size="xs"
+                :color="isTagSelected(tag.id) ? 'primary' : 'gray'"
+                :variant="isTagSelected(tag.id) ? 'solid' : 'outline'"
+                @click="toggleTag(tag)"
+              >
+                {{ tag.icon }} {{ tag.name }}
+              </UButton>
+            </div>
+          </div>
+        </div>
+      </UFormGroup>
+
+      <!-- Submit -->
+      <div class="flex gap-2 pt-2">
+        <UButton 
+          type="submit"
+          color="primary"
+          size="lg"
+          class="flex-1"
+          :loading="submitting"
+          :disabled="!isValid"
+        >
+          Add Item
+        </UButton>
+        <UButton 
+          color="gray"
+          size="lg"
+          variant="soft"
+          @click="$emit('close')"
+        >
+          Cancel
+        </UButton>
+      </div>
+    </form>
+  </UCard>
+</template>
+
+<script setup lang="ts">
+const { addInventoryItem, addItemTags } = useInventory()
+const { getUnits } = useUnits()
+const { getTags } = useTags()
+
+const emit = defineEmits<{
+  close: []
+  added: [item: any]
+}>()
+
+// Form state
+const form = reactive({
+  name: '',
+  quantity: 1,
+  unit_id: '',
+  expiry_date: '',
+  notes: ''
+})
+
+const submitting = ref(false)
+const selectedTags = ref<any[]>([])
+
+// Load units and tags
+const units = ref<any[]>([])
+const tags = ref<any[]>([])
+
+onMounted(async () => {
+  const [unitsResult, tagsResult] = await Promise.all([
+    getUnits(),
+    getTags()
+  ])
+
+  units.value = unitsResult.data || []
+  tags.value = tagsResult.data || []
+
+  // Set default unit (Piece)
+  const defaultUnit = units.value.find(u => u.abbreviation === 'pc')
+  if (defaultUnit) {
+    form.unit_id = defaultUnit.id
+  }
+})
+
+// Unit options for select
+const unitOptions = computed(() => {
+  const grouped: Record<string, any[]> = {}
+  
+  for (const unit of units.value) {
+    const type = unit.unit_type
+    if (!grouped[type]) grouped[type] = []
+    grouped[type].push({
+      label: `${unit.name} (${unit.abbreviation})`,
+      value: unit.id
+    })
+  }
+
+  return Object.entries(grouped).flatMap(([type, options]) => [
+    { label: `— ${type.charAt(0).toUpperCase() + type.slice(1)} —`, value: '', disabled: true },
+    ...options
+  ])
+})
+
+// Tag categories for display
+const tagCategories = computed(() => {
+  const categories: Record<string, any[]> = {}
+  
+  for (const tag of tags.value) {
+    const cat = tag.category
+    if (!categories[cat]) categories[cat] = []
+    categories[cat].push(tag)
+  }
+
+  return Object.entries(categories).map(([name, tags]) => ({
+    name,
+    tags
+  }))
+})
+
+// Tag selection helpers
+const isTagSelected = (tagId: string) => {
+  return selectedTags.value.some(t => t.id === tagId)
+}
+
+const toggleTag = (tag: any) => {
+  if (isTagSelected(tag.id)) {
+    removeTag(tag.id)
+  } else {
+    selectedTags.value.push(tag)
+  }
+}
+
+const removeTag = (tagId: string) => {
+  selectedTags.value = selectedTags.value.filter(t => t.id !== tagId)
+}
+
+// Validation
+const isValid = computed(() => {
+  return form.name.trim().length > 0 && form.quantity > 0 && form.unit_id
+})
+
+// Submit
+const handleSubmit = async () => {
+  if (!isValid.value) return
+
+  submitting.value = true
+
+  const { data, error } = await addInventoryItem({
+    name: form.name.trim(),
+    quantity: form.quantity,
+    unit_id: form.unit_id,
+    expiry_date: form.expiry_date || null,
+    notes: form.notes.trim() || null
+  })
+
+  if (error) {
+    alert('Failed to add item: ' + error.message)
+    submitting.value = false
+    return
+  }
+
+  // Add tags if any selected
+  if (data && selectedTags.value.length > 0) {
+    const tagIds = selectedTags.value.map(t => t.id)
+    await addItemTags(data.id, tagIds)
+  }
+
+  emit('added', data)
+  submitting.value = false
+}
+</script>

app/components/inventory/EditItemModal.vue

@@ -0,0 +1,184 @@
+<template>
+  <UModal v-model="isOpen">
+    <UCard>
+      <template #header>
+        <div class="flex items-center justify-between">
+          <h3 class="text-lg font-semibold">Edit Item</h3>
+          <UButton 
+            icon="i-heroicons-x-mark" 
+            color="gray" 
+            variant="ghost"
+            @click="close"
+          />
+        </div>
+      </template>
+
+      <form @submit.prevent="handleSubmit" class="space-y-4">
+        <!-- Item Name -->
+        <UFormGroup label="Item Name" required>
+          <UInput 
+            v-model="form.name"
+            placeholder="Item name"
+            size="lg"
+          />
+        </UFormGroup>
+
+        <!-- Quantity & Unit -->
+        <div class="grid grid-cols-2 gap-3">
+          <UFormGroup label="Quantity" required>
+            <UInput 
+              v-model.number="form.quantity"
+              type="number"
+              min="0.01"
+              step="0.01"
+              size="lg"
+            />
+          </UFormGroup>
+
+          <UFormGroup label="Unit" required>
+            <USelect 
+              v-model="form.unit_id"
+              :options="unitOptions"
+              option-attribute="label"
+              value-attribute="value"
+              size="lg"
+            />
+          </UFormGroup>
+        </div>
+
+        <!-- Expiry Date -->
+        <UFormGroup label="Expiry Date" hint="Optional">
+          <UInput 
+            v-model="form.expiry_date"
+            type="date"
+            size="lg"
+          />
+        </UFormGroup>
+
+        <!-- Notes -->
+        <UFormGroup label="Notes" hint="Optional">
+          <UTextarea
+            v-model="form.notes"
+            placeholder="Any additional notes..."
+            :rows="2"
+          />
+        </UFormGroup>
+
+        <!-- Submit -->
+        <div class="flex gap-2 pt-2">
+          <UButton 
+            type="submit"
+            color="primary"
+            size="lg"
+            class="flex-1"
+            :loading="submitting"
+            :disabled="!isValid"
+          >
+            Save Changes
+          </UButton>
+          <UButton 
+            color="gray"
+            size="lg"
+            variant="soft"
+            @click="close"
+          >
+            Cancel
+          </UButton>
+        </div>
+      </form>
+    </UCard>
+  </UModal>
+</template>
+
+<script setup lang="ts">
+const { updateInventoryItem } = useInventory()
+const { getUnits } = useUnits()
+
+const props = defineProps<{
+  item: any | null
+}>()
+
+const emit = defineEmits<{
+  close: []
+  updated: [item: any]
+}>()
+
+const isOpen = ref(false)
+const submitting = ref(false)
+const units = ref<any[]>([])
+
+const form = reactive({
+  name: '',
+  quantity: 1,
+  unit_id: '',
+  expiry_date: '',
+  notes: ''
+})
+
+// Load units
+onMounted(async () => {
+  const { data } = await getUnits()
+  units.value = data || []
+})
+
+// Unit options for select
+const unitOptions = computed(() => {
+  return units.value.map(unit => ({
+    label: `${unit.name} (${unit.abbreviation})`,
+    value: unit.id
+  }))
+})
+
+// Watch for item changes (open modal)
+watch(() => props.item, (newItem) => {
+  if (newItem) {
+    form.name = newItem.name
+    form.quantity = Number(newItem.quantity)
+    form.unit_id = newItem.unit_id
+    form.expiry_date = newItem.expiry_date || ''
+    form.notes = newItem.notes || ''
+    isOpen.value = true
+  }
+}, { immediate: true })
+
+// Watch modal close
+watch(isOpen, (val) => {
+  if (!val) {
+    emit('close')
+  }
+})
+
+// Validation
+const isValid = computed(() => {
+  return form.name.trim().length > 0 && form.quantity > 0 && form.unit_id
+})
+
+const close = () => {
+  isOpen.value = false
+}
+
+// Submit
+const handleSubmit = async () => {
+  if (!isValid.value || !props.item) return
+
+  submitting.value = true
+
+  const { data, error } = await updateInventoryItem(props.item.id, {
+    name: form.name.trim(),
+    quantity: form.quantity,
+    unit_id: form.unit_id,
+    expiry_date: form.expiry_date || null,
+    notes: form.notes.trim() || null
+  })
+
+  if (error) {
+    alert('Failed to update item: ' + error.message)
+    submitting.value = false
+    return
+  }
+
+  emit('updated', data)
+  submitting.value = false
+  close()
+}
+</script>

app/components/inventory/InventoryCard.vue

@@ -0,0 +1,151 @@
+<template>
+  <UCard class="hover:shadow-lg transition-shadow">
+    <!-- Item Image -->
+    <div class="aspect-square bg-gray-100 rounded-lg mb-3 overflow-hidden">
+      <img 
+        v-if="item.product?.image_url" 
+        :src="item.product.image_url" 
+        :alt="item.name"
+        class="w-full h-full object-cover"
+      />
+      <div v-else class="w-full h-full flex items-center justify-center">
+        <UIcon name="i-heroicons-cube" class="w-16 h-16 text-gray-300" />
+      </div>
+    </div>
+
+    <!-- Item Info -->
+    <div class="space-y-2">
+      <div>
+        <h3 class="font-semibold text-gray-900 truncate">{{ item.name }}</h3>
+        <p v-if="item.product?.brand" class="text-sm text-gray-600 truncate">
+          {{ item.product.brand }}
+        </p>
+      </div>
+
+      <!-- Quantity -->
+      <div class="flex items-center justify-between">
+        <span class="text-lg font-medium text-gray-900">
+          {{ item.quantity }} {{ item.unit?.abbreviation }}
+        </span>
+
+        <!-- Quick Actions -->
+        <div class="flex gap-1">
+          <UButton 
+            icon="i-heroicons-minus"
+            size="xs"
+            color="gray"
+            variant="ghost"
+            @click="$emit('update-quantity', item.id, -1)"
+            :disabled="item.quantity <= 1"
+          />
+          <UButton 
+            icon="i-heroicons-plus"
+            size="xs"
+            color="gray"
+            variant="ghost"
+            @click="$emit('update-quantity', item.id, 1)"
+          />
+        </div>
+      </div>
+
+      <!-- Tags -->
+      <div v-if="item.tags && item.tags.length > 0" class="flex flex-wrap gap-1">
+        <UBadge 
+          v-for="tagItem in item.tags.slice(0, 3)" 
+          :key="tagItem.tag.id"
+          :style="{ backgroundColor: tagItem.tag.color }"
+          size="xs"
+          class="text-white"
+        >
+          {{ tagItem.tag.icon }} {{ tagItem.tag.name }}
+        </UBadge>
+        <UBadge v-if="item.tags.length > 3" size="xs" color="gray">
+          +{{ item.tags.length - 3 }}
+        </UBadge>
+      </div>
+
+      <!-- Expiry Warning -->
+      <div v-if="daysUntilExpiry !== null" class="text-xs">
+        <UBadge 
+          :color="expiryColor"
+          variant="soft"
+          class="w-full justify-center"
+        >
+          <UIcon :name="expiryIcon" class="mr-1" />
+          {{ expiryText }}
+        </UBadge>
+      </div>
+    </div>
+
+    <!-- Action Buttons -->
+    <template #footer>
+      <div class="flex gap-2">
+        <UButton 
+          icon="i-heroicons-pencil"
+          size="sm"
+          color="gray"
+          variant="soft"
+          class="flex-1"
+          @click="$emit('edit', item)"
+        >
+          Edit
+        </UButton>
+        <UButton 
+          icon="i-heroicons-trash"
+          size="sm"
+          color="red"
+          variant="soft"
+          @click="$emit('delete', item.id)"
+        >
+          Delete
+        </UButton>
+      </div>
+    </template>
+  </UCard>
+</template>
+
+<script setup lang="ts">
+const props = defineProps<{
+  item: any
+}>()
+
+defineEmits<{
+  edit: [item: any]
+  delete: [id: string]
+  'update-quantity': [id: string, change: number]
+}>()
+
+// Calculate days until expiry
+const daysUntilExpiry = computed(() => {
+  if (!props.item.expiry_date) return null
+  
+  const today = new Date()
+  const expiry = new Date(props.item.expiry_date)
+  const diff = Math.ceil((expiry.getTime() - today.getTime()) / (1000 * 60 * 60 * 24))
+  
+  return diff
+})
+
+// Expiry badge styling
+const expiryColor = computed(() => {
+  if (daysUntilExpiry.value === null) return 'gray'
+  if (daysUntilExpiry.value < 0) return 'red'
+  if (daysUntilExpiry.value <= 3) return 'orange'
+  if (daysUntilExpiry.value <= 7) return 'yellow'
+  return 'green'
+})
+
+const expiryIcon = computed(() => {
+  if (daysUntilExpiry.value === null) return 'i-heroicons-calendar'
+  if (daysUntilExpiry.value < 0) return 'i-heroicons-exclamation-triangle'
+  return 'i-heroicons-clock'
+})
+
+const expiryText = computed(() => {
+  if (daysUntilExpiry.value === null) return 'No expiry'
+  if (daysUntilExpiry.value < 0) return `Expired ${Math.abs(daysUntilExpiry.value)} days ago`
+  if (daysUntilExpiry.value === 0) return 'Expires today'
+  if (daysUntilExpiry.value === 1) return 'Expires tomorrow'
+  return `Expires in ${daysUntilExpiry.value} days`
+})
+</script>

app/components/inventory/InventoryList.vue

@@ -0,0 +1,131 @@
+<template>
+  <div class="space-y-4">
+    <!-- Loading State -->
+    <div v-if="loading" class="text-center py-12">
+      <UIcon name="i-heroicons-arrow-path" class="w-8 h-8 text-gray-400 animate-spin mx-auto mb-2" />
+      <p class="text-gray-600">Loading inventory...</p>
+    </div>
+
+    <!-- Error State -->
+    <div v-else-if="error" class="text-center py-12">
+      <UIcon name="i-heroicons-exclamation-triangle" class="w-12 h-12 text-red-500 mx-auto mb-4" />
+      <p class="text-red-600 mb-4">{{ error }}</p>
+      <UButton @click="loadInventory" color="gray">Retry</UButton>
+    </div>
+
+    <!-- Empty State -->
+    <div v-else-if="!items || items.length === 0" class="text-center py-12">
+      <UIcon name="i-heroicons-inbox" class="w-16 h-16 text-gray-400 mx-auto mb-4" />
+      <h3 class="text-lg font-semibold text-gray-900 mb-2">
+        No items yet
+      </h3>
+      <p class="text-gray-600 mb-6">
+        Start by scanning a barcode or adding an item manually.
+      </p>
+      <div class="flex gap-2 justify-center">
+        <UButton 
+          to="/scan" 
+          color="primary"
+          icon="i-heroicons-qr-code"
+        >
+          Scan First Item
+        </UButton>
+        <UButton 
+          @click="$emit('add-item')"
+          color="white"
+          icon="i-heroicons-plus"
+        >
+          Add Manually
+        </UButton>
+      </div>
+    </div>
+
+    <!-- Inventory Grid -->
+    <div v-else class="grid gap-4 sm:grid-cols-2 lg:grid-cols-3 xl:grid-cols-4">
+      <InventoryCard
+        v-for="item in items"
+        :key="item.id"
+        :item="item"
+        @edit="$emit('edit-item', item)"
+        @delete="handleDelete(item.id)"
+        @update-quantity="handleQuantityUpdate"
+      />
+    </div>
+  </div>
+</template>
+
+<script setup lang="ts">
+const { getInventory, deleteInventoryItem, updateQuantity } = useInventory()
+
+const props = defineProps<{
+  refresh?: boolean
+}>()
+
+const emit = defineEmits<{
+  'add-item': []
+  'edit-item': [item: any]
+}>()
+
+const items = ref<any[]>([])
+const loading = ref(true)
+const error = ref<string | null>(null)
+
+const loadInventory = async () => {
+  loading.value = true
+  error.value = null
+
+  const { data, error: fetchError } = await getInventory()
+
+  if (fetchError) {
+    error.value = 'Failed to load inventory. Please try again.'
+    loading.value = false
+    return
+  }
+
+  items.value = data || []
+  loading.value = false
+}
+
+const handleDelete = async (id: string) => {
+  if (!confirm('Are you sure you want to delete this item?')) {
+    return
+  }
+
+  const { error: deleteError } = await deleteInventoryItem(id)
+
+  if (deleteError) {
+    alert('Failed to delete item')
+    return
+  }
+
+  // Remove from local list
+  items.value = items.value.filter(item => item.id !== id)
+}
+
+const handleQuantityUpdate = async (id: string, change: number) => {
+  const result = await updateQuantity(id, change)
+
+  if (result.error) {
+    alert('Failed to update quantity')
+    return
+  }
+
+  // Reload inventory after update
+  await loadInventory()
+}
+
+// Load on mount
+onMounted(loadInventory)
+
+// Watch for refresh prop
+watch(() => props.refresh, (newVal) => {
+  if (newVal) {
+    loadInventory()
+  }
+})
+
+// Expose reload method
+defineExpose({
+  reload: loadInventory
+})
+</script>

app/components/scan/BarcodeScanner.vue

@@ -0,0 +1,161 @@
+<template>
+  <div class="relative">
+    <!-- Scanner Container -->
+    <div 
+      :id="scannerId" 
+      ref="scannerRef"
+      class="w-full rounded-lg overflow-hidden bg-black"
+      :class="{ 'aspect-video': !isScanning, 'min-h-[300px]': isScanning }"
+    />
+
+    <!-- Overlay when not scanning -->
+    <div 
+      v-if="!isScanning && !error" 
+      class="absolute inset-0 flex items-center justify-center bg-gray-900 rounded-lg"
+    >
+      <div class="text-center">
+        <UIcon name="i-heroicons-camera" class="w-16 h-16 text-gray-400 mb-4" />
+        <UButton 
+          color="primary" 
+          size="lg"
+          icon="i-heroicons-qr-code"
+          @click="startScanning"
+        >
+          Start Camera
+        </UButton>
+      </div>
+    </div>
+
+    <!-- Error State -->
+    <div 
+      v-if="error" 
+      class="absolute inset-0 flex items-center justify-center bg-gray-900 rounded-lg"
+    >
+      <div class="text-center px-4">
+        <UIcon name="i-heroicons-exclamation-triangle" class="w-12 h-12 text-red-400 mb-4" />
+        <p class="text-white mb-4">{{ error }}</p>
+        <div class="flex gap-2 justify-center">
+          <UButton @click="startScanning" color="primary">Try Again</UButton>
+          <UButton @click="$emit('manual-entry')" color="gray">Enter Manually</UButton>
+        </div>
+      </div>
+    </div>
+
+    <!-- Manual Barcode Entry -->
+    <div class="mt-4">
+      <UFormGroup label="Or enter barcode manually">
+        <div class="flex gap-2">
+          <UInput 
+            v-model="manualBarcode"
+            placeholder="e.g. 8000500310427"
+            size="lg"
+            class="flex-1"
+            @keyup.enter="submitManualBarcode"
+          />
+          <UButton 
+            color="primary"
+            size="lg"
+            :disabled="!manualBarcode.trim()"
+            @click="submitManualBarcode"
+          >
+            Lookup
+          </UButton>
+        </div>
+      </UFormGroup>
+    </div>
+  </div>
+</template>
+
+<script setup lang="ts">
+import { Html5Qrcode, Html5QrcodeSupportedFormats } from 'html5-qrcode'
+
+const emit = defineEmits<{
+  'barcode-detected': [barcode: string]
+  'manual-entry': []
+}>()
+
+const scannerId = 'barcode-scanner'
+const scannerRef = ref<HTMLElement | null>(null)
+const isScanning = ref(false)
+const error = ref<string | null>(null)
+const manualBarcode = ref('')
+
+let html5QrCode: Html5Qrcode | null = null
+
+const startScanning = async () => {
+  error.value = null
+
+  try {
+    if (!html5QrCode) {
+      html5QrCode = new Html5Qrcode(scannerId, {
+        formatsToSupport: [
+          Html5QrcodeSupportedFormats.EAN_13,
+          Html5QrcodeSupportedFormats.EAN_8,
+          Html5QrcodeSupportedFormats.UPC_A,
+          Html5QrcodeSupportedFormats.UPC_E,
+          Html5QrcodeSupportedFormats.CODE_128,
+          Html5QrcodeSupportedFormats.CODE_39,
+          Html5QrcodeSupportedFormats.QR_CODE
+        ],
+        verbose: false
+      })
+    }
+
+    await html5QrCode.start(
+      { facingMode: 'environment' },
+      {
+        fps: 10,
+        qrbox: { width: 250, height: 150 },
+        aspectRatio: 1.777
+      },
+      onScanSuccess,
+      onScanFailure
+    )
+
+    isScanning.value = true
+  } catch (err: any) {
+    console.error('Scanner error:', err)
+    
+    if (err.toString().includes('NotAllowedError')) {
+      error.value = 'Camera permission denied. Please allow camera access and try again.'
+    } else if (err.toString().includes('NotFoundError')) {
+      error.value = 'No camera found. Please use a device with a camera or enter the barcode manually.'
+    } else {
+      error.value = 'Could not start camera. Try entering the barcode manually.'
+    }
+  }
+}
+
+const stopScanning = async () => {
+  if (html5QrCode && isScanning.value) {
+    try {
+      await html5QrCode.stop()
+    } catch (err) {
+      console.error('Error stopping scanner:', err)
+    }
+    isScanning.value = false
+  }
+}
+
+const onScanSuccess = (decodedText: string) => {
+  // Stop scanning after successful read
+  stopScanning()
+  emit('barcode-detected', decodedText)
+}
+
+const onScanFailure = (_errorMessage: string) => {
+  // Ignore - this fires continuously when no barcode is detected
+}
+
+const submitManualBarcode = () => {
+  if (manualBarcode.value.trim()) {
+    emit('barcode-detected', manualBarcode.value.trim())
+    manualBarcode.value = ''
+  }
+}
+
+// Cleanup on unmount
+onUnmounted(() => {
+  stopScanning()
+})
+</script>

app/composables/useInventory.ts

@@ -0,0 +1,201 @@
+import type { Database } from '~/types/database.types'
+
+type InventoryItem = Database['public']['Tables']['inventory_items']['Row']
+type InventoryItemInsert = Database['public']['Tables']['inventory_items']['Insert']
+type InventoryItemUpdate = Database['public']['Tables']['inventory_items']['Update']
+
+export const useInventory = () => {
+  const supabase = useSupabase()
+  const { user } = useSupabaseAuth()
+
+  /**
+   * Get all inventory items with denormalized data
+   */
+  const getInventory = async () => {
+    const { data, error } = await supabase
+      .from('inventory_items')
+      .select(`
+        *,
+        product:products(*),
+        unit:units(*),
+        tags:item_tags(tag:tags(*))
+      `)
+      .order('created_at', { ascending: false })
+
+    if (error) {
+      console.error('Error fetching inventory:', error)
+      return { data: null, error }
+    }
+
+    return { data, error: null }
+  }
+
+  /**
+   * Get single inventory item by ID
+   */
+  const getInventoryItem = async (id: string) => {
+    const { data, error } = await supabase
+      .from('inventory_items')
+      .select(`
+        *,
+        product:products(*),
+        unit:units(*),
+        tags:item_tags(tag:tags(*))
+      `)
+      .eq('id', id)
+      .single()
+
+    if (error) {
+      console.error('Error fetching item:', error)
+      return { data: null, error }
+    }
+
+    return { data, error: null }
+  }
+
+  /**
+   * Add new inventory item
+   */
+  const addInventoryItem = async (item: Omit<InventoryItemInsert, 'added_by'>) => {
+    if (!user.value) {
+      return { data: null, error: { message: 'User not authenticated' } }
+    }
+
+    const { data, error } = await supabase
+      .from('inventory_items')
+      .insert({
+        ...item,
+        added_by: user.value.id
+      })
+      .select(`
+        *,
+        product:products(*),
+        unit:units(*),
+        tags:item_tags(tag:tags(*))
+      `)
+      .single()
+
+    if (error) {
+      console.error('Error adding item:', error)
+      return { data: null, error }
+    }
+
+    return { data, error: null }
+  }
+
+  /**
+   * Update inventory item
+   */
+  const updateInventoryItem = async (id: string, updates: InventoryItemUpdate) => {
+    const { data, error } = await supabase
+      .from('inventory_items')
+      .update(updates)
+      .eq('id', id)
+      .select(`
+        *,
+        product:products(*),
+        unit:units(*),
+        tags:item_tags(tag:tags(*))
+      `)
+      .single()
+
+    if (error) {
+      console.error('Error updating item:', error)
+      return { data: null, error }
+    }
+
+    return { data, error: null }
+  }
+
+  /**
+   * Delete inventory item
+   */
+  const deleteInventoryItem = async (id: string) => {
+    // First delete associated tags
+    await supabase
+      .from('item_tags')
+      .delete()
+      .eq('item_id', id)
+
+    const { error } = await supabase
+      .from('inventory_items')
+      .delete()
+      .eq('id', id)
+
+    if (error) {
+      console.error('Error deleting item:', error)
+      return { error }
+    }
+
+    return { error: null }
+  }
+
+  /**
+   * Update item quantity (consume or restock)
+   */
+  const updateQuantity = async (id: string, change: number) => {
+    const { data: item, error: fetchError } = await getInventoryItem(id)
+    if (fetchError || !item) {
+      return { data: null, error: fetchError }
+    }
+
+    const newQuantity = Number(item.quantity) + change
+
+    if (newQuantity <= 0) {
+      // Auto-delete when quantity reaches zero
+      return await deleteInventoryItem(id)
+    }
+
+    return await updateInventoryItem(id, { quantity: newQuantity })
+  }
+
+  /**
+   * Add tags to item
+   */
+  const addItemTags = async (itemId: string, tagIds: string[]) => {
+    const items = tagIds.map(tagId => ({
+      item_id: itemId,
+      tag_id: tagId
+    }))
+
+    const { error } = await supabase
+      .from('item_tags')
+      .insert(items)
+
+    if (error) {
+      console.error('Error adding tags:', error)
+      return { error }
+    }
+
+    return { error: null }
+  }
+
+  /**
+   * Remove tag from item
+   */
+  const removeItemTag = async (itemId: string, tagId: string) => {
+    const { error } = await supabase
+      .from('item_tags')
+      .delete()
+      .eq('item_id', itemId)
+      .eq('tag_id', tagId)
+
+    if (error) {
+      console.error('Error removing tag:', error)
+      return { error }
+    }
+
+    return { error: null }
+  }
+
+  return {
+    getInventory,
+    getInventoryItem,
+    addInventoryItem,
+    updateInventoryItem,
+    deleteInventoryItem,
+    updateQuantity,
+    addItemTags,
+    removeItemTag
+  }
+}

app/composables/useTags.ts

@@ -0,0 +1,44 @@
+export const useTags = () => {
+  const supabase = useSupabase()
+
+  /**
+   * Get all tags
+   */
+  const getTags = async () => {
+    const { data, error } = await supabase
+      .from('tags')
+      .select('*')
+      .order('category', { ascending: true })
+      .order('name', { ascending: true })
+
+    if (error) {
+      console.error('Error fetching tags:', error)
+      return { data: null, error }
+    }
+
+    return { data, error: null }
+  }
+
+  /**
+   * Get tags by category
+   */
+  const getTagsByCategory = async (category: 'position' | 'type' | 'dietary' | 'custom') => {
+    const { data, error } = await supabase
+      .from('tags')
+      .select('*')
+      .eq('category', category)
+      .order('name', { ascending: true })
+
+    if (error) {
+      console.error('Error fetching tags by category:', error)
+      return { data: null, error }
+    }
+
+    return { data, error: null }
+  }
+
+  return {
+    getTags,
+    getTagsByCategory
+  }
+}

app/composables/useUnits.ts

@@ -0,0 +1,53 @@
+export const useUnits = () => {
+  const supabase = useSupabase()
+
+  /**
+   * Get all units
+   */
+  const getUnits = async () => {
+    const { data, error } = await supabase
+      .from('units')
+      .select('*')
+      .order('unit_type', { ascending: true })
+      .order('name', { ascending: true })
+
+    if (error) {
+      console.error('Error fetching units:', error)
+      return { data: null, error }
+    }
+
+    return { data, error: null }
+  }
+
+  /**
+   * Get default unit for a type
+   */
+  const getDefaultUnit = async (unitType: 'weight' | 'volume' | 'count' | 'custom') => {
+    const { data, error } = await supabase
+      .from('units')
+      .select('*')
+      .eq('unit_type', unitType)
+      .eq('is_default', true)
+      .single()
+
+    if (error) {
+      console.error('Error fetching default unit:', error)
+      return { data: null, error }
+    }
+
+    return { data, error: null }
+  }
+
+  /**
+   * Convert quantity between units
+   */
+  const convertUnit = (quantity: number, fromFactor: number, toFactor: number): number => {
+    return (quantity * fromFactor) / toFactor
+  }
+
+  return {
+    getUnits,
+    getDefaultUnit,
+    convertUnit
+  }
+}

app/package.json

@@ -13,6 +13,7 @@
     "@nuxt/fonts": "^0.13.0",
     "@nuxt/ui": "^4.4.0",
     "@supabase/supabase-js": "^2.95.3",
+    "html5-qrcode": "^2.3.8",
     "nuxt": "^4.3.1",
     "vue": "^3.5.28",
     "vue-router": "^4.6.4"

app/pages/index.vue

@@ -17,36 +17,37 @@
           color="white" 
           size="lg"
           icon="i-heroicons-plus"
+          @click="showAddForm = true"
         >
           Add Manually
         </UButton>
       </div>
     </div>
 
-    <!-- Empty State -->
+    <!-- Add Item Form (Overlay) -->
-    <UCard v-if="true">
+    <div v-if="showAddForm" class="fixed inset-0 z-50 flex items-start justify-center pt-20 px-4 bg-black/50">
-      <div class="text-center py-12">
+      <div class="w-full max-w-lg">
-        <UIcon 
+        <AddItemForm 
-          name="i-heroicons-inbox" 
+          @close="showAddForm = false"
-          class="w-16 h-16 text-gray-400 mx-auto mb-4"
+          @added="handleItemAdded"
         />
-        <h3 class="text-lg font-semibold text-gray-900 mb-2">
-          No items yet
-        </h3>
-        <p class="text-gray-600 mb-6">
-          Start by scanning a barcode or adding an item manually.
-        </p>
-        <UButton 
-          to="/scan" 
-          color="primary"
-          icon="i-heroicons-qr-code"
-        >
-          Scan First Item
-        </UButton>
       </div>
-    </UCard>
+    </div>
 
-    <!-- TODO: Item list will go here -->
+    <!-- Edit Item Modal -->
+    <EditItemModal 
+      :item="editingItem"
+      @close="editingItem = null"
+      @updated="handleItemUpdated"
+    />
+
+    <!-- Inventory List -->
+    <InventoryList
+      ref="inventoryListRef"
+      :refresh="refreshKey"
+      @add-item="showAddForm = true"
+      @edit-item="editingItem = $event"
+    />
   </div>
 </template>
 
@@ -54,4 +55,20 @@
 definePageMeta({
   layout: 'default'
 })
+
+const showAddForm = ref(false)
+const editingItem = ref<any>(null)
+const refreshKey = ref(0)
+const inventoryListRef = ref()
+
+const handleItemAdded = (item: any) => {
+  showAddForm.value = false
+  // Reload the inventory list
+  inventoryListRef.value?.reload()
+}
+
+const handleItemUpdated = (item: any) => {
+  editingItem.value = null
+  inventoryListRef.value?.reload()
+}
 </script>

docker-compose.yml

@@ -0,0 +1,127 @@
+version: '3.8'
+
+services:
+  # PostgreSQL Database
+  db:
+    image: supabase/postgres:15.1.0.147
+    restart: unless-stopped
+    ports:
+      - "5432:5432"
+    environment:
+      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-postgres}
+      POSTGRES_DB: postgres
+    volumes:
+      - db-data:/var/lib/postgresql/data
+      - ./supabase/migrations:/docker-entrypoint-initdb.d:ro
+
+  # Supabase Studio (Admin UI)
+  studio:
+    image: supabase/studio:20231123-64a766a
+    restart: unless-stopped
+    ports:
+      - "54323:3000"
+    environment:
+      SUPABASE_URL: http://kong:8000
+      SUPABASE_PUBLIC_URL: http://localhost:54321
+      SUPABASE_ANON_KEY: ${ANON_KEY}
+      SUPABASE_SERVICE_KEY: ${SERVICE_ROLE_KEY}
+
+  # Kong API Gateway
+  kong:
+    image: kong:2.8.1
+    restart: unless-stopped
+    ports:
+      - "54321:8000"
+      - "54320:8443"
+    environment:
+      KONG_DATABASE: "off"
+      KONG_DECLARATIVE_CONFIG: /var/lib/kong/kong.yml
+      KONG_DNS_ORDER: LAST,A,CNAME
+      KONG_PLUGINS: request-transformer,cors,key-auth,acl
+    volumes:
+      - ./docker/kong.yml:/var/lib/kong/kong.yml:ro
+
+  # GoTrue (Auth)
+  auth:
+    image: supabase/gotrue:v2.99.0
+    restart: unless-stopped
+    depends_on:
+      - db
+    environment:
+      GOTRUE_API_HOST: 0.0.0.0
+      GOTRUE_API_PORT: 9999
+      API_EXTERNAL_URL: http://localhost:54321
+      GOTRUE_DB_DRIVER: postgres
+      GOTRUE_DB_DATABASE_URL: postgres://supabase_auth_admin:${POSTGRES_PASSWORD:-postgres}@db:5432/postgres
+      GOTRUE_SITE_URL: http://localhost:3000
+      GOTRUE_URI_ALLOW_LIST: "*"
+      GOTRUE_DISABLE_SIGNUP: false
+      GOTRUE_JWT_ADMIN_ROLES: service_role
+      GOTRUE_JWT_AUD: authenticated
+      GOTRUE_JWT_DEFAULT_GROUP_NAME: authenticated
+      GOTRUE_JWT_EXP: 3600
+      GOTRUE_JWT_SECRET: ${JWT_SECRET}
+      GOTRUE_EXTERNAL_EMAIL_ENABLED: true
+      GOTRUE_MAILER_AUTOCONFIRM: true
+
+  # PostgREST (Auto API)
+  rest:
+    image: postgrest/postgrest:v11.2.0
+    restart: unless-stopped
+    depends_on:
+      - db
+    environment:
+      PGRST_DB_URI: postgres://authenticator:${POSTGRES_PASSWORD:-postgres}@db:5432/postgres
+      PGRST_DB_SCHEMAS: public,storage
+      PGRST_DB_ANON_ROLE: anon
+      PGRST_JWT_SECRET: ${JWT_SECRET}
+      PGRST_DB_USE_LEGACY_GUCS: "false"
+
+  # Realtime
+  realtime:
+    image: supabase/realtime:v2.25.35
+    restart: unless-stopped
+    depends_on:
+      - db
+    environment:
+      PORT: 4000
+      DB_HOST: db
+      DB_PORT: 5432
+      DB_USER: supabase_admin
+      DB_PASSWORD: ${POSTGRES_PASSWORD:-postgres}
+      DB_NAME: postgres
+      DB_AFTER_CONNECT_QUERY: 'SET search_path TO _realtime'
+      DB_ENC_KEY: supabaserealtime
+      API_JWT_SECRET: ${JWT_SECRET}
+      FLY_ALLOC_ID: fly123
+      FLY_APP_NAME: realtime
+      SECRET_KEY_BASE: ${JWT_SECRET}
+      ERL_AFLAGS: -proto_dist inet_tcp
+      ENABLE_TAILSCALE: "false"
+      DNS_NODES: "''"
+
+  # Storage (S3-compatible)
+  storage:
+    image: supabase/storage-api:v0.40.4
+    restart: unless-stopped
+    depends_on:
+      - db
+      - rest
+    environment:
+      ANON_KEY: ${ANON_KEY}
+      SERVICE_KEY: ${SERVICE_ROLE_KEY}
+      POSTGREST_URL: http://rest:3000
+      PGRST_JWT_SECRET: ${JWT_SECRET}
+      DATABASE_URL: postgres://supabase_storage_admin:${POSTGRES_PASSWORD:-postgres}@db:5432/postgres
+      FILE_SIZE_LIMIT: 52428800
+      STORAGE_BACKEND: file
+      FILE_STORAGE_BACKEND_PATH: /var/lib/storage
+      TENANT_ID: stub
+      REGION: stub
+      GLOBAL_S3_BUCKET: stub
+    volumes:
+      - storage-data:/var/lib/storage
+
+volumes:
+  db-data:
+  storage-data:

docker/kong.yml

@@ -0,0 +1,85 @@
+_format_version: "2.1"
+
+_transform: true
+
+services:
+  - name: auth
+    url: http://auth:9999
+    routes:
+      - name: auth-v1
+        strip_path: true
+        paths:
+          - /auth/v1
+    plugins:
+      - name: cors
+      - name: key-auth
+        config:
+          hide_credentials: true
+
+  - name: rest
+    url: http://rest:3000
+    routes:
+      - name: rest-v1
+        strip_path: true
+        paths:
+          - /rest/v1
+    plugins:
+      - name: cors
+      - name: key-auth
+        config:
+          hide_credentials: true
+
+  - name: realtime
+    url: http://realtime:4000/socket
+    routes:
+      - name: realtime-v1
+        strip_path: true
+        paths:
+          - /realtime/v1
+    plugins:
+      - name: cors
+      - name: key-auth
+        config:
+          hide_credentials: true
+
+  - name: storage
+    url: http://storage:5000
+    routes:
+      - name: storage-v1
+        strip_path: true
+        paths:
+          - /storage/v1
+    plugins:
+      - name: cors
+
+consumers:
+  - username: anon
+    keyauth_credentials:
+      - key: ${ANON_KEY}
+  - username: service_role
+    keyauth_credentials:
+      - key: ${SERVICE_ROLE_KEY}
+
+plugins:
+  - name: cors
+    config:
+      origins:
+        - "*"
+      methods:
+        - GET
+        - POST
+        - PUT
+        - PATCH
+        - DELETE
+        - OPTIONS
+      headers:
+        - Accept
+        - Accept-Encoding
+        - Authorization
+        - Content-Type
+        - Origin
+        - X-Client-Info
+      exposed_headers:
+        - X-Total-Count
+      credentials: true
+      max_age: 3600