Skip to content

BRYANN2K/stipulate-skills / skills/stip-bootstrap

stip-bootstrap

Verified

Adopt Stip in a new or existing repository, preserving project conventions and assessing applicable domains.

FileKindSize
SKILL.mdskill md3.9 KB
assets/extensions/accessibility/apply.mdmarkdown1.5 KB
assets/extensions/accessibility/check.mdmarkdown2.5 KB
assets/extensions/accessibility/docs.mdmarkdown957 B
assets/extensions/accessibility/evaluation.jsonconfig1.4 KB
assets/extensions/accessibility/explore.mdmarkdown5.7 KB
assets/extensions/accessibility/extension.jsonconfig266 B
assets/extensions/accessibility/sources.mdmarkdown1.7 KB
assets/extensions/ai-engineering/apply.mdmarkdown1.5 KB
assets/extensions/ai-engineering/check.mdmarkdown2.4 KB
assets/extensions/ai-engineering/docs.mdmarkdown973 B
assets/extensions/ai-engineering/evaluation.jsonconfig1.4 KB
assets/extensions/ai-engineering/explore.mdmarkdown5.8 KB
assets/extensions/ai-engineering/extension.jsonconfig261 B
assets/extensions/ai-engineering/sources.mdmarkdown1.3 KB
assets/extensions/analytics-experimentation/apply.mdmarkdown1.5 KB
assets/extensions/analytics-experimentation/check.mdmarkdown2.5 KB
assets/extensions/analytics-experimentation/docs.mdmarkdown969 B
assets/extensions/analytics-experimentation/evaluation.jsonconfig1.4 KB
assets/extensions/analytics-experimentation/explore.mdmarkdown5.7 KB
assets/extensions/analytics-experimentation/extension.jsonconfig262 B
assets/extensions/analytics-experimentation/sources.mdmarkdown1.6 KB
assets/extensions/api-integrations/apply.mdmarkdown1.5 KB
assets/extensions/api-integrations/check.mdmarkdown2.6 KB
assets/extensions/api-integrations/docs.mdmarkdown959 B
assets/extensions/api-integrations/evaluation.jsonconfig1.4 KB
assets/extensions/api-integrations/explore.mdmarkdown5.7 KB
assets/extensions/api-integrations/extension.jsonconfig256 B
assets/extensions/api-integrations/sources.mdmarkdown1.3 KB
assets/extensions/backend-engineering/apply.mdmarkdown1.5 KB
assets/extensions/backend-engineering/check.mdmarkdown2.4 KB
assets/extensions/backend-engineering/docs.mdmarkdown941 B
assets/extensions/backend-engineering/evaluation.jsonconfig1.4 KB
assets/extensions/backend-engineering/explore.mdmarkdown5.3 KB
assets/extensions/backend-engineering/extension.jsonconfig257 B
assets/extensions/backend-engineering/sources.mdmarkdown1.1 KB
assets/extensions/build-in-public/apply.mdmarkdown1.4 KB
assets/extensions/build-in-public/check.mdmarkdown2.7 KB
assets/extensions/build-in-public/docs.mdmarkdown975 B
assets/extensions/build-in-public/evaluation.jsonconfig1.4 KB
assets/extensions/build-in-public/explore.mdmarkdown6.3 KB
assets/extensions/build-in-public/extension.jsonconfig257 B
assets/extensions/build-in-public/sources.mdmarkdown1.8 KB
assets/extensions/catalog.jsonconfig5.1 KB
assets/extensions/cli-tooling/apply.mdmarkdown1.5 KB
assets/extensions/cli-tooling/check.mdmarkdown2.2 KB
assets/extensions/cli-tooling/docs.mdmarkdown946 B
assets/extensions/cli-tooling/evaluation.jsonconfig1.4 KB
assets/extensions/cli-tooling/explore.mdmarkdown4.9 KB
assets/extensions/cli-tooling/extension.jsonconfig228 B
assets/extensions/cli-tooling/sources.mdmarkdown1.2 KB
assets/extensions/cloud-engineering/apply.mdmarkdown1.5 KB
assets/extensions/cloud-engineering/check.mdmarkdown2.2 KB
assets/extensions/cloud-engineering/docs.mdmarkdown952 B
assets/extensions/cloud-engineering/evaluation.jsonconfig1.4 KB
assets/extensions/cloud-engineering/explore.mdmarkdown5.2 KB
assets/extensions/cloud-engineering/extension.jsonconfig270 B
assets/extensions/cloud-engineering/sources.mdmarkdown1.0 KB
assets/extensions/content-design/apply.mdmarkdown1.4 KB
assets/extensions/content-design/check.mdmarkdown2.6 KB
assets/extensions/content-design/docs.mdmarkdown961 B
assets/extensions/content-design/evaluation.jsonconfig1.4 KB
assets/extensions/content-design/explore.mdmarkdown5.5 KB
assets/extensions/content-design/extension.jsonconfig257 B
assets/extensions/content-design/sources.mdmarkdown1.6 KB
assets/extensions/customer-support/apply.mdmarkdown1.5 KB
assets/extensions/customer-support/check.mdmarkdown2.2 KB
assets/extensions/customer-support/docs.mdmarkdown946 B
assets/extensions/customer-support/evaluation.jsonconfig1.4 KB
assets/extensions/customer-support/explore.mdmarkdown5.3 KB
assets/extensions/customer-support/extension.jsonconfig253 B
assets/extensions/customer-support/sources.mdmarkdown1.2 KB
assets/extensions/data-engineering/apply.mdmarkdown1.5 KB
assets/extensions/data-engineering/check.mdmarkdown2.3 KB
assets/extensions/data-engineering/docs.mdmarkdown954 B
assets/extensions/data-engineering/evaluation.jsonconfig1.4 KB
assets/extensions/data-engineering/explore.mdmarkdown5.2 KB
assets/extensions/data-engineering/extension.jsonconfig247 B
assets/extensions/data-engineering/sources.mdmarkdown1.1 KB
assets/extensions/database-engineering/apply.mdmarkdown1.5 KB
assets/extensions/database-engineering/check.mdmarkdown2.4 KB
assets/extensions/database-engineering/docs.mdmarkdown967 B
assets/extensions/database-engineering/evaluation.jsonconfig1.4 KB
assets/extensions/database-engineering/explore.mdmarkdown5.4 KB
assets/extensions/database-engineering/extension.jsonconfig264 B
assets/extensions/database-engineering/sources.mdmarkdown1.1 KB
assets/extensions/design-system/apply.mdmarkdown1.4 KB
assets/extensions/design-system/check.mdmarkdown2.2 KB
assets/extensions/design-system/docs.mdmarkdown958 B
assets/extensions/design-system/evaluation.jsonconfig1.4 KB
assets/extensions/design-system/explore.mdmarkdown4.9 KB
assets/extensions/design-system/extension.jsonconfig259 B
assets/extensions/design-system/sources.mdmarkdown1.5 KB
assets/extensions/desktop-engineering/apply.mdmarkdown1.5 KB
assets/extensions/desktop-engineering/check.mdmarkdown2.2 KB
assets/extensions/desktop-engineering/docs.mdmarkdown947 B
assets/extensions/desktop-engineering/evaluation.jsonconfig1.4 KB
assets/extensions/desktop-engineering/explore.mdmarkdown5.5 KB
assets/extensions/desktop-engineering/extension.jsonconfig262 B
assets/extensions/desktop-engineering/sources.mdmarkdown1.5 KB
assets/extensions/devops-delivery/apply.mdmarkdown1.5 KB
assets/extensions/devops-delivery/check.mdmarkdown2.3 KB
assets/extensions/devops-delivery/docs.mdmarkdown956 B
assets/extensions/devops-delivery/evaluation.jsonconfig1.4 KB
assets/extensions/devops-delivery/explore.mdmarkdown5.3 KB
assets/extensions/devops-delivery/extension.jsonconfig243 B
assets/extensions/devops-delivery/sources.mdmarkdown1.0 KB
assets/extensions/frontend-engineering/apply.mdmarkdown1.5 KB
assets/extensions/frontend-engineering/check.mdmarkdown2.4 KB
assets/extensions/frontend-engineering/docs.mdmarkdown944 B
assets/extensions/frontend-engineering/evaluation.jsonconfig1.4 KB
assets/extensions/frontend-engineering/explore.mdmarkdown5.2 KB
assets/extensions/frontend-engineering/extension.jsonconfig257 B
assets/extensions/frontend-engineering/sources.mdmarkdown1.1 KB
assets/extensions/mobile-engineering/apply.mdmarkdown1.5 KB
assets/extensions/mobile-engineering/check.mdmarkdown2.2 KB
assets/extensions/mobile-engineering/docs.mdmarkdown970 B
assets/extensions/mobile-engineering/evaluation.jsonconfig1.4 KB
assets/extensions/mobile-engineering/explore.mdmarkdown5.2 KB
assets/extensions/mobile-engineering/extension.jsonconfig269 B
assets/extensions/mobile-engineering/sources.mdmarkdown1.3 KB
assets/extensions/privacy-engineering/apply.mdmarkdown1.5 KB
assets/extensions/privacy-engineering/check.mdmarkdown2.2 KB
assets/extensions/privacy-engineering/docs.mdmarkdown952 B
assets/extensions/privacy-engineering/evaluation.jsonconfig1.4 KB
assets/extensions/privacy-engineering/explore.mdmarkdown5.7 KB
assets/extensions/privacy-engineering/extension.jsonconfig264 B
assets/extensions/privacy-engineering/sources.mdmarkdown1.3 KB
assets/extensions/product-strategy/apply.mdmarkdown1.4 KB
assets/extensions/product-strategy/check.mdmarkdown2.3 KB
assets/extensions/product-strategy/docs.mdmarkdown964 B
assets/extensions/product-strategy/evaluation.jsonconfig1.4 KB
assets/extensions/product-strategy/explore.mdmarkdown5.2 KB
assets/extensions/product-strategy/extension.jsonconfig257 B
assets/extensions/product-strategy/sources.mdmarkdown1.4 KB
assets/extensions/quality-engineering/apply.mdmarkdown1.4 KB
assets/extensions/quality-engineering/check.mdmarkdown2.2 KB
assets/extensions/quality-engineering/docs.mdmarkdown942 B
assets/extensions/quality-engineering/evaluation.jsonconfig1.4 KB
assets/extensions/quality-engineering/explore.mdmarkdown5.1 KB
assets/extensions/quality-engineering/extension.jsonconfig257 B
assets/extensions/quality-engineering/sources.mdmarkdown1.4 KB
assets/extensions/release-management/apply.mdmarkdown1.5 KB
assets/extensions/release-management/check.mdmarkdown2.1 KB
assets/extensions/release-management/docs.mdmarkdown948 B
assets/extensions/release-management/evaluation.jsonconfig1.4 KB
assets/extensions/release-management/explore.mdmarkdown4.8 KB
assets/extensions/release-management/extension.jsonconfig262 B
assets/extensions/release-management/sources.mdmarkdown921 B
assets/extensions/security-bughunting/apply.mdmarkdown2.2 KB
assets/extensions/security-bughunting/check.mdmarkdown2.4 KB
assets/extensions/security-bughunting/docs.mdmarkdown1.4 KB
assets/extensions/security-bughunting/evaluation.jsonconfig1.4 KB
assets/extensions/security-bughunting/explore.mdmarkdown4.0 KB
assets/extensions/security-bughunting/extension.jsonconfig284 B
assets/extensions/security-bughunting/sources.mdmarkdown1.3 KB
assets/extensions/security-engineering/apply.mdmarkdown1.5 KB
assets/extensions/security-engineering/check.mdmarkdown2.3 KB
assets/extensions/security-engineering/docs.mdmarkdown944 B
assets/extensions/security-engineering/evaluation.jsonconfig1.4 KB
assets/extensions/security-engineering/explore.mdmarkdown5.1 KB
assets/extensions/security-engineering/extension.jsonconfig252 B
assets/extensions/security-engineering/sources.mdmarkdown1003 B
assets/extensions/seo-discoverability/apply.mdmarkdown1.5 KB
assets/extensions/seo-discoverability/check.mdmarkdown2.1 KB
assets/extensions/seo-discoverability/docs.mdmarkdown957 B
assets/extensions/seo-discoverability/evaluation.jsonconfig1.4 KB
assets/extensions/seo-discoverability/explore.mdmarkdown5.0 KB
assets/extensions/seo-discoverability/extension.jsonconfig260 B
assets/extensions/seo-discoverability/sources.mdmarkdown1.1 KB
assets/extensions/sre-operations/apply.mdmarkdown1.5 KB
assets/extensions/sre-operations/check.mdmarkdown2.1 KB
assets/extensions/sre-operations/docs.mdmarkdown945 B
assets/extensions/sre-operations/evaluation.jsonconfig1.4 KB
assets/extensions/sre-operations/explore.mdmarkdown4.9 KB
assets/extensions/sre-operations/extension.jsonconfig264 B
assets/extensions/sre-operations/sources.mdmarkdown989 B
assets/extensions/storytelling/apply.mdmarkdown1.5 KB
assets/extensions/storytelling/check.mdmarkdown2.4 KB
assets/extensions/storytelling/docs.mdmarkdown950 B
assets/extensions/storytelling/evaluation.jsonconfig1.4 KB
assets/extensions/storytelling/explore.mdmarkdown5.9 KB
assets/extensions/storytelling/extension.jsonconfig264 B
assets/extensions/storytelling/sources.mdmarkdown1.6 KB
assets/extensions/user-research/apply.mdmarkdown1.4 KB
assets/extensions/user-research/check.mdmarkdown2.4 KB
assets/extensions/user-research/docs.mdmarkdown990 B
assets/extensions/user-research/evaluation.jsonconfig1.4 KB
assets/extensions/user-research/explore.mdmarkdown5.6 KB
assets/extensions/user-research/extension.jsonconfig264 B
assets/extensions/user-research/sources.mdmarkdown1.6 KB
assets/extensions/ux-design/apply.mdmarkdown1.4 KB
assets/extensions/ux-design/check.mdmarkdown2.5 KB
assets/extensions/ux-design/docs.mdmarkdown938 B
assets/extensions/ux-design/evaluation.jsonconfig1.4 KB
assets/extensions/ux-design/explore.mdmarkdown5.3 KB
assets/extensions/ux-design/extension.jsonconfig230 B
assets/extensions/ux-design/sources.mdmarkdown1.4 KB
assets/extensions/visual-design/apply.mdmarkdown1.4 KB
assets/extensions/visual-design/check.mdmarkdown2.2 KB

