function createEventStore(dbPath?: string): EventStore

[
  ["Read", "Edit", "Bash"],
  ["Grep", "Read", "Write"],
  ["Read", "Edit", "Bash"],
]

CREATE TABLE events (
  id TEXT PRIMARY KEY,
  session_id TEXT NOT NULL,
  project_path TEXT NOT NULL,
  tool_name TEXT NOT NULL,
  tool_input TEXT NOT NULL,  -- JSON
  tool_response TEXT,
  success INTEGER NOT NULL,  -- 0 or 1
  timestamp TEXT NOT NULL,   -- ISO-8601
  agent_id TEXT
)

import { createEventStore } from "./core/event-store";

// Initialize store
const store = createEventStore();

// Record events during a coding session
const sessionId = "session-123";
const projectPath = "/Users/dev/my-project";

store.recordEvent(
  sessionId,
  projectPath,
  "Read",
  { filePath: "/Users/dev/my-project/src/main.ts" },
  "export function main() {...}",
  true,
  "claude-code"
);

store.recordEvent(
  sessionId,
  projectPath,
  "Edit",
  {
    filePath: "/Users/dev/my-project/src/main.ts",
    oldString: "console.log",
    newString: "logger.info"
  },
  null,
  true
);

store.recordEvent(
  sessionId,
  projectPath,
  "Bash",
  { command: "npm test" },
  "PASS  src/main.test.ts\n✓ main function works",
  true
);

// Query events
const sessionEvents = store.getSessionEvents(sessionId);
console.log(`Session has ${sessionEvents.length} events`);

// Get tool sequences for pattern detection
const sequences = store.getToolSequences(undefined, 7, 2);
console.log(`Found ${sequences.length} sessions`);
console.log(`Example: ${sequences[0].join(" → ")}`);

// Get full events with inputs
const fullSessions = store.getEventsWithInputs(projectPath, 7);
console.log(`Loaded ${fullSessions.length} sessions with full context`);

// Statistics
const stats = store.getStats();
console.log(`\nDatabase Statistics:`);
console.log(`Total events: ${stats.totalEvents}`);
console.log(`Unique sessions: ${stats.uniqueSessions}`);
console.log(`Unique projects: ${stats.uniqueProjects}`);
console.log(`\nTop tools:`);
stats.topTools.slice(0, 5).forEach(({ tool, count }) => {
  console.log(`  ${tool}: ${count} times`);
});

// Cleanup old data (30+ days)
const deleted = store.cleanupOldEvents(30);
console.log(`\nDeleted ${deleted} old events`);

// Close connection
store.close();

"Very long output...[truncated]"