How liam-hq/liam works
Liam ERD turns database schemas into interactive entity-relationship diagrams, with public URL viewing, a CLI for private/local schemas, and a hosted collaborative design-session workflow. The principal hosted flow runs from a user prompt through streamed agent work to versioned schema output and an ERD. The graph also includes project/repository setup, organization management, and the shared diagram renderer. Several connections are supported only by README statements or the source index; unsampled implementation details are not inferred.
Main entry points: SessionDetailPageClient.tsx Design session · src Interactive ERD renderer · App.tsx CLI viewer · useStream Stream controller
Components 23
Product entry points
- Public ERD URL
frontend/apps/app/app/erd/p/[...slug]/page.tsx - CLI viewer
frontend/packages/cli/src/App.tsx
Hosted design sessions
- Design session
frontend/apps/app/components/SessionDetailPage/SessionDetailPageClient.tsx - Session chat
frontend/apps/app/components/SessionDetailPage/components/Chat/Chat.tsx - Stream controller
frontend/apps/app/components/SessionDetailPage/hooks/useStream - Chat stream API
frontend/apps/app/app/api/chat/stream/route.ts - Chat replay API
frontend/apps/app/app/api/chat/replay/route.ts - Agent stream processing
frontend/internal-packages/agent/src/streaming/server/handlers.ts - Message chunk assembly
frontend/internal-packages/agent/src/streaming/core/MessageTupleManager.ts - Session output
frontend/apps/app/components/SessionDetailPage/components/Output/Output.tsx - Realtime schema versions
frontend/apps/app/components/SessionDetailPage/hooks/useRealtimeVersionsWithSchema/useRealtimeVersionsWithSchema.ts - Application database
frontend/apps/app/libs/db/server.ts
Schema and diagrams
- Schema parsing
frontend/packages/schema/src - Interactive ERD renderer
frontend/packages/erd-core/src - Diagram navigation state
frontend/packages/erd-core/src/features/erd/components/ERDContent/hooks/useQueryParamsChanged.ts - SQL execution
frontend/internal-packages/pglite-server/src/PGliteInstanceManager.ts
Projects and teams
- Project management
frontend/apps/app/app/api/projects/route.ts - Repository setup
frontend/apps/app/components/ProjectNewPage/ProjectNewPage.tsx - Organization members
frontend/apps/app/components/OrganizationMembersPage/components/ClientSearchWrapper/ClientSearchWrapper.tsx - Member and invite items
frontend/apps/app/components/OrganizationMembersPage/components/MemberItem/MemberItem.tsx - Invitation items
frontend/apps/app/components/OrganizationMembersPage/components/InvitationItem/InvitationItem.tsx
Other components
- User
- Database schema
Connections 24
- User → Public ERD URL: opens schema link
README.md - Database schema → Public ERD URL: renders from schema
README.md - User → CLI viewer: starts private viewer
README.md - CLI viewer → Database schema: loads schema JSON
frontend/packages/cli/src/App.tsx - CLI viewer → Interactive ERD renderer: renders diagram
frontend/packages/cli/src/App.tsx - User → Design session: opens session
- Design session → Session chat: renders chat
frontend/apps/app/components/SessionDetailPage/SessionDetailPageClient.tsx - Design session → Stream controller: starts or replays
frontend/apps/app/components/SessionDetailPage/SessionDetailPageClient.tsx - Stream controller → Chat stream API: streams messages
- Stream controller → Chat replay API: replays workflow
- Chat stream API → Application database: reads session data
frontend/apps/app/app/api/chat/stream/route.ts - Chat replay API → Application database: reads session data
frontend/apps/app/app/api/chat/replay/route.ts - Agent stream processing → Message chunk assembly: assembles chunks
frontend/internal-packages/agent/src/streaming/server/handlers.ts - Design session → Session output: renders results
frontend/apps/app/components/SessionDetailPage/SessionDetailPageClient.tsx - Design session → Realtime schema versions: tracks versions
frontend/apps/app/components/SessionDetailPage/SessionDetailPageClient.tsx - Session output → Interactive ERD renderer: displays schema
- Database schema → Schema parsing: reverse engineers
README.md - Schema parsing → Interactive ERD renderer: provides schema
README.md - Interactive ERD renderer → Diagram navigation state: updates diagram state
frontend/packages/erd-core/src/features/erd/components/ERDContent/hooks/useQueryParamsChanged.ts - User → SQL execution: runs SQL
- User → Project management: manages projects
- Project management → Repository setup: configures repositories
- Organization members → Member and invite items: renders members
frontend/apps/app/components/OrganizationMembersPage/components/ClientSearchWrapper/ClientSearchWrapper.tsx - Organization members → Invitation items: renders invitations
frontend/apps/app/components/OrganizationMembersPage/components/ClientSearchWrapper/ClientSearchWrapper.tsx