context-db-schema

Manage SQLite session state for MediatorLite workflows by using an idempotent schema that automatically creates tables on first use, enforcing foreign keys and formatting ISO-8601 UTC timestamps to ensure durable cross-chat memory.

Manual SQLite context management fails in .NET multi-agent workflows because it causes foreign key constraint errors, session ID mismatches, and inconsistent timestamp formatting that breaks context retrieval. Automated schema management prevents these issues.

Parent agents and spawned subagents can share the same session context in MediatorLite via the MEDIATORLITE_SESSION_ID environment variable. SQLite WAL mode enables safe concurrent read and write access to this shared state.

Log architecture decisions and agent handoffs in a durable SQLite database using type-safe C# helper methods. These pre-built helpers manage common multi-agent operations like recording decisions, tracking mistakes, and managing sprint backlog items.

SQLite WAL mode supports concurrent access for cross-chat agent persistence by allowing safe concurrent read and write operations. This enables multiple agents to interact with the shared session database simultaneously without locking conflicts.

You do not need to manually create tables for MediatorLite session databases. The schema management is idempotent and automatically applies the session database schema on first use without requiring manual CREATE TABLE steps.