Back to list
vassovass

project-updates

by vassovass

1🍴 0📅 Jan 24, 2026

SKILL.md


name: project-updates description: How to update roadmap, changelog, and Kanban when completing features. Use after finishing any feature, bug fix, or improvement to ensure proper documentation and tracking. Keywords: changelog, roadmap, kanban, feedback, documentation, completion, tracking, MCP. compatibility: Antigravity, Claude Code, Cursor metadata: version: "1.1" project: "stepleague"

Project Updates Skill

Overview

MANDATORY: Every completed feature must be tracked in:

  1. CHANGELOG.md - What changed (file)
  2. Roadmap/Kanban - Feature status (database via API or MCP)
  3. AGENTS.md - If it's a key pattern (optional, file)

The Feedback/Roadmap/Kanban System

StepLeague has a modular system for tracking features and feedback:

ComponentPurposeTablePublic Page
FeedbackUser-submitted issues and ideasfeedback/feedback
RoadmapPublic feature timelinefeedback (filtered)/roadmap
KanbanInternal task trackingfeedback (admin view)/admin/kanban

Key insight: These share the same feedback table but are filtered by board_status and is_public.


1. Updating CHANGELOG.md

Location

CHANGELOG.md in project root

Format

## [Date] - YYYY-MM-DD

### Added
- New feature description

### Changed
- Modified behavior description

### Fixed
- Bug fix description

### Removed
- Removed feature description

2. Updating via API (Preferred for Code)

API Endpoints

EndpointMethodPurpose
/api/agent/current-workPOSTMark feature as in-progress
/api/agent/current-workDELETEClear in-progress flag
/api/admin/kanbanPOSTCreate new kanban item
/api/admin/kanbanPUTUpdate existing item
/api/admin/kanbanGETList kanban items
/api/admin/feedbackGET/POST/PUTFeedback management

Step 1: When Starting Work

await fetch("/api/agent/current-work", {
  method: "POST",
  headers: { "Content-Type": "application/json" },
  body: JSON.stringify({
    subject: "Feature Name",
    description: "What you are building",
    type: "feature"  // or "improvement", "bug"
  })
});

Step 2: When Completing Work

// Clear current work flag
await fetch("/api/agent/current-work", { method: "DELETE" });

// Mark kanban item as done
await fetch("/api/admin/kanban", {
  method: "PUT",
  headers: { "Content-Type": "application/json" },
  body: JSON.stringify({
    id: "<existing-kanban-item-id>",
    board_status: "done",
    completed_at: "2026-01-16"  // Current date YYYY-MM-DD!
  })
});

3. Updating via Supabase MCP (Preferred for Verification)

Use the Supabase MCP to directly query and update the database.

Reference the supabase-patterns skill for MCP usage.

Verify Current State

// Check existing feedback/kanban items
mcp_supabase-mcp-server_execute_sql({
  project_id: "your-project-id",
  query: `
    SELECT id, subject, board_status, completed_at 
    FROM feedback 
    WHERE subject ILIKE '%feature name%'
    LIMIT 5
  `
})

Create New Item via MCP

mcp_supabase-mcp-server_execute_sql({
  project_id: "your-project-id",
  query: `
    INSERT INTO feedback (subject, description, type, board_status, is_public)
    VALUES (
      'Skills System Implementation',
      'Created 8 agent skills for improved AI assistance',
      'feature',
      'done',
      true
    )
    RETURNING id, subject, board_status
  `
})

Update Existing Item via MCP

mcp_supabase-mcp-server_execute_sql({
  project_id: "your-project-id",
  query: `
    UPDATE feedback 
    SET board_status = 'done', 
        completed_at = '2026-01-16'
    WHERE id = 'item-uuid-here'
    RETURNING id, subject, board_status, completed_at
  `
})

Verify Update Applied

