Does this skill require a specific database?

The canonical implementation uses SQL (schema.ts), but the logic is designed to be adaptable to any database that supports boolean flags and timestamp comparisons.

What is the primary purpose of this skill?

It provides a standardized template for managing content states like drafts, reviews, and scheduled releases within an administrative system.

Can I customize the workflow states?

Yes, while the skill provides a Draft-to-Published standard, it is designed to be extended to include additional states like 'Archived' or 'Rejected' as needed.

How does the scheduling logic work?

The workflow uses 'startAt' and 'endAt' timestamps to automatically filter content visibility on public endpoints based on the current system time.

VKC Admin Publishing Workflow

Name: VKC Admin Publishing Workflow
Author: LEE-SANG-BOK

byLEE-SANG-BOK

0•

内容管理

Standardizes the content lifecycle from draft to scheduled publication using state-based database logic and secure API routes.

This skill provides a standardized framework for implementing admin-controlled publishing systems within Claude Code. It automates the creation of robust workflows—including draft states, review cycles, and scheduled visibility—ensuring consistency across database schemas and API endpoints. By utilizing predefined patterns for start and end timestamps, it allows developers to quickly build secure systems for news, policy updates, and templates while maintaining a strict separation between administrative management and public-facing data retrieval.

主要功能

01Time-Based Visibility Logic using startAt and endAt timestamps

02Database schema templates for content lifecycle management

03Separation of concerns between /api/admin and public endpoints

04Automated implementation of CRUD operations for admin dashboards

05Standardized State Machine (Draft, Review, Scheduled, Published)

060 GitHub stars

使用场景

01Creating time-limited marketing templates or ruleset activations

02Managing policy or regulation updates requiring internal review cycles

03Implementing a news or blog system with scheduled post visibility

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lee-sang-bok/vkc-2- vkc-admin-ops-workflow

For use in Claude.ai and ChatGPT

Download Skill