# team-collabrate/powerhouse architecture

> Architecture diagram of the GitHub repository team-collabrate/powerhouse, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/team-collabrate/powerhouse
- Repository: https://github.com/team-collabrate/powerhouse

## Overview

Powerhouse is an agency operations app for tracking project profitability alongside clients, invoices, expenses, and cash flow. Its main workflow is managing client projects and their costs, issuing invoices and recording payments, then reviewing profitability and analytics. The tree also shows settings, team access, client portals, and data import. Source excerpts and the index expose representative API-to-query and shared-library dependencies; many page-to-API and unsampled feature relationships are therefore left unspecified.

Main entry points: [`src/app/api`](https://github.com/team-collabrate/powerhouse/tree/main/src/app/api) (Application API), [`src/lib/prisma.ts`](https://github.com/team-collabrate/powerhouse/blob/main/src/lib/prisma.ts) (Database access), [`src/lib/queries/projects.ts`](https://github.com/team-collabrate/powerhouse/blob/main/src/lib/queries/projects.ts) (Project data queries), [`src/lib/queries/services.ts`](https://github.com/team-collabrate/powerhouse/blob/main/src/lib/queries/services.ts) (Service queries)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_work["Client and project work"]
  node_clients["Client management"]
  node_projects["Project management"]
  node_services["Service catalog<br/>[services.ts]"]
  node_portal["Client portal<br/>[page.tsx]"]
  node_client_queries["Client data queries<br/>[clients.ts]"]
  node_project_queries["Project data queries<br/>[projects.ts]"]
  node_service_queries["Service queries<br/>[services.ts]"]
end

subgraph group_finance["Billing and expenses"]
  node_invoices["Invoice management"]
  node_expenses["Expense tracking<br/>[page.tsx]"]
  node_invoice_queries["Invoice data queries<br/>[invoices.ts]"]
end

subgraph group_insight["Reporting and analytics"]
  node_dashboard["Profitability dashboard<br/>[page.tsx]"]
  node_analytics["Analytics<br/>[page.tsx]"]
  node_analytics_views["Analytics views"]
end

subgraph group_platform["Access and agency setup"]
  node_api["Application API"]
  node_settings["Agency settings<br/>[page.tsx]"]
  node_team["Team and invites"]
  node_import["Data import"]
  node_auth["Session and permissions<br/>[api.ts]"]
  node_activity["Activity audit<br/>[activity.ts]"]
  node_prisma["Database access<br/>[prisma.ts]"]
  node_postgres[("Supabase Postgres")]
end

node_agency_user(("Agency user"))

node_agency_user -->|"reviews"| node_dashboard
node_agency_user -->|"reviews"| node_analytics
node_api -->|"checks access"| node_auth
node_api -->|"lists clients"| node_client_queries
node_api -->|"lists projects"| node_project_queries
node_api -->|"lists invoices"| node_invoice_queries
node_api -->|"loads services"| node_service_queries
node_client_queries -->|"reads records"| node_prisma
node_project_queries -->|"reads records"| node_prisma
node_project_queries -->|"fetches services"| node_service_queries
node_service_queries -->|"reads services"| node_prisma
node_api -->|"writes records"| node_prisma
node_api -->|"logs mutations"| node_activity
node_activity -->|"writes audit entry"| node_prisma
node_prisma -.->|"persists data"| node_postgres
node_analytics -.->|"presents reports"| node_analytics_views

click node_dashboard "https://github.com/team-collabrate/powerhouse/blob/main/src/app/(dashboard)/dashboard/page.tsx"
click node_analytics "https://github.com/team-collabrate/powerhouse/blob/main/src/app/(dashboard)/analytics/page.tsx"
click node_analytics_views "https://github.com/team-collabrate/powerhouse/tree/main/src/components/analytics"
click node_clients "https://github.com/team-collabrate/powerhouse/tree/main/src/app/(dashboard)/clients"
click node_projects "https://github.com/team-collabrate/powerhouse/tree/main/src/app/(dashboard)/projects"
click node_services "https://github.com/team-collabrate/powerhouse/blob/main/src/lib/services.ts"
click node_invoices "https://github.com/team-collabrate/powerhouse/tree/main/src/app/(dashboard)/invoices"
click node_expenses "https://github.com/team-collabrate/powerhouse/blob/main/src/app/(dashboard)/expenses/page.tsx"
click node_portal "https://github.com/team-collabrate/powerhouse/blob/main/src/app/portal/%5Btoken%5D/page.tsx"
click node_api "https://github.com/team-collabrate/powerhouse/tree/main/src/app/api"
click node_client_queries "https://github.com/team-collabrate/powerhouse/blob/main/src/lib/queries/clients.ts"
click node_project_queries "https://github.com/team-collabrate/powerhouse/blob/main/src/lib/queries/projects.ts"
click node_invoice_queries "https://github.com/team-collabrate/powerhouse/blob/main/src/lib/queries/invoices.ts"
click node_service_queries "https://github.com/team-collabrate/powerhouse/blob/main/src/lib/queries/services.ts"
click node_settings "https://github.com/team-collabrate/powerhouse/blob/main/src/app/(dashboard)/settings/page.tsx"
click node_team "https://github.com/team-collabrate/powerhouse/tree/main/src/app/api/team"
click node_import "https://github.com/team-collabrate/powerhouse/tree/main/src/lib/import"
click node_auth "https://github.com/team-collabrate/powerhouse/blob/main/src/lib/api.ts"
click node_activity "https://github.com/team-collabrate/powerhouse/blob/main/src/lib/activity.ts"
click node_prisma "https://github.com/team-collabrate/powerhouse/blob/main/src/lib/prisma.ts"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_clients,node_projects,node_services,node_portal,node_client_queries,node_project_queries,node_service_queries,node_agency_user toneBlue
class node_invoices,node_expenses,node_invoice_queries toneAmber
class node_dashboard,node_analytics,node_analytics_views toneMint
class node_api,node_settings,node_team,node_import,node_auth,node_activity,node_prisma,node_postgres toneRose
```

## Components

### Client and project work

- [Client management](https://github.com/team-collabrate/powerhouse/tree/main/src/app/(dashboard)/clients): `src/app/(dashboard)/clients`
- [Project management](https://github.com/team-collabrate/powerhouse/tree/main/src/app/(dashboard)/projects): `src/app/(dashboard)/projects`
- [Service catalog](https://github.com/team-collabrate/powerhouse/blob/main/src/lib/services.ts): `src/lib/services.ts`
- [Client portal](https://github.com/team-collabrate/powerhouse/blob/main/src/app/portal/%5Btoken%5D/page.tsx): `src/app/portal/[token]/page.tsx`
- [Client data queries](https://github.com/team-collabrate/powerhouse/blob/main/src/lib/queries/clients.ts): `src/lib/queries/clients.ts`
- [Project data queries](https://github.com/team-collabrate/powerhouse/blob/main/src/lib/queries/projects.ts): `src/lib/queries/projects.ts`
- [Service queries](https://github.com/team-collabrate/powerhouse/blob/main/src/lib/queries/services.ts): `src/lib/queries/services.ts`

### Billing and expenses

- [Invoice management](https://github.com/team-collabrate/powerhouse/tree/main/src/app/(dashboard)/invoices): `src/app/(dashboard)/invoices`
- [Expense tracking](https://github.com/team-collabrate/powerhouse/blob/main/src/app/(dashboard)/expenses/page.tsx): `src/app/(dashboard)/expenses/page.tsx`
- [Invoice data queries](https://github.com/team-collabrate/powerhouse/blob/main/src/lib/queries/invoices.ts): `src/lib/queries/invoices.ts`

### Reporting and analytics

- [Profitability dashboard](https://github.com/team-collabrate/powerhouse/blob/main/src/app/(dashboard)/dashboard/page.tsx): `src/app/(dashboard)/dashboard/page.tsx`
- [Analytics](https://github.com/team-collabrate/powerhouse/blob/main/src/app/(dashboard)/analytics/page.tsx): `src/app/(dashboard)/analytics/page.tsx`
- [Analytics views](https://github.com/team-collabrate/powerhouse/tree/main/src/components/analytics): `src/components/analytics`

### Access and agency setup

- [Application API](https://github.com/team-collabrate/powerhouse/tree/main/src/app/api): `src/app/api`
- [Agency settings](https://github.com/team-collabrate/powerhouse/blob/main/src/app/(dashboard)/settings/page.tsx): `src/app/(dashboard)/settings/page.tsx`
- [Team and invites](https://github.com/team-collabrate/powerhouse/tree/main/src/app/api/team): `src/app/api/team`
- [Data import](https://github.com/team-collabrate/powerhouse/tree/main/src/lib/import): `src/lib/import`
- [Session and permissions](https://github.com/team-collabrate/powerhouse/blob/main/src/lib/api.ts): `src/lib/api.ts`
- [Activity audit](https://github.com/team-collabrate/powerhouse/blob/main/src/lib/activity.ts): `src/lib/activity.ts`
- [Database access](https://github.com/team-collabrate/powerhouse/blob/main/src/lib/prisma.ts): `src/lib/prisma.ts`
- **Supabase Postgres**

### Other components

- **Agency user**

## Connections

- Agency user → Profitability dashboard: reviews (evidence: `README.md`)
- Agency user → Analytics: reviews (evidence: `README.md`)
- Application API → Session and permissions: checks access (evidence: `src/lib/api.ts`)
- Application API → Client data queries: lists clients (evidence: `src/app/api/clients/[id]/route.ts`)
- Application API → Project data queries: lists projects (evidence: `src/app/api/projects/route.ts`)
- Application API → Invoice data queries: lists invoices (evidence: `src/app/api/invoices/route.ts`)
- Application API → Service queries: loads services (evidence: `src/app/api/services/route.ts`)
- Client data queries → Database access: reads records (evidence: `src/lib/queries/clients.ts`)
- Project data queries → Database access: reads records (evidence: `src/lib/queries/projects.ts`)
- Project data queries → Service queries: fetches services (evidence: `src/lib/queries/projects.ts`)
- Service queries → Database access: reads services (evidence: `src/lib/queries/services.ts`)
- Application API → Database access: writes records (evidence: `src/app/api/projects/route.ts`)
- Application API → Activity audit: logs mutations (evidence: `src/app/api/invoices/route.ts`)
- Activity audit → Database access: writes audit entry (evidence: `src/lib/activity.ts`)
- Database access → Supabase Postgres: persists data (evidence: `README.md`)
- Analytics → Analytics views: presents reports
