KisiBuild

Housing intelligence & community network for First Nations in Saskatchewan

Surfacing data, generating documents, connecting communities through a shared portal, and identifying opportunities to create housing where it's needed most.

Scroll

Nine core modules,
one unified workspace

KisiBuild brings together community data, organizational intelligence, sales pipeline tracking, document generation, a community portal, and a social feed — purpose-built to identify, win, and deliver housing construction contracts with First Nations communities.

Proposals

Track bids and proposals from identification through submission to award. Sales pipeline stages, estimated values, RFP tracking, and team assignments with auto-generated proposal numbers (KB-YYYY-XXXX).

Contacts

Chiefs, council members, band administrators, housing coordinators, decision-makers — all tracked with notes, organization links, and proposal assignments.

Organizations

200+ entities: First Nations, tribal councils, reserves, Metis locals, government agencies, contractors, and suppliers with hierarchical relationships.

Documents

Centralized library for contracts, proposals, RFPs, site assessments, presentations, and reports. Organized per-proposal with categorized uploads.

Messages

Thread-based team messaging with member management. Keep sales discussions organized and contextual within the platform.

Calendar

Meetings, calls, deadlines, site visits, and milestones — all scheduled with attendee tracking and event type categorization.

Document Generation

Build MOUs, offers, contracts, and BCRs from a reusable clause library. Mustache-style variables auto-fill from organization and proposal data. Export branded PDFs with one click.

For You Feed

Blended social feed combining action items, document updates, new proposals, and team announcements. Reactions, comments, and infinite scroll — internal and external versions.

Community Portal

External hub for chiefs, contractors, and investors. Progressive permissions control access to documents, feed, and signing. Invite-token registration with separate session management.

Built around community
housing intelligence

Every module is designed to surface opportunities and support housing development in First Nations communities.

01

Sales Pipeline Management

Track each proposal from initial identification through outreach, site visit, estimating, submission, and award. Eight pipeline stages define the sales lifecycle. Estimated contract values and win probability drive forecasting. Sales reps and estimators are assigned per proposal with full RFP tracking.

8 Stages RFP Tracking Win Probability Rep Assignment
02

Community Intelligence Network

74 First Nations, tribal councils, reserves, Metis locals, government agencies, contractors, and suppliers — all linked in a parent/child hierarchy. Organizations carry First Nations Profile data (band number, treaty area, reserve number), Community Well-Being scores, housing need assessments, and web presence information.

FNP Data CWB Scores Hierarchy 200+ Orgs
03

Contact & Relationship Management

Track every person across the sales ecosystem — chiefs, councillors, band administrators, housing coordinators, decision-makers, influencers, and funders. Contacts link to organizations with timestamped notes for meeting records and follow-ups.

Notes Org Links Decision Makers
04

Document Library & File Management

Upload and organize proposals, RFPs, site assessments, presentations, contracts, and correspondence. Files link to proposals and are categorized by document type for quick filtering and retrieval.

Proposals & RFPs Categories Per-proposal
05

Communication & Scheduling

Thread-based messaging keeps sales team conversations organized by topic. The calendar module handles meetings, calls, site visits, milestones, and deadlines with attendee tracking across all event types.

Threads Calendar Attendees
06

Activity Audit Trail

Every create, update, and delete operation is logged automatically with the user, timestamp, entity type, and action. Full accountability and traceability across the entire sales pipeline.

Auto-logged User Tracking Compliance
07

Document Generation & Clause Library

45 reusable clauses organized into six categories — FN commitments, TSD commitments, financial terms, next steps, timelines, and general terms. Select clauses, fill variables like {{fnName}}, {{projectAmount}}, and {{homesPerYear}}, then generate branded PDFs via Puppeteer. Documents flow through DRAFT → SENT → SIGNED lifecycle with auto-generated feed items at each stage.

45 Clauses 6 Categories Mustache Variables PDF Export
08

"For You" Social Feed

A blended feed combining action items with social updates — new proposals, document status changes, community announcements, and team posts all in one scrollable timeline. Emoji reactions (👍 ❤️ 🎉 🤝), threaded comments, and cursor-based infinite scroll. Internal feed shows everything; the external portal feed filters to community-visible items only.

Infinite Scroll Reactions Comments Internal + External
09

External Community Portal

Hub-and-spoke network connecting chiefs, contractors, investors, and funders. Each portal user gets progressive permissions — VIEW_DOCUMENTS, SIGN_DOCUMENTS, VIEW_FEED, POST_FEED, VIEW_PROPOSALS — controlled per contact. Invite-token registration, separate session cookie, document signing with IP capture, and a dedicated portal layout with its own navigation.

Progressive Access Document Signing Invite Tokens Separate Auth

