# indianprogrammer/erp architecture

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

- Interactive diagram: https://gitdiagram.com/indianprogrammer/erp
- Repository: https://github.com/indianprogrammer/erp

## Overview

This is a multi-tenant ERP and GST suite: staff authenticate into a tenant, then use the browser SPA or MCP tools to reach tenant-scoped business APIs and their MySQL-backed records. The major business branches cover procurement, sales, inventory, CRM, projects/expenses, and GST; shared layers provide authentication, tenant isolation, settings, and dashboard/search access. The README documents several capabilities not sampled in source, so those subsystems are represented at their documented route-directory level; their internal interactions are not inferred.

Main entry points: [`server.js`](https://github.com/indianprogrammer/erp/blob/master/server.js) (Express API), [`server/db/pool.js`](https://github.com/indianprogrammer/erp/blob/master/server/db/pool.js) (MySQL database), [`server/lib/middleware.js`](https://github.com/indianprogrammer/erp/blob/master/server/lib/middleware.js) (Auth and RBAC), [`server/routes/auth.js`](https://github.com/indianprogrammer/erp/blob/master/server/routes/auth.js) (Authentication)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_entry["Entry surfaces"]
  node_spa["ERP browser SPA<br/>[app.js]"]
  node_ui["Shared UI<br/>[ui.js]"]
  node_api["Express API<br/>[server.js]"]
  node_mcp["MCP tools<br/>[server.js]"]
  node_stdio["MCP stdio<br/>[stdio.js]"]
end

subgraph group_security["Identity and tenancy"]
  node_auth["Authentication<br/>[auth.js]"]
  node_access["Auth and RBAC<br/>[middleware.js]"]
  node_tenant["Tenant resolution<br/>[tenant.js]"]
  node_tokens["JWT tokens<br/>[tokens.js]"]
  node_db[("MySQL database<br/>[pool.js]")]
  node_admin["Staff and administration<br/>[admin.js]"]
  node_settings["Company settings<br/>[settings.js]"]
end

subgraph group_commerce["Procurement and sales"]
  node_procurement["Procurement and vendors<br/>[rfqs.js]"]
  node_sales["Sales documents<br/>[salesdocs.js]"]
  node_customers["Customer directory<br/>[customers.js]"]
  node_receipts["Receipts<br/>[receipts.js]"]
end

subgraph group_operations["Operations and inventory"]
  node_crm["CRM leads<br/>[leads.js]"]
  node_stages["Lead stages<br/>[leadStages.js]"]
  node_projects["Projects and costs<br/>[projects.js]"]
  node_expenses["Expenses<br/>[expenses.js]"]
  node_inventory["Items and warehouses<br/>[items.js]"]
  node_stock["Stock movements<br/>[stock.js]"]
end

subgraph group_insight["GST and oversight"]
  node_gst["GST reconciliation<br/>[gst.js]"]
  node_dashboard["Dashboard KPIs<br/>[dashboard.js]"]
  node_search["Global search<br/>[search.js]"]
  node_docs["API documentation<br/>[docs.js]"]
end

node_user(("Business user"))

node_user -->|"uses"| node_spa
node_spa -.->|"calls APIs"| node_api
node_api -->|"mounts"| node_auth
node_api -->|"guards APIs"| node_access
node_api -->|"resolves tenant"| node_tenant
node_api -->|"mounts routes"| node_procurement
node_api -->|"mounts routes"| node_sales
node_api -->|"mounts routes"| node_customers
node_api -->|"mounts routes"| node_receipts
node_api -->|"mounts routes"| node_crm
node_api -->|"mounts routes"| node_projects
node_api -->|"mounts routes"| node_expenses
node_api -->|"mounts routes"| node_inventory
node_api -->|"mounts routes"| node_stock
node_api -->|"mounts routes"| node_gst
node_api -->|"mounts routes"| node_dashboard
node_api -->|"mounts routes"| node_search
node_api -->|"mounts routes"| node_admin
node_api -->|"mounts routes"| node_settings
node_api -->|"mounts routes"| node_docs
node_mcp -->|"calls tenant API"| node_api
node_stdio -->|"starts server"| node_mcp
node_auth -->|"loads tenant user"| node_access
node_auth -->|"signs and verifies"| node_tokens
node_access -->|"verifies bearer"| node_tokens
node_access -->|"loads users and audits"| node_db
node_tenant -->|"looks up tenants"| node_db
node_tenant -->|"reads authenticated user"| node_access
node_crm -->|"uses stage helpers"| node_stages
node_settings -->|"ensures stages"| node_stages
node_sales -->|"updates stock"| node_stock
node_procurement -.->|"stores procurement"| node_db
node_customers -.->|"stores customers"| node_db
node_receipts -.->|"stores receipts"| node_db
node_crm -.->|"stores leads"| node_db
node_projects -.->|"stores projects"| node_db
node_expenses -->|"stores expenses"| node_db
node_inventory -.->|"stores items"| node_db
node_stock -->|"stores movements"| node_db
node_gst -.->|"reads and records GST"| node_db
node_dashboard -.->|"aggregates KPIs"| node_db
node_search -->|"searches records"| node_db
node_settings -->|"reads and writes settings"| node_db
node_admin -.->|"manages administration"| node_db

click node_spa "https://github.com/indianprogrammer/erp/blob/master/public/js/app.js"
click node_ui "https://github.com/indianprogrammer/erp/blob/master/public/js/ui.js"
click node_api "https://github.com/indianprogrammer/erp/blob/master/server.js"
click node_mcp "https://github.com/indianprogrammer/erp/blob/master/mcp/server.js"
click node_stdio "https://github.com/indianprogrammer/erp/blob/master/mcp/stdio.js"
click node_auth "https://github.com/indianprogrammer/erp/blob/master/server/routes/auth.js"
click node_access "https://github.com/indianprogrammer/erp/blob/master/server/lib/middleware.js"
click node_tenant "https://github.com/indianprogrammer/erp/blob/master/server/lib/tenant.js"
click node_tokens "https://github.com/indianprogrammer/erp/blob/master/server/lib/tokens.js"
click node_db "https://github.com/indianprogrammer/erp/blob/master/server/db/pool.js"
click node_admin "https://github.com/indianprogrammer/erp/blob/master/server/routes/admin.js"
click node_settings "https://github.com/indianprogrammer/erp/blob/master/server/routes/settings.js"
click node_procurement "https://github.com/indianprogrammer/erp/blob/master/server/routes/rfqs.js"
click node_sales "https://github.com/indianprogrammer/erp/blob/master/server/routes/salesdocs.js"
click node_customers "https://github.com/indianprogrammer/erp/blob/master/server/routes/customers.js"
click node_receipts "https://github.com/indianprogrammer/erp/blob/master/server/routes/receipts.js"
click node_crm "https://github.com/indianprogrammer/erp/blob/master/server/routes/leads.js"
click node_stages "https://github.com/indianprogrammer/erp/blob/master/server/lib/leadStages.js"
click node_projects "https://github.com/indianprogrammer/erp/blob/master/server/routes/projects.js"
click node_expenses "https://github.com/indianprogrammer/erp/blob/master/server/routes/expenses.js"
click node_inventory "https://github.com/indianprogrammer/erp/blob/master/server/routes/items.js"
click node_stock "https://github.com/indianprogrammer/erp/blob/master/server/routes/stock.js"
click node_gst "https://github.com/indianprogrammer/erp/blob/master/server/routes/gst.js"
click node_dashboard "https://github.com/indianprogrammer/erp/blob/master/server/routes/dashboard.js"
click node_search "https://github.com/indianprogrammer/erp/blob/master/server/routes/search.js"
click node_docs "https://github.com/indianprogrammer/erp/blob/master/server/routes/docs.js"

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_spa,node_ui,node_api,node_mcp,node_stdio,node_user toneBlue
class node_auth,node_access,node_tenant,node_tokens,node_db,node_admin,node_settings toneAmber
class node_procurement,node_sales,node_customers,node_receipts toneMint
class node_crm,node_stages,node_projects,node_expenses,node_inventory,node_stock toneRose
class node_gst,node_dashboard,node_search,node_docs toneIndigo
```

## Components

### Entry surfaces

- [ERP browser SPA](https://github.com/indianprogrammer/erp/blob/master/public/js/app.js): `public/js/app.js`
- [Shared UI](https://github.com/indianprogrammer/erp/blob/master/public/js/ui.js): `public/js/ui.js`
- [Express API](https://github.com/indianprogrammer/erp/blob/master/server.js): `server.js`
- [MCP tools](https://github.com/indianprogrammer/erp/blob/master/mcp/server.js): `mcp/server.js`
- [MCP stdio](https://github.com/indianprogrammer/erp/blob/master/mcp/stdio.js): `mcp/stdio.js`

### Identity and tenancy

- [Authentication](https://github.com/indianprogrammer/erp/blob/master/server/routes/auth.js): `server/routes/auth.js`
- [Auth and RBAC](https://github.com/indianprogrammer/erp/blob/master/server/lib/middleware.js): `server/lib/middleware.js`
- [Tenant resolution](https://github.com/indianprogrammer/erp/blob/master/server/lib/tenant.js): `server/lib/tenant.js`
- [JWT tokens](https://github.com/indianprogrammer/erp/blob/master/server/lib/tokens.js): `server/lib/tokens.js`
- [MySQL database](https://github.com/indianprogrammer/erp/blob/master/server/db/pool.js): `server/db/pool.js`
- [Staff and administration](https://github.com/indianprogrammer/erp/blob/master/server/routes/admin.js): `server/routes/admin.js`
- [Company settings](https://github.com/indianprogrammer/erp/blob/master/server/routes/settings.js): `server/routes/settings.js`

### Procurement and sales

- [Procurement and vendors](https://github.com/indianprogrammer/erp/blob/master/server/routes/rfqs.js): `server/routes/rfqs.js`
- [Sales documents](https://github.com/indianprogrammer/erp/blob/master/server/routes/salesdocs.js): `server/routes/salesdocs.js`
- [Customer directory](https://github.com/indianprogrammer/erp/blob/master/server/routes/customers.js): `server/routes/customers.js`
- [Receipts](https://github.com/indianprogrammer/erp/blob/master/server/routes/receipts.js): `server/routes/receipts.js`

### Operations and inventory

- [CRM leads](https://github.com/indianprogrammer/erp/blob/master/server/routes/leads.js): `server/routes/leads.js`
- [Lead stages](https://github.com/indianprogrammer/erp/blob/master/server/lib/leadStages.js): `server/lib/leadStages.js`
- [Projects and costs](https://github.com/indianprogrammer/erp/blob/master/server/routes/projects.js): `server/routes/projects.js`
- [Expenses](https://github.com/indianprogrammer/erp/blob/master/server/routes/expenses.js): `server/routes/expenses.js`
- [Items and warehouses](https://github.com/indianprogrammer/erp/blob/master/server/routes/items.js): `server/routes/items.js`
- [Stock movements](https://github.com/indianprogrammer/erp/blob/master/server/routes/stock.js): `server/routes/stock.js`

### GST and oversight

- [GST reconciliation](https://github.com/indianprogrammer/erp/blob/master/server/routes/gst.js): `server/routes/gst.js`
- [Dashboard KPIs](https://github.com/indianprogrammer/erp/blob/master/server/routes/dashboard.js): `server/routes/dashboard.js`
- [Global search](https://github.com/indianprogrammer/erp/blob/master/server/routes/search.js): `server/routes/search.js`
- [API documentation](https://github.com/indianprogrammer/erp/blob/master/server/routes/docs.js): `server/routes/docs.js`

### Other components

- **Business user**

## Connections

- Business user → ERP browser SPA: uses
- ERP browser SPA → Express API: calls APIs
- Express API → Authentication: mounts (evidence: `server.js`)
- Express API → Auth and RBAC: guards APIs (evidence: `server.js`)
- Express API → Tenant resolution: resolves tenant (evidence: `server.js`)
- Express API → Procurement and vendors: mounts routes (evidence: `server.js`)
- Express API → Sales documents: mounts routes (evidence: `server.js`)
- Express API → Customer directory: mounts routes (evidence: `server.js`)
- Express API → Receipts: mounts routes (evidence: `server.js`)
- Express API → CRM leads: mounts routes (evidence: `server.js`)
- Express API → Projects and costs: mounts routes (evidence: `server.js`)
- Express API → Expenses: mounts routes (evidence: `server.js`)
- Express API → Items and warehouses: mounts routes (evidence: `server.js`)
- Express API → Stock movements: mounts routes (evidence: `server.js`)
- Express API → GST reconciliation: mounts routes (evidence: `server.js`)
- Express API → Dashboard KPIs: mounts routes (evidence: `server.js`)
- Express API → Global search: mounts routes (evidence: `server.js`)
- Express API → Staff and administration: mounts routes (evidence: `server.js`)
- Express API → Company settings: mounts routes (evidence: `server.js`)
- Express API → API documentation: mounts routes (evidence: `server.js`)
- MCP tools → Express API: calls tenant API (evidence: `mcp/server.js`)
- MCP stdio → MCP tools: starts server (evidence: `mcp/stdio.js`)
- Authentication → Auth and RBAC: loads tenant user (evidence: `server/routes/auth.js`)
- Authentication → JWT tokens: signs and verifies (evidence: `server/routes/auth.js`)
- Auth and RBAC → JWT tokens: verifies bearer (evidence: `server/lib/middleware.js`)
- Auth and RBAC → MySQL database: loads users and audits (evidence: `server/lib/middleware.js`)
- Tenant resolution → MySQL database: looks up tenants (evidence: `server/lib/tenant.js`)
- Tenant resolution → Auth and RBAC: reads authenticated user (evidence: `server/lib/tenant.js`)
- CRM leads → Lead stages: uses stage helpers (evidence: `server/routes/leads.js`)
- Company settings → Lead stages: ensures stages (evidence: `server/routes/settings.js`)
- Sales documents → Stock movements: updates stock (evidence: `server/routes/salesdocs.js`)
- Procurement and vendors → MySQL database: stores procurement
- Customer directory → MySQL database: stores customers
- Receipts → MySQL database: stores receipts
- CRM leads → MySQL database: stores leads
- Projects and costs → MySQL database: stores projects
- Expenses → MySQL database: stores expenses (evidence: `server/routes/expenses.js`)
- Items and warehouses → MySQL database: stores items
- Stock movements → MySQL database: stores movements (evidence: `server/routes/stock.js`)
- GST reconciliation → MySQL database: reads and records GST
- Dashboard KPIs → MySQL database: aggregates KPIs
- Global search → MySQL database: searches records (evidence: `server/routes/search.js`)
- Company settings → MySQL database: reads and writes settings (evidence: `server/routes/settings.js`)
- Staff and administration → MySQL database: manages administration
