12-factor-app

The Twelve-Factor App methodology for building scalable, maintainable cloud-native applications. Use when designing backend services, APIs, microservices, or any software-as-a-service application. Triggers on deployment patterns, configuration management, process architecture, logging, and infrastructure decisions.

Jump to install

Repository: pproenca/dot-skills
Last source activity: May 27, 2026 at 09:50
Detected SKILL.md language: English
Stars: 194
Forks: 17

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

A direct command skips the review prompt. Inspect the source before running it.

npx skills add https://github.com/pproenca/dot-skills --skill 12-factor-app

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

File Explorer

56 files

SKILL.md

Source instructions · Read-only preview

Back to search Back to installation

drizzle-nextjs-postgres

Drizzle ORM against PostgreSQL inside a Next.js App Router app. Covers client construction (globalThis singleton across HMR, serverless pool sizing, `prepare:false` behind PgBouncer/Supavisor, driver choice when you need interactive transactions, `server-only`), reads in Server Components under Next.js 16 Cache Components (`use cache` superseding `unstable_cache` and the `revalidate`/`dynamic` segment configs, Suspense boundaries, React `cache()` dedupe), Server Actions (authorization inside the action, `updateTag` vs `revalidateTag`, `after()`), Postgres schema types (timestamptz, identity vs serial, jsonb, numeric-as-string, bigint modes), drizzle-kit migrations (generate vs push, CONCURRENTLY outside the migrator, NOT VALID constraints, rename prompts), transactions and pooled connections, and Postgres query traps (keyset pagination, count cost, driver-dependent `db.execute()` shape, NOT IN nulls, prepared statements). Use when writing or reviewing Drizzle + Postgres code in Next.js.

2026-07-24

relational-data-modeling

Corrects the wrong defaults a model has when designing a relational schema — the DDL decisions an experienced engineer makes differently. Use when creating or reviewing tables, migrations, ER models, or ORM schema definitions. Covers identity and keys (surrogate vs natural, identity vs serial, uuidv7, composite keys that make cross-tenant references impossible), relationships (polymorphic foreign keys the database cannot enforce, referential actions, unindexed FK columns, disjoint subtypes), invariants the engine can prove instead of application code (EXCLUDE, partial unique indexes, CHECK limits, deferrable cycles, NOT VALID), types (timestamptz, exact money, range types, enum vs lookup table), derived and encoded data (generated columns, JSONB as an escape hatch), and time (events vs in-place updates, soft-delete flags that silently disable constraints, temporal keys). NOT for query tuning, index selection for read paths, or connection pooling.

2026-07-23

relational-database-design

Distills a logical relational-database design methodology into rules an agent applies while designing or reviewing a schema. Covers the design sequence (mission → tables → fields → keys → relationships → business rules → views → integrity review), one-subject-per-table decomposition, atomic single-valued fields, candidate/primary/foreign keys, relationship types with deletion rules and participation, the four levels of data integrity, database-vs-application business rules, validation tables, views for derived data, and the flat-file / spreadsheet / RDBMS-driven antipatterns to avoid. The structure is logical and RDBMS-agnostic, and normalized by construction. Use when designing a new relational schema, reviewing or refactoring an existing one, resolving redundant or repeating data, choosing keys, modeling relationships, or deciding where a constraint belongs.

2026-07-23

View all from this repository

name	12-factor-app
description	The Twelve-Factor App methodology for building scalable, maintainable cloud-native applications. Use when designing backend services, APIs, microservices, or any software-as-a-service application. Triggers on deployment patterns, configuration management, process architecture, logging, and infrastructure decisions.

Community Cloud-Native Applications Best Practices

Comprehensive methodology for building modern software-as-a-service applications that are portable, scalable, and maintainable. Contains 51 rules across 12 categories, covering the entire application lifecycle from codebase management to production operations.

When to Apply

Reference these guidelines when:

Designing new backend services or APIs
Containerizing applications for Kubernetes or Docker
Setting up CI/CD pipelines
Managing configuration across environments
Implementing logging and monitoring
Planning application scaling strategy
Debugging deployment or environment issues

Rule Categories by Priority

Priority	Category	Impact	Prefix
1	Codebase & Version Control	CRITICAL	`code-`
2	Dependencies	CRITICAL	`dep-`
3	Configuration	CRITICAL	`config-`
4	Backing Services	HIGH	`svc-`
5	Build, Release, Run	HIGH	`build-`

File	Description
references/_sections.md	Category definitions and ordering
assets/templates/_template.md	Template for new rules
metadata.json	Version and reference information

12-factor-app

Install options

Review the source files

Community Cloud-Native Applications Best Practices

When to Apply

Rule Categories by Priority

Community Cloud-Native Applications Best Practices

When to Apply

Rule Categories by Priority

Quick Reference

1. Codebase & Version Control (CRITICAL)

2. Dependencies (CRITICAL)

3. Configuration (CRITICAL)

4. Backing Services (HIGH)

5. Build, Release, Run (HIGH)

6. Processes & State (HIGH)

7. Concurrency & Scaling (HIGH)

8. Disposability (HIGH)

9. Port Binding (MEDIUM)

10. Dev/Prod Parity (MEDIUM)

11. Logging (MEDIUM)

12. Admin Processes (MEDIUM)

How to Use

Reference Files

12-factor-app

Source facts

Install options

Review the source files

More from this repository

Community Cloud-Native Applications Best Practices

When to Apply

Rule Categories by Priority

Community Cloud-Native Applications Best Practices

When to Apply

Rule Categories by Priority

Quick Reference

1. Codebase & Version Control (CRITICAL)

2. Dependencies (CRITICAL)

3. Configuration (CRITICAL)

4. Backing Services (HIGH)

5. Build, Release, Run (HIGH)

6. Processes & State (HIGH)

7. Concurrency & Scaling (HIGH)

8. Disposability (HIGH)

9. Port Binding (MEDIUM)

10. Dev/Prod Parity (MEDIUM)

11. Logging (MEDIUM)

12. Admin Processes (MEDIUM)

How to Use

Reference Files

More from this repository