tpp — community node-sqlite, community, ide skills, Claude Code, Cursor, Windsurf

v1.0.0
GitHub

About this Skill

Perfect for Development Agents needing structured project planning and execution using Technical Project Plans (TPP) and Test-Driven Development (TDD) Drop-in replacement for `node:sqlite`

photostructure photostructure
[6]
[0]
Updated: 2/24/2026

Agent Capability Analysis

The tpp skill by photostructure is an open-source community AI agent skill for Claude Code and other IDE workflows, helping agents execute tasks with better context, repeatability, and domain-specific guidance.

Ideal Agent Persona

Perfect for Development Agents needing structured project planning and execution using Technical Project Plans (TPP) and Test-Driven Development (TDD)

Core Value

Empowers agents to implement Kent Beck's Simple Design principles, adhere to TPP style guides, and leverage SQLite databases for efficient project management, utilizing TDD for robust testing and validation

↓ Capabilities Granted for tpp

Implementing TPP-guided project development
Conducting test-driven development with TDD
Managing project phases using SQLite databases

! Prerequisites & Limits

  • Requires prior reading of CLAUDE.md, SIMPLE-DESIGN.md, TDD.md, and TPP-GUIDE.md
  • SQLite database replacement needed
Labs Demo

Browser Sandbox Environment

⚡️ Ready to unleash?

Experience this Agent in a zero-setup browser environment powered by WebContainers. No installation required.

Boot Container Sandbox

tpp

Install tpp, an AI agent skill for AI agent workflows and automation. Works with Claude Code, Cursor, and Windsurf with one-command setup.

SKILL.md
Readonly

Work on TPP

Make progress on the referenced Technical Project Plan. Determine the current phase and take appropriate action.

Required Reading First

Before any work, you MUST read:

Process

1. Read the TPP

Find and read the referenced TPP from doc/todo/ (named ${priority}-${desc}.md). Identify the current phase from the checklist.

2. Take Action Based on Phase

PhaseAction
Research & PlanningRead referenced docs and code. Gather context. Update TPP with findings.
Write breaking testsFollow TDD approach - write failing tests first.
Design alternativesIterate on design with critiques, consider multiple approaches.
Breakdown of tasksCreate specific, verifiable task list with commands.
ImplementationWork through tasks sequentially. Update TPP as you go.
Review & RefinementReview changed code. Address issues. Check API compatibility.
Final IntegrationRun full test suite. Verify all acceptance criteria.
ReviewPresent completion proof to user.

3. Update the TPP

After each work session:

  • Check off completed phases/tasks
  • Add discoveries to Tribal Knowledge
  • Document failed approaches and why
  • Keep under 400 lines (trim redundancy)

4. Completion

When all phases are complete:

  1. Run verification commands from the TPP
  2. Ensure all tests pass (npm test)
  3. Review all changes for API compatibility with node:sqlite
  4. Present proof of completion to user
  5. After user approval, move TPP to doc/done/ with date prefix
bash
1# Example: P01-fix-aggregate-null.md -> 20250203-P01-fix-aggregate-null.md
2git mv doc/todo/P01-feature.md doc/done/$(date +%Y%m%d)-P01-feature.md

Phase Details

Research & Planning

  • Read all "Required reading" in the TPP
  • Explore referenced source files
  • Check Node.js SQLite and better-sqlite3 for API reference
  • Web search for prior art if needed
  • Consult ../node-addon-api/ for N-API questions
  • Document findings in the TPP

Design Alternatives

  • Generate 2-4 approaches
  • Critique each for simplicity, testability, maintainability
  • Consider API compatibility with node:sqlite
  • Iterate at least 3 times
  • Document final recommendation in TPP

Task Breakdown

Each task must include:

  • Clear deliverable
  • Files to change
  • Success criteria
  • Verification command

Implementation

  • Work tasks sequentially
  • Mark tasks complete as you go
  • Run verification after each task
  • Update TPP with any discoveries
  • Follow N-API best practices (see ../node-addon-api/)

Remember

  • Transfer expertise, not just instructions
  • Document what didn't work and why
  • Ask for clarification when uncertain
  • The next engineer should be able to continue seamlessly
  • Maintain API compatibility with node:sqlite

FAQ & Installation Steps

These questions and steps mirror the structured data on this page for better search understanding.

? Frequently Asked Questions

What is tpp?

Perfect for Development Agents needing structured project planning and execution using Technical Project Plans (TPP) and Test-Driven Development (TDD) Drop-in replacement for `node:sqlite`

How do I install tpp?

Run the command: npx killer-skills add photostructure/node-sqlite/tpp. It works with Cursor, Windsurf, VS Code, Claude Code, and 19+ other IDEs.

What are the use cases for tpp?

Key use cases include: Implementing TPP-guided project development, Conducting test-driven development with TDD, Managing project phases using SQLite databases.

Which IDEs are compatible with tpp?

This skill is compatible with Cursor, Windsurf, VS Code, Trae, Claude Code, OpenClaw, Aider, Codex, OpenCode, Goose, Cline, Roo Code, Kiro, Augment Code, Continue, GitHub Copilot, Sourcegraph Cody, and Amazon Q Developer. Use the Killer-Skills CLI for universal one-command installation.

Are there any limitations for tpp?

Requires prior reading of CLAUDE.md, SIMPLE-DESIGN.md, TDD.md, and TPP-GUIDE.md. SQLite database replacement needed.

↓ How To Install

  1. 1. Open your terminal

    Open the terminal or command line in your project directory.

  2. 2. Run the install command

    Run: npx killer-skills add photostructure/node-sqlite/tpp. The CLI will automatically detect your IDE or AI agent and configure the skill.

  3. 3. Start using the skill

    The skill is now active. Your AI agent can use tpp immediately in the current project.

Related Skills

Looking for an alternative to tpp or another community skill for your workflow? Explore these related open-source skills.

View All

widget-generator

Logo of f
f

f.k.a. Awesome ChatGPT Prompts. Share, discover, and collect prompts from the community. Free and open source — self-host for your organization with complete privacy.

★ 149.6k
⑂ 0
AI

flags

Logo of vercel
vercel

flags is a Next.js feature management skill that enables developers to efficiently add or modify framework feature flags, streamlining React application development.

★ 138.4k
⑂ 0
Browser

zustand

Logo of lobehub
lobehub

The ultimate space for work and life — to find, build, and collaborate with agent teammates that grow with you. We are taking agent harness to the next level — enabling multi-agent collaboration, effortless agent team design, and introducing agents as the unit of work interaction.

★ 72.8k
⑂ 0
AI

data-fetching

Logo of lobehub
lobehub

The ultimate space for work and life — to find, build, and collaborate with agent teammates that grow with you. We are taking agent harness to the next level — enabling multi-agent collaboration, effortless agent team design, and introducing agents as the unit of work interaction.

★ 72.8k
⑂ 0
AI