agentdb-state-manager

Store workflow state and analytics in AgentDB for repeatable queries.

3|Updated Aug 21, 2025
One-click install
npx skills add https://github.com/stharrold/yuimedi-paper-20250901 --skill agentdb-state-manager
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: agentdb-state-manager
Source: https://github.com/stharrold/yuimedi-paper-20250901/tree/main/.claude/skills/agentdb-state-manager
Command: npx skills add https://github.com/stharrold/yuimedi-paper-20250901 --skill agentdb-state-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb, and includes scripts (resource) components.

What problem does it solve?

This Skill eliminates the tedious manual work of tracking complex, multi-phase workflow states and dependencies. It provides a persistent, queryable database for all workflow data, drastically reducing the time and token cost associated with parsing files for analytics and state management.

Core Features & Use Cases

  • Persistent State Management: Stores workflow states, tasks, quality gates, and checkpoints in AgentDB (DuckDB) for reliable, long-term tracking.
  • Advanced Workflow Analytics: Enables complex queries for task dependencies, critical paths, historical metrics, and state transition analysis, offering deep insights into project progress.
  • Context Checkpoint Management: Automatically saves and restores AI context at token thresholds (e.g., 100K tokens), allowing for faster recovery and efficient session management.
  • Token Efficiency: Reduces token usage by up to 92% for complex queries compared to manual file parsing, optimizing AI operational costs.
  • Healthcare Compliance: Supports HIPAA, FDA 21 CFR Part 11, and IRB compliance with immutable audit trails and detailed Protected Health Information (PHI) access tracking.
  • Use Case: An AI agent is managing a large software development project. This skill allows it to instantly answer questions like "What tasks are currently blocking progress?" or "Show me the historical trend of test coverage over the last 30 days," without re-parsing all project files, thus accelerating decision-making and project oversight.

Quick Start

To analyze the current workflow state and task dependencies, use the following command: python .claude/skills/agentdb-state-manager/scripts/query_state.py --dependencies

Frequently Asked Questions about agentdb-state-manager

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

FAQPage Schema
How do I track workflow state and task dependencies across multiple project phases?

Workflow state tracking stores tasks, phases, and dependencies in a queryable database, enabling you to instantly resolve blockers and analyze critical paths without re-parsing files. This Skill persists that state in AgentDB (DuckDB) with scripts like query_state.py to surface dependencies and phase transitions.

Can I use DuckDB to manage analytics and compliance checkpoints for healthcare workflows?

Yes. This Skill stores workflow analytics and immutable audit trails in DuckDB, satisfying HIPAA, FDA 21 CFR Part 11, and IRB compliance requirements. It tracks Protected Health Information access and maintains idempotent writes via schema-driven state management.

How do I reduce token usage when querying project state and historical metrics?

Instead of parsing files repeatedly, query persisted workflow state and analytics directly from AgentDB. This approach reduces token consumption by up to 92% for complex queries, accelerating decision-making and lowering AI operational costs.

What's the best way to manage AI context checkpoints at token thresholds in long-running workflows?

Context checkpoint management automatically saves and restores AI context at token limits (e.g., 100K tokens) using checkpoint_manager.py. This enables faster recovery and efficient session management across multi-phase projects without manual context reconstruction.

Does this approach work for analyzing time-in-phase and task completion trends?

Yes. Advanced workflow analytics enable complex queries for historical metrics, state transitions, and time-in-phase analysis. Scripts like analyze_metrics.py extract trends from immutable audit trails, surfacing completion patterns and bottlenecks across project phases.