{"_id":"@arephan/clawdbot-memory-supabase","_rev":"2-7ebdfa89024d91adb8cdb0685d8b3bdc","name":"@arephan/clawdbot-memory-supabase","dist-tags":{"latest":"0.1.1"},"versions":{"0.1.0":{"name":"@arephan/clawdbot-memory-supabase","version":"0.1.0","keywords":["clawdbot","clawdbot-plugin","supabase","memory","conversation-logging","postgresql","ai-assistant"],"author":{"name":"Arephan"},"license":"MIT","_id":"@arephan/clawdbot-memory-supabase@0.1.0","maintainers":[{"name":"arephan","email":"hankimproduction@gmail.com"}],"homepage":"https://github.com/Arephan/clawdbot-memory-supabase#readme","bugs":{"url":"https://github.com/Arephan/clawdbot-memory-supabase/issues"},"dist":{"shasum":"8e789ebc4bea844bf36a20c5c98d797e772eac16","tarball":"https://registry.npmjs.org/@arephan/clawdbot-memory-supabase/-/clawdbot-memory-supabase-0.1.0.tgz","fileCount":12,"integrity":"sha512-VUkiZTvv6IUtZmZOjL5FLL3VRgxxzUvO9fTAa8AUUEezkyduoHSfxvxuMybccPy7Sgqs06ag5c6MzBpJUWgJ6w==","signatures":[{"sig":"MEYCIQCzQfgSq5uBIIai/dCDoVV60T1CSZXRnf63+XcMD85vhQIhANRXSjNeiEhaXvsXlF8Wu/rZITt/lJ+NKxKn91Cpp+af","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":67605},"main":"plugin/index.ts","type":"module","gitHead":"0f7243ce69515bfdd2303a604d67e807f5b765d0","_npmUser":{"name":"arephan","email":"hankimproduction@gmail.com"},"clawdbot":{"extensions":["plugin/index.ts"]},"repository":{"url":"git+https://github.com/Arephan/clawdbot-memory-supabase.git","type":"git"},"_npmVersion":"11.8.0","description":"Clawdbot plugin for complete conversation logging to Supabase/PostgreSQL. Never forget anything.","directories":{},"_nodeVersion":"25.5.0","dependencies":{"@supabase/supabase-js":"^2.39.0"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/clawdbot-memory-supabase_0.1.0_1769977053804_0.9695586926878632","host":"s3://npm-registry-packages-npm-production"}},"0.1.1":{"name":"@arephan/clawdbot-memory-supabase","version":"0.1.1","description":"Clawdbot plugin for complete conversation logging to Supabase/PostgreSQL. Never forget anything.","type":"module","main":"plugin/index.ts","clawdbot":{"extensions":["plugin/index.ts"]},"keywords":["clawdbot","clawdbot-plugin","supabase","memory","conversation-logging","postgresql","ai-assistant"],"repository":{"type":"git","url":"git+https://github.com/Arephan/clawdbot-memory-supabase.git"},"author":{"name":"Arephan"},"license":"MIT","dependencies":{"@supabase/supabase-js":"^2.39.0"},"gitHead":"97fbc025d54b7592bf8c82b7c87633d837fbb5a2","_id":"@arephan/clawdbot-memory-supabase@0.1.1","bugs":{"url":"https://github.com/Arephan/clawdbot-memory-supabase/issues"},"homepage":"https://github.com/Arephan/clawdbot-memory-supabase#readme","_nodeVersion":"25.5.0","_npmVersion":"11.8.0","dist":{"integrity":"sha512-/xAsSAHFYWYGIaKmUopGqsps4/ijj18F9FXc3Sm4hbPOyElj/PShOz3HAzQHnJgFi9Rwl8Jhuxj9PW3hVBhnPA==","shasum":"5379b69f8df39a78cf0883802986f2e36eefebaf","tarball":"https://registry.npmjs.org/@arephan/clawdbot-memory-supabase/-/clawdbot-memory-supabase-0.1.1.tgz","fileCount":14,"unpackedSize":68423,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEYCIQCYp4KAaIgXPAFuvzxJv09XBsghteDmr+eONTNnyK41vQIhAPSVGiNPDtE05cAEEU8d0PruTEYPNqbwK995irdPyhxs"}]},"_npmUser":{"name":"arephan","email":"hankimproduction@gmail.com"},"directories":{},"maintainers":[{"name":"arephan","email":"hankimproduction@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/clawdbot-memory-supabase_0.1.1_1769977407126_0.662175718668427"},"_hasShrinkwrap":false}},"time":{"created":"2026-02-01T20:17:33.705Z","modified":"2026-02-01T20:23:27.420Z","0.1.0":"2026-02-01T20:17:33.941Z","0.1.1":"2026-02-01T20:23:27.273Z"},"bugs":{"url":"https://github.com/Arephan/clawdbot-memory-supabase/issues"},"author":{"name":"Arephan"},"license":"MIT","homepage":"https://github.com/Arephan/clawdbot-memory-supabase#readme","keywords":["clawdbot","clawdbot-plugin","supabase","memory","conversation-logging","postgresql","ai-assistant"],"repository":{"type":"git","url":"git+https://github.com/Arephan/clawdbot-memory-supabase.git"},"description":"Clawdbot plugin for complete conversation logging to Supabase/PostgreSQL. Never forget anything.","maintainers":[{"name":"arephan","email":"hankimproduction@gmail.com"}],"readme":"# clawdbot-memory-supabase\n\nA Clawdbot plugin that logs **every conversation** to Supabase/PostgreSQL. Never forget anything.\n\n## What it does\n\n- 📝 Logs every message (user + assistant) with timestamps\n- 🔍 Query by date: \"What did we talk about on January 15th?\"\n- 📅 Query by range: \"What did we discuss last week?\"\n- 🔎 Search by keyword across all history\n- 🐘 Elephant memory — complete conversation recall\n\n## Quick Start\n\n### 1. Set up Supabase\n\n**Local (recommended for development):**\n```bash\n# Install Supabase CLI\nbrew install supabase/tap/supabase\n\n# In your project directory\nsupabase init\nsupabase start\n```\n\n**Or use Supabase Cloud:** Create a project at [supabase.com](https://supabase.com)\n\n### 2. Run migrations\n\nCopy the `migrations/` folder to your Supabase project:\n\n```bash\ncp -r migrations/ your-project/supabase/migrations/\ncd your-project\nsupabase db reset  # Local\n# or\nsupabase db push   # Cloud\n```\n\n### 3. Install the plugin\n\n**Option A: Copy to extensions folder**\n```bash\ncp -r plugin/ ~/.clawdbot/extensions/memory-supabase/\n# or for workspace-specific:\ncp -r plugin/ your-workspace/.clawdbot/extensions/memory-supabase/\n```\n\n**Option B: Install from npm** (coming soon)\n```bash\nclawdbot plugins install @arephan/clawdbot-memory-supabase\n```\n\n### 4. Configure Clawdbot\n\nAdd to your `clawdbot.json`:\n\n```json\n{\n  \"plugins\": {\n    \"slots\": {\n      \"memory\": \"memory-supabase\"\n    },\n    \"entries\": {\n      \"memory-supabase\": {\n        \"enabled\": true,\n        \"config\": {\n          \"supabase\": {\n            \"url\": \"http://127.0.0.1:54321\",\n            \"anonKey\": \"your-supabase-key\"\n          },\n          \"agentId\": \"my-agent\"\n        }\n      }\n    }\n  }\n}\n```\n\n### 5. Restart Clawdbot\n\n```bash\nclawdbot gateway restart\n```\n\n## Tools Available\n\nOnce installed, your agent gets these tools:\n\n| Tool | Description |\n|------|-------------|\n| `recall_conversation` | Get messages from a specific date |\n| `recall_date_range` | Get messages across a date range |\n| `search_history` | Search all messages by keyword |\n| `memory_stats` | Show logging statistics |\n\n## CLI Commands\n\n```bash\nclawdbot supamem stats          # Show stats\nclawdbot supamem recall 2026-01-15   # Get messages from date\nclawdbot supamem search \"iPad\"  # Search by keyword\n```\n\n## Database Schema\n\nThe plugin uses these tables:\n\n- `sessions` — Conversation sessions with metadata\n- `messages` — Every message with role, content, timestamp\n- `memories` — (Optional) Long-term memories with embeddings\n- `entities` — (Optional) Knowledge graph entries\n\n## Configuration Options\n\n| Option | Type | Default | Description |\n|--------|------|---------|-------------|\n| `supabase.url` | string | required | Supabase project URL |\n| `supabase.anonKey` | string | required | Supabase anon/service key |\n| `agentId` | string | \"default\" | Agent identifier for multi-agent setups |\n\n## How it works\n\n1. **Session start**: Creates a new session when conversation begins\n2. **Message logging**: Captures every user and assistant message\n3. **Session end**: Closes session when conversation ends\n4. **Recall**: SQL queries for date/keyword-based retrieval\n\nNo embeddings or vector search required — just simple, reliable PostgreSQL queries.\n\n## Future Plans\n\n- [ ] Vector search with pgvector (semantic similarity)\n- [ ] Auto-summarization of long conversations\n- [ ] Entity extraction (people, places, things)\n- [ ] npm package for easy installation\n\n## License\n\nMIT\n\n## Author\n\nBuilt by an AI agent for [Clawdbot](https://github.com/clawdbot/clawdbot).\n","readmeFilename":"README.md"}