Database Patterns

Your AI needs a brain — a structured place to store memory, context, and agent state. Let's design that schema interactively and see the relationships in real-time.

Design Your Brain Schema

Click each table tab to edit its columns. Add new columns, set types, mark primary and foreign keys. The ER diagram below updates as you build.

Why 3 tables instead of 1? Each table serves a different purpose: brain_context holds the agent's current state (like a whiteboard), agent_memory stores past interactions (like a journal), and consciousness_stream logs every action (like security footage). Separating them lets you query and optimize each independently.

These tables are pre-populated as a starting point. Try modifying them — rename columns, change types, add new ones. The generated SQL updates live so you can see the impact of your changes.

Entity Relationship Diagram

This updates live as you modify the tables above.