Gokkul.dev
Back to all projects
Team Project / Full Stack · 2026

Jira-style Tool

Sprint & task management

jira-style-tool — experience preview (simulation)
Live sim

The burndown drops 5 points, and Priya's board updates live.

Run a sprint

Problem

Small teams outgrow spreadsheets for sprint tracking fast, but often don't want full Jira complexity or its license cost.

Approach

  • Hierarchical issue model (Epic → Story → Task → Subtask) with audit trail, drag-and-drop Kanban, sprint planning, and RBAC-gated UI.
  • OTP auth via an external HRMS API; auto-generated issue keys; versioned DB migrations.

Result

A lightweight, self-hosted Jira-style board with real issue hierarchy, an audit trail, and RBAC — without the enterprise price tag.

Stack

Node.jsExpress.jsMySQLNext.js 14TypeScriptTailwind CSSRedux ToolkitJWTCKEditor 5

The preview above replays the hardest moment of this project's Experience, drawn from the same simulation code. Click it to try the whole thing yourself.

Under the hood

A simplified excerpt of the core logic and how a request flows through the system.

-- migrations/007_create_issues.sql
CREATE TABLE issues (
id INT AUTO_INCREMENT PRIMARY KEY,
issue_key VARCHAR(12) UNIQUE, -- ORC-42
type ENUM('epic','story','task'),
parent_id INT NULL,
status ENUM('todo','doing','done'),
sprint_id INT,
FOREIGN KEY (parent_id)
REFERENCES issues(id)
);

Request flow

Next.js board (drag & drop)
Express API
MySQL — versioned migrations

Connects to

External HRMS API (OTP)RBAC-gated UIAuto issue keys

More projects