// Overview
A standalone, integrable CRM engineered end to end contact management, a kanban deal pipeline, suppliers, client documents, role-based admin access, analytics and an activity audit log, with PDF / Word / Excel exports. A self-contained Next.js app that points at any MySQL/MariaDB database and drops in beside an existing system, owning only its own tables.
A self-contained CRM that runs on its own yet slots into any existing system pipeline, clients, suppliers and analytics behind a single secure admin.
Challenge
01Build a CRM that can be dropped alongside an existing product without ever touching its database schema secure by default, and useful whether or not it is wired into host data.
Goal
02Ship a complete, production-grade CRM contacts, a kanban pipeline, suppliers, documents, invoicing and analytics with a hardened auth model and clean host integrations that stay off by default.
Process
03Next.js 14 App Router with NextAuth credential sessions and role-based access (super-admin, admin, dashboard-only), a MariaDB pool guarded by a circuit breaker, parameterised SQL throughout, an idempotent table bootstrap that never migrates host tables, an activity audit log, and jsPDF / docx / xlsx export pipelines.
Result
04A reusable CRM product that deploys standalone or embeds into a client stack in minutes every route auth-checked server-side, no destructive schema behaviour, and rebrandable from a single environment variable.
// Plates
// Next project