1 files changed, 9 insertions, 0 deletions
diff --git a/crates/atuin-ai/migrations/20260417000000_add_session_metadata.sql b/crates/atuin-ai/migrations/20260417000000_add_session_metadata.sql
new file mode 100644
index 00000000..f97dfd1b
--- /dev/null
+++ b/crates/atuin-ai/migrations/20260417000000_add_session_metadata.sql
@@ -0,0 +1,9 @@
+CREATE TABLE IF NOT EXISTS session_metadata (
+    session_id  TEXT NOT NULL,
+    key         TEXT NOT NULL,
+    value       TEXT NOT NULL,
+    updated_at  INTEGER NOT NULL,
+
+    PRIMARY KEY (session_id, key),
+    FOREIGN KEY (session_id) REFERENCES sessions(id)
+);