lp-state-manager

Manage LittlePea pipeline workflow state via SQLite-backed commands.

Updated Apr 14, 2026

Search Tags:#automation #workflow #database #python #sqlite #state-management #lp

Ready to run

npx skills add https://github.com/daudaudinang/vibecode --skill lp-state-manager

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: lp-state-manager
Source: https://github.com/daudaudinang/vibecode/tree/main/.agents/skills/lp-state-manager
Command: npx skills add https://github.com/daudaudinang/vibecode --skill lp-state-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Centralizes and standardizes the management of LittlePea pipeline state using a SQLite-backed script, replacing ad-hoc JSON edits and manual grep operations.

Core Features & Use Cases

Create and read workflow state records across /lp:spec, /lp:plan, /lp:implement, and /lp:cook.
Update steps, gates, artifacts, and events, and derive the next recommended action.
Bootstraps a project-scoped database at .codex/state/pipeline_state.db and supports workflow searches by plan name.

Quick Start

Initialize a new workflow for a given plan and begin tracking steps, gates, artifacts, and events with the state manager.

Frequently Asked Questions about lp-state-manager

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I manage SQLite workflow state for a Python pipeline without manual JSON edits?▼

You can manage SQLite workflow state by running a Python script that centralizes pipeline tracking, replacing manual JSON edits with structured database commands to create, update, and query workflow steps and artifacts.

What is the best way to track pipeline steps and gates in a SQLite database?▼

Tracking pipeline steps and gates in a SQLite database is done using upsert-step and set-gate commands, which standardize workflow state records and eliminate ad-hoc grep operations across project files.

Can I use Python and SQLite to find existing workflows by plan name?▼

Yes, you can use Python and SQLite to find existing workflows by plan name using the find-workflows command, which queries the project-scoped database to locate specific pipeline records.

How do I initialize a SQLite database for workflow state management in my repository?▼

To initialize SQLite workflow state management, run the state manager script inside your repository root, which automatically bootstraps a project-scoped database at .codex/state/pipeline_state.db.

How does a state manager script derive the next recommended step in a workflow?▼

A state manager script derives the next recommended workflow step by evaluating current steps, gates, and artifacts in the SQLite database, using the resolve-next command to calculate the subsequent action.

Do I need to run the workflow state script from a specific directory location?▼

Yes, the workflow state script requires running inside the repository root directory to correctly locate and bootstrap the project-scoped SQLite database at .codex/state/pipeline_state.db.