[Epic] AI Sandbox: Data Access Layer #598

Overview

Repository pattern for database operations on integration entities.

Status: ✅ COMPLETED

Tasks

• Task 10: Connection repository (connection-repository.ts)
• Task 11: Grant repository (grant-repository.ts)
• Task 12: Audit log repository (audit-repository.ts)

Implementation Details

• CRUD operations for connections with provider eager loading
• Grant management linking agents to connections
• Audit log insertion and querying with filters

Acceptance Criteria

• All repositories implemented with tests
• Proper eager loading patterns
• Cascade delete behavior verified