Skip to main content

Asset Management System

End-to-end asset management system controlling corporate inventory, departmental budgets, and equipment lifecycle. Features a conversational AI assistant grounded in the full inventory, automated requisitions with Teams notifications, maintenance tracking, expiration alerts, and multi-level permissions that prevent loss and optimize spending.

Next.js
Supabase
React
TypeScript
Tailwind CSS
PostgreSQL

About this project

This system is an enterprise-grade web platform designed to provide complete visibility and control over organizational assets. Built on Next.js with Supabase as its data and authentication layer, the system creates a unified ecosystem for tracking, managing, and optimizing physical inventory across all departments. An integrated AI layer operates across every function of the platform, assisting users with data entry, search, classification, and interpretation of asset information without requiring them to learn complex query syntax or navigate deep menu structures. The platform implements role-based access control with granular permission levels enforced through Row-Level Security policies, ensuring employees access only relevant functionalities while management maintains oversight of the entire asset lifecycle.

The management interface delivers centralized control over the company's physical assets, including notebooks, tools, accessories, uniforms, and specialized equipment. Executives can monitor total asset value allocated per department, track ownership chains, identify items approaching expiration dates, and analyze spending patterns across categories. This granular visibility directly addresses common pain points such as asset loss through poor administration, redundant purchases, and budget waste, transforming asset management from a reactive process into a strategic function that protects capital and optimizes resource allocation.

A conversational assistant sits alongside every screen, grounded in the complete inventory dataset. Users ask questions in plain language and receive precise answers drawn from live records, whether they need to locate a specific tool, check which laptops are unassigned, confirm who currently holds a given asset, or understand how stock is distributed across sectors. The same context powers proactive alerts: the assistant surfaces calibrations coming due, items nearing expiration, categories running low, and requisitions awaiting approval, so deadlines are caught before they become operational problems. Quick actions cover the most frequent queries in a single click, while the conversation history keeps previous investigations available for reference. Because the assistant reads from the same permission-scoped data as the interface itself, each user only ever sees what their role allows.

Employees interact with the system through an intuitive catalog-based interface that streamlines requisition workflows. When requesting items, workers provide justifications that trigger server-side routines dispatching notifications to the appropriate manager's Teams channel for one-click approval or denial. AI assistance runs throughout this flow, suggesting the correct asset category during requisition, drafting clearer justification text from a short description, and summarizing request context so managers can decide without opening multiple records. The system also includes a damage reporting feature where employees can flag malfunctioning assets, which are then automatically transferred to a maintenance queue for tracking and resolution. This self-service approach reduces administrative friction while maintaining accountability and audit trails.

Access control is implemented at multiple hierarchical levels, extending even within management roles. Only designated administrators can create or edit inventory records, with permissions enforced at the database level rather than the interface alone, ensuring data integrity while distributing operational responsibilities. This comprehensive asset management framework benefits both employees, who gain transparent access to resources, and leadership, who achieve financial discipline, operational efficiency, and data-driven decision-making capabilities across the organization's physical infrastructure.

Tech Stack

Next.js
Supabase
React
TypeScript
Tailwind CSS
PostgreSQL