# Supabase — Build a Personalized AI Assistant with Postgres

- Company: Supabase (supabase.com)
- Announced: 2025-06-25
- Category: not stated
- Coverage: not counted
- Announcement: no
- Group: routine
- Source: https://supabase.com/blog/natural-db
- Record: https://forck.live/items/21354-build-a-personalized-ai-assistant-with-postgres
- Subject: Supabase

Supabase's guide explains how to build a personalized AI assistant using Postgres, combining an LLM-controlled database schema, scheduled tasks via pg_cron, web search, and Zapier MCP integrations for long-term memory and autonomous actions. The system stores structured data in a dedicated memories schema with restricted permissions, uses three memory types (message history, semantic vector search, and structured SQL), and supports evolving user preferences through a self-evolving system prompt.

## Evidence

Verbatim from https://supabase.com/blog/natural-db:

> The assistant uses a dedicated Postgres schema called memories to store all of its structured data. To ensure security, the LLM operates under a specific role, memories_role , which is granted permissions only within this schema.

---

Record: https://forck.live/items/21354-build-a-personalized-ai-assistant-with-postgres
Catalogue: https://forck.live/llms.txt
Current issue: https://forck.live/feed.md