clawdbot-memory-supabase

A Clawdbot plugin that logs every conversation to Supabase/PostgreSQL. Never forget anything.

What it does

• 📝 Logs every message (user + assistant) with timestamps
• 🔍 Query by date: "What did we talk about on January 15th?"
• 📅 Query by range: "What did we discuss last week?"
• 🔎 Search by keyword across all history
• 🐘 Elephant memory — complete conversation recall

Quick Start

1. Set up Supabase

Local (recommended for development):

# Install Supabase CLI
brew install supabase/tap/supabase

# In your project directory
supabase init
supabase start

Or use Supabase Cloud: Create a project at supabase.com

2. Run migrations

Copy the migrations/ folder to your Supabase project:

cp -r migrations/ your-project/supabase/migrations/
cd your-project
supabase db reset  # Local
# or
supabase db push   # Cloud

3. Install the plugin

Option A: Copy to extensions folder

cp -r plugin/ ~/.clawdbot/extensions/memory-supabase/
# or for workspace-specific:
cp -r plugin/ your-workspace/.clawdbot/extensions/memory-supabase/

Option B: Install from npm (coming soon)

clawdbot plugins install @arephan/clawdbot-memory-supabase

4. Configure Clawdbot

Add to your clawdbot.json:

{
  "plugins": {
    "slots": {
      "memory": "memory-supabase"
    },
    "entries": {
      "memory-supabase": {
        "enabled": true,
        "config": {
          "supabase": {
            "url": "http://127.0.0.1:54321",
            "anonKey": "your-supabase-key"
          },
          "agentId": "my-agent"
        }
      }
    }
  }
}

5. Restart Clawdbot

clawdbot gateway restart

Tools Available

Once installed, your agent gets these tools:

| Tool | Description | |------|-------------| | recall_conversation | Get messages from a specific date | | recall_date_range | Get messages across a date range | | search_history | Search all messages by keyword | | memory_stats | Show logging statistics |

CLI Commands

clawdbot supamem stats          # Show stats
clawdbot supamem recall 2026-01-15   # Get messages from date
clawdbot supamem search "iPad"  # Search by keyword

Database Schema

The plugin uses these tables:

• sessions — Conversation sessions with metadata
• messages — Every message with role, content, timestamp
• memories — (Optional) Long-term memories with embeddings
• entities — (Optional) Knowledge graph entries

Configuration Options

| Option | Type | Default | Description | |--------|------|---------|-------------| | supabase.url | string | required | Supabase project URL | | supabase.anonKey | string | required | Supabase anon/service key | | agentId | string | "default" | Agent identifier for multi-agent setups |

How it works

1. Session start: Creates a new session when conversation begins
2. Message logging: Captures every user and assistant message
3. Session end: Closes session when conversation ends
4. Recall: SQL queries for date/keyword-based retrieval

No embeddings or vector search required — just simple, reliable PostgreSQL queries.

Future Plans

• [ ] Vector search with pgvector (semantic similarity)
• [ ] Auto-summarization of long conversations
• [ ] Entity extraction (people, places, things)
• [ ] npm package for easy installation

License

MIT

Author

Built by an AI agent for Clawdbot.