Data-driven insight
into housing opportunity

Five BI dashboards transform raw ISC data, CWB scores, and community records into actionable housing intelligence.

/bi/housing

Housing Pipeline

Need scores, Community Well-Being indices, active proposal pipeline status, infrastructure readiness, and geographic factors — all weighted into a prioritized housing need ranking.

/bi/population

Population Analytics

Overview stats, community ranking by population, on-reserve vs. off-reserve residency breakdowns, and analysis grouped by tribal council affiliation.

/bi/governance

Governance Tracking

Chiefs and council members, election systems and schedules, term lengths, and governance structures organized by tribal council. Sourced from ISC First Nation Profiles.

/bi/reserves

Land & Reserves

Reserve overview, area rankings, grouping by nation and by tribal council. Geographic data including region, service centre, environmental zone, and remoteness index.

/organizations/servers

Web Server Intelligence

Probes all organization websites to identify hosting providers, server technologies, CMS platforms, and SSL status. Understand the digital infrastructure landscape across all communities.

Relational model built
around community structure

PostgreSQL with Prisma 7 ORM. Every entity connects back to the core Organization model.

Organization
Core entity — FNP, CWB, housing
Contact
People + Notes
Proposal
KB-YYYY-XXXX
Reserve
By reserve number
Document
Files + categories
GeneratedDocument
Clause-built docs
CalendarEvent
Meetings + deadlines
ActivityLog
Audit trail
Clause
Reusable templates
FeedItem
Social feed
PortalAccess
External users
Cross-cutting
User
4 internal roles
Invite
Token-based, 7-day
MessageThread
Threaded comms
DocumentSignature
Sign + IP capture
FeedReaction
Emoji responses
FeedComment
Threaded replies

Modern, proven,
production-grade

Every technology chosen for reliability, developer experience, and long-term maintainability.

N16

Next.js 16

App Router, RSC, Server Actions
TS

TypeScript

Strict mode, end-to-end type safety
P7

Prisma 7

Type-safe ORM with migrations
PG

PostgreSQL

Relational data with PrismaPg adapter
Fe

iron-session

Dual encrypted cookies — internal + portal sessions
TW

Tailwind CSS 4

Utility-first styling with custom theme
Z4

Zod 4

Runtime schema validation
PM

PM2

Production process manager, port 3005
N+

Node.js 20+

LTS runtime environment
Pp

Puppeteer

Server-side HTML→PDF generation

Internal roles + portal permissions

Four internal roles with invite-only registration, plus progressive portal permissions for external community members.

Role Users & Invites Proposals Contacts & Orgs Documents Intelligence Messages
Admin Full Full Full Full Full Full
Sales Rep Create / Edit Create / Edit Upload / Edit View Full
Estimator View / Estimate View Upload View Participate
Viewer View View View View Read
Onboarding

Admins create invite tokens with pre-assigned roles. Users register via token, set their name and password.

Sessions

Encrypted HttpOnly cookies via iron-session. 7-day TTL. No JWTs, no local storage exposure.

Invites

Token-based with email assignment and 7-day expiry. Single-use, role pre-assigned by admin.

Portal Permissions (External Users)
View Documents
Read sent docs
Sign Documents
E-sign + IP capture
View Feed
Community updates
Post to Feed
Share updates
View Proposals
Track pipeline

Consistent patterns,
defense in depth

Every API route follows the same conventions. Security is enforced at every layer from middleware to database.

Rate Limiting

In-memory per-IP rate limiting. Login: 5 req / 5 min. General API: 60 req / min. Returns 429 with Retry-After header.

Input Validation

Zod 4 schemas validate every request body. Structured error responses with field-level messages. Type-safe from request to database.

Dual Auth Middleware

Global middleware enforces authentication with separate session cookies for internal (kisibuild-session) and portal (kisibuild-portal-session) users. Admin routes get an additional role check. Portal routes validate portal sessions independently.

Activity Logging

Every mutation (create, update, delete) is logged with user ID, timestamp, entity type, and action. Complete audit trail for compliance and accountability.

API Conventions

Pagination: ?page=1&limit=20. Search: ?search= (case-insensitive). Filtering: ?status=, ?type=. All responses return { data, total, totalPages }.

Cascade Integrity

Referential integrity enforced at the database level. Deleting a proposal cascades to associated documents, calendar events, and activity logs. No orphaned records.

Document Signing

Portal users sign documents with IP address capture, timestamp, and user agent recording. Documents transition DRAFT → SENT → SIGNED with immutable audit trail. Only DRAFT documents can be edited.

Progressive Permissions

Portal access is permission-based per contact. Admins grant specific capabilities (view docs, sign, post feed) via PortalPermission[]. No blanket access — each feature is individually gated.