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

Content Management

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

About

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.

Key Features

Time-Based Visibility Logic using startAt and endAt timestamps
Database schema templates for content lifecycle management
Separation of concerns between /api/admin and public endpoints
Automated implementation of CRUD operations for admin dashboards
Standardized State Machine (Draft, Review, Scheduled, Published)
0 GitHub stars

Use Cases

Creating time-limited marketing templates or ruleset activations
Managing policy or regulation updates requiring internal review cycles
Implementing a news or blog system with scheduled post visibility

About

Key Features

Time-Based Visibility Logic using startAt and endAt timestamps
Database schema templates for content lifecycle management
Separation of concerns between /api/admin and public endpoints
Automated implementation of CRUD operations for admin dashboards
Standardized State Machine (Draft, Review, Scheduled, Published)
0 GitHub stars

Use Cases

Creating time-limited marketing templates or ruleset activations
Managing policy or regulation updates requiring internal review cycles
Implementing a news or blog system with scheduled post visibility