assets/extensions/database-engineering/explore.md

View on GitHub
# database-engineering — explore

Preserve invariants, compatibility, performance, and recovery when changing persisted data.

## Decide whether this domain is relevant

Availability in configuration does not activate this domain. During `stip-explore`, select it only when its responsibility affects the change or a decisive unknown. Do not activate the entire catalog. Relevant example: migrate a column used by two application versions without data loss. Out-of-scope example: change visual styling without affecting schemas, queries, or persistence.

This extension protects persisted data and the queries serving it: models, constraints, migrations, transactions, isolation, indexes, plans, backups, restoration, access, and schema evolution. Select it during `stip-explore` when adding or changing a table/collection, migration, nontrivial query, persistence invariant, retention policy, or backup/restore path. It can also apply when an API changes pagination or consistency without adding a table.

It does not apply to changes without persisted reads/writes unless performance or data contracts change. It does not choose PostgreSQL, SQLite, or an ORM for the project. The reviewed PostgreSQL 17 documentation describes MVCC visibility and concurrency while noting conflicts and deadlocks that still need handling ([Concurrency Control](https://www.postgresql.org/docs/17/mvcc.html)). It distinguishes estimated plans and costs from `EXPLAIN` and actual execution and row/time measurements from `EXPLAIN ANALYZE`; the latter can write data and requires a controlled environment, reversible transaction, or explicit authorization ([Using EXPLAIN](https://www.postgresql.org/docs/17/using-explain.html)). SQLite explains atomic commits, locks, and rollback after failure ([Atomic Commit](https://www.sqlite.org/atomiccommit.html)). These sources do not turn every CRUD change into optimization or failure testing.

## Recognize and reuse existing work

For a new project, identify schemas, data ownership, migrations, constraints, indexes, volume, critical queries, isolation, credentials, backups, restoration, and retention. For an existing project, inspect the actual database in a safe environment, read migrations and rollback procedures, measure queries with plans, simulate concurrency/duplicates, verify permissions, and restore a backup. Classify findings as **established** (reproducible DDL, plan, test, or restoration), **inferred** (unmeasured intent), **incomplete** (an engine, volume, or case missing), **missing** (search found no artifact), or **not-applicable** (no affected persisted data). A migration file does not establish compatibility with the previous version; a code constraint does not prove concurrent enforcement in the database.

OWASP recommends database isolation, API access for thick clients, encrypted transport when needed, and restricted privileges ([Database Security Cheat Sheet](https://cheatsheetseries.owasp.org/cheatsheets/Database_Security_Cheat_Sheet.html)). Use this to choose relevant controls based on observed project secrets and roles. `EXPLAIN` characterizes a dated plan; it does not establish performance at every cardinality.

Consult the bootstrap map, then seek only evidence relevant to the change. Classify each finding as **established, inferred, incomplete, missing, or not-applicable**, with evidence or justification. Missing documentation does not mean a practice is absent. Decide whether to reuse, complete, or replace existing work; an already satisfied step may require no further work.

## Scope the contribution to the shared contract

The MVP includes schema/migration, a key constraint, a read/write test, least-privilege access, an exercised migration, and measurement of the critical query. Go deeper for financial or personal data, high volume, destructive migrations, multiple clients, high concurrency, or critical restoration: test expand/contract compatibility, deadlocks, isolation, plans across cardinalities, backfill, restored backups, encryption, and role separation. Do not optimize from an isolated plan without representative load.

Propose only necessary properties and how to verify them, using the candidates in [check.md](check.md). The agent adapts and remaps them to `AC-1`, `AC-2`, etc., unique within the **shared specification**; the engine does not remap domain IDs. Do not create a parallel specification or approval. Each criterion must state the outcome, context, and expected evidence. A new requirement after approval requires revising the contract and obtaining renewed approval.

## Boundaries

`backend-engineering` owns business transactions, retries, and deployment; `api-integrations` exposes consistency and pagination; `data-engineering` covers analytical tables and lineage; `security-engineering` may deepen threat analysis. Avoid enforcing invariants only in the UI, combining data migration with incompatible changes, treating an unrestored backup as proof, or assuming indexes always reduce cost. SQLite and PostgreSQL have different properties; documentation examples do not establish behavior under this project's load. Changes without persistence or queries do not trigger this extension.

Other domains mentioned here are possible collaborators, never automatically activated dependencies. Cloud-only work does not activate UX/design. Detailed sources are in [sources.md](sources.md); they inform decisions and do not create additional implicit acceptance criteria.
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 196kUpdated Claude CodeCodexVerifiedInstall