mcp_supabase-mcp-server_execute_sql({
  project_id: "your-project-id",
  query: `
    SELECT id, subject, board_status, completed_at 
    FROM feedback 
    WHERE id = 'item-uuid-here'
  `
})

4. Verification Checklist

After updating, verify the changes were applied:

// Check the item was updated
mcp_supabase-mcp-server_execute_sql({
  project_id: "your-project-id",
  query: `
    SELECT id, subject, board_status, completed_at, updated_at
    FROM feedback
    WHERE board_status = 'done'
    ORDER BY completed_at DESC
    LIMIT 5
  `
})

Via API

const response = await fetch("/api/admin/kanban?status=done");
const { items } = await response.json();
// Verify your item is in the list

Database Schema Reference

feedback Table

ColumnTypeDescription
iduuidPrimary key
subjecttextTitle/name of item
descriptiontextDetailed description
typetext'feature', 'bug', 'improvement', 'question'
board_statustext'backlog', 'now', 'next', 'later', 'future', 'done'
is_publicbooleanShown on public roadmap
completed_atdateWhen marked done
prioritytext'low', 'medium', 'high', 'critical'
votesintegerUser vote count
created_attimestampCreation time
updated_attimestampLast update time

Board Status Values

StatusColumn on RoadmapDescription
backlogHiddenNot started
nowNow (with glow if agent working)In progress
nextNextComing soon
laterLaterPlanned
futureFutureIdeas
doneCompleted sectionFinished

5. Complete Workflow

Example: Completing "Proxy Claim" Feature

1. Update CHANGELOG.md (file)

## [2026-01-16]

### Added
- Proxy profile claiming via unique invite codes
- Profile switcher for "Act As" functionality

2. Clear Current Work (API)

await fetch("/api/agent/current-work", { method: "DELETE" });

3. Mark as Done (MCP - with verification)

// First, find the item
mcp_supabase-mcp-server_execute_sql({
  query: "SELECT id, subject FROM feedback WHERE subject ILIKE '%proxy%claim%' LIMIT 5"
})

// Update it
mcp_supabase-mcp-server_execute_sql({
  query: `
    UPDATE feedback 
    SET board_status = 'done', completed_at = '2026-01-16'
    WHERE id = 'found-uuid'
    RETURNING id, subject, board_status, completed_at
  `
})

// Verify
mcp_supabase-mcp-server_execute_sql({
  query: "SELECT * FROM feedback WHERE id = 'found-uuid'"
})

4. Update AGENTS.md Recent Features (file)

### 2026-01-16

- ✅ **Proxy Claim System** (PRD 41)
  - Unique invite codes for proxy profiles
  - "Act As" context switching

Common Issues

ProblemSolution
Item not foundSearch with ILIKE and wildcards
MCP timeoutAdd LIMIT to queries
Update didn't applyCheck for typos in UUID, verify with SELECT
Duplicate entriesSearch before creating new

Checklist Before Considering Work Complete

  • CHANGELOG.md updated with all changes
  • Current work flag cleared (DELETE /api/agent/current-work)
  • Kanban item marked as done (verified via MCP or API)
  • AGENTS.md updated if adding key patterns
  • TypeScript build passes (npx tsc --noEmit)
  • Code committed with descriptive message

  • supabase-patterns - MCP usage and database operations
  • prd-creation - PRDs should reference kanban items
  • architecture-philosophy - Document new patterns in AGENTS.md

Score

Total Score

50/100

Based on repository quality metrics

SKILL.md

SKILL.mdファイルが含まれている

+20
LICENSE

ライセンスが設定されている

0/10
説明文

100文字以上の説明がある

0/10
人気

GitHub Stars 100以上

0/15
最近の活動

3ヶ月以内に更新がある

0/10
フォーク

10回以上フォークされている

0/5
Issue管理

オープンIssueが50未満

+5
言語

プログラミング言語が設定されている

+5
タグ

1つ以上のタグが設定されている

0/5

Reviews

💬

Reviews coming soon