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

Thirteen core modules,
one unified workspace

KisiBuild brings together community data, organizational intelligence, sales pipeline tracking, document generation, financial tracking, 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.

Invoices

Create, send, and track invoices with auto-sequential numbering (INV-0001). Line items with quantity and unit pricing, tax exempt toggle, payment terms, and status lifecycle from draft through payment. TSD-branded PDF generation.

Change Orders

Track contract modifications with numbered change orders (CO-0001). Line items with unit costs, link to original contract, and approval workflow — draft, submitted, accepted, or rejected.

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.

News Intelligence

AI-powered news scraper monitors RSS feeds from CBC, APTN, ISC, CMHC, and government sources. Articles are scored for housing relevance, analyzed by GPT-4o-mini for impact level, topics, funding amounts, and community mentions, then linked to organizations in the CRM.

News Outreach & Mailing Lists

AI drafts per-organization sales outreach emails with tone calibrated to pipeline stage — introduction, follow-up, or informational. Mailing lists for broadcast sends to internal teams and external contacts. All sends are manually reviewed and triggered.

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

65 reusable clauses organized into ten categories — FN commitments, TSD commitments, financial terms, next steps, timelines, general terms, and more. 26 reusable legal boilerplate sections (confidentiality, IP ownership, indemnification, governing law, etc.) auto-populate for contracts and can be toggled per document. 13 document types including service agreements, consulting agreements, construction contracts, NDAs, and reference letters. Contracts support dual-party organizations with role labels, material specifications, and phased payment schedules. 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.

65 Clauses 10 Categories Legal Boilerplate 13 Doc Types 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
10

Invoicing & Billing

Generate and track invoices with auto-sequential numbering. Line item editor with quantity, unit price, and auto-calculated amounts. Tax exempt toggle for First Nations organizations, configurable payment terms, and running subtotal/tax/total. TSD-branded invoice PDFs with bill-to blocks, invoice metadata, and itemized tables. Status lifecycle: DRAFT → SENT → PAID, with overdue and cancelled states.

Invoice PDF Tax Exempt Auto-numbering Status Tracking
11

Change Order Management

Document contract modifications with numbered change orders linked to original agreements. Line items track description, unit cost, quantity, and auto-calculated totals. Approval workflow moves from draft through submission to acceptance or rejection. TSD-branded change order PDFs reference the original contract and include acceptance blocks.

Contract Mods Approval Flow Linked Docs PDF Export
12

News Intelligence

Hybrid RSS + Cheerio scraper monitors 14+ news sources for housing-relevant articles. Each article is scored for keyword relevance (threshold: 0.4), then analyzed by OpenAI GPT-4o-mini which returns structured JSON: housing analysis, impact level (HIGH/MEDIUM/LOW), topics from a 30-category taxonomy, funding amounts, mentioned communities, and CRM action suggestions. Matched communities auto-link to organizations. Analysis runs on a cron schedule every 2 hours, with manual re-analysis triggers and retry logic for failures. Admin configures sources and OpenAI API key (AES-256-GCM encrypted) from Settings.

RSS + Cheerio GPT-4o-mini 30 Topics Cron: 2h CRM Actions AES-256 Keys
13

News Outreach & Mailing Lists

When articles are analyzed, AI generates per-organization outreach email drafts. Tone is calibrated to the organization's pipeline stage — INTRODUCTION for new leads (no prior relationship), FOLLOW_UP for active engagement (references ongoing discussions), INFORMATIONAL for deep relationships (FYI tone, no hard sell). Each draft includes a subject line, personalized body with [Contact Name] placeholders, and the business reason for outreach. Users review, edit, and manually send from the article detail page. Mailing lists support both internal (full analysis, "View in KisiBuild" link) and external (neutral summary, article link) broadcast templates. Admin manages lists, members (by contact, user, or ad-hoc email), and tracks send history.

AI Email Drafts Pipeline Tone Internal Lists External Lists Manual Send TSD Branding

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
Invoice
INV-0001 billing
ChangeOrder
Contract mods
NewsArticle
Scraped + analyzed
CalendarEvent
Meetings + deadlines
ActivityLog
Audit trail
Clause
Reusable templates
FeedItem
Social feed
PortalAccess
External users
LegalSection
26 boilerplate sections
MaterialSpec
Construction materials
PaymentPhase
Phased payments
NewsOutreach
AI outreach drafts
MailingList
Broadcast groups
Cross-cutting
User
4 internal roles
Invite
Token-based, 7-day
MessageThread
Threaded comms
DocumentSignature
Sign + IP capture
FeedReaction
Emoji responses
FeedComment
Threaded replies
NewsSource
RSS feed configs
SystemSetting
Encrypted config

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
AI

OpenAI GPT-4o-mini

JSON-mode analysis with structured output
Rs

rss-parser + Cheerio

Hybrid RSS feed + HTML scraping

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 News
Admin Full Full Full Full Full Full Full
Sales Rep Create / Edit Create / Edit Upload / Edit View Full View / Send
Estimator View / Estimate View Upload View Participate View
Viewer View View View View Read View
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
Upload Files
Share documents
Comment
Discuss items
Post Updates
Share updates
RSVP Events
Respond to events

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.