Pattern Catalog, page 34
The AI-Built Software Pattern Catalog — 2,557 active patterns across 119 bundles. Each pattern describes a specific failure mode in AI-built software, with citation against CWE, OWASP, WCAG, NIST, and other standards. Detection criteria ship inside the audits (free for Stack Scan patterns, Pro for the rest); the published definitions, rationale, and remediation are licensed CC-BY-4.0.
2,557 / 2,557
- FBL processing automatedab-000943 · deliverability-engineeringProhigh
- Hard bounce results in immediate permanent suppressionab-000940 · deliverability-engineeringProhigh
- Soft bounce tracking with escalation to suppressionab-000941 · deliverability-engineeringProhigh
- Database connections use SSL/TLSab-000917 · database-design-operationsProhigh
- Database user follows least privilege (not using superuser for application)ab-000915 · database-design-operationsPromedium
- No hardcoded database credentials in source codeab-000913 · database-design-operationsProcritical
- Row-Level Security (RLS) or equivalent access control on multi-tenant tablesab-000914 · database-design-operationsProhigh
- Sensitive data columns use encryption (at-rest encryption beyond platform defaults)ab-000916 · database-design-operationsPromedium
- Supabase tables have explicit per-role GRANTs and no blanket anon re-grantab-002653 · database-design-operationsProhigh
- Appropriate data types for each column (no stringly-typed data)ab-000901 · database-design-operationsPromedium
- Foreign keys enforce referential integrity between related tablesab-000898 · database-design-operationsProcritical
- Indexes exist on columns used in WHERE, JOIN, and ORDER BY clausesab-000899 · database-design-operationsProhigh
- Consistent naming convention across tables and columnsab-000902 · database-design-operationsProlow
- NOT NULL constraints on required fieldsab-000900 · database-design-operationsProhigh
- Every table has an explicit primary keyab-000897 · database-design-operationsProcritical
- Connection pooling configured (not new connection per request)ab-000905 · database-design-operationsProhigh
- No N+1 query patternsab-000903 · database-design-operationsProcritical
- Queries select specific columns instead of SELECT *ab-000907 · database-design-operationsProlow
- All user-facing queries use parameterized inputs (no string interpolation)ab-000904 · database-design-operationsProcritical
- Transactions used for multi-step mutationsab-000906 · database-design-operationsProhigh
- Connection pool metrics are monitoredab-000924 · database-design-operationsProinfo
- Health check endpoint includes database connectivity testab-000922 · database-design-operationsPromedium
- Slow query logging or monitoring is configuredab-000923 · database-design-operationsProlow
- A migration tool or framework is in useab-000908 · database-design-operationsProhigh
- All migration files are committed to version controlab-000911 · database-design-operationsPromedium
- Migrations are non-destructive (no data loss without explicit intent)ab-000909 · database-design-operationsProhigh
- Migrations have rollback capability (down migrations or revert scripts)ab-000910 · database-design-operationsPromedium
- At least 1 seed data script exists for development and testingab-000912 · database-design-operationsProlow
- Backup strategy is documentedab-000918 · database-design-operationsProhigh
- Database credentials are rotated on a defined scheduleab-000921 · database-design-operationsProlow
- Point-in-time recovery (PITR) is availableab-000919 · database-design-operationsPromedium
- Restore procedure has been tested at least 1 time with documented results.ab-000920 · database-design-operationsPromedium
- Dead source detection with alertingab-000879 · data-sourcing-provenanceProlow
- Per-source quality scoring implementedab-000877 · data-sourcing-provenancePromedium
- Source configuration versioned in codeab-000878 · data-sourcing-provenanceProlow
- Source-level metrics trackedab-000880 · data-sourcing-provenanceProlow
- Source type enum enforcedab-000876 · data-sourcing-provenanceProhigh
- Enrichment chain of custody trackedab-000888 · data-sourcing-provenancePromedium
- Provenance includes consent contextab-000891 · data-sourcing-provenanceProlow
- Provenance fields are immutable after creationab-000887 · data-sourcing-provenanceProhigh
- Provenance queryable for compliance lookupsab-000889 · data-sourcing-provenanceProhigh
- Every contact has source_type, source_id, and acquired_atab-000886 · data-sourcing-provenanceProcritical
- Source deletion cascades or anonymizes contactsab-000890 · data-sourcing-provenancePromedium
- API rate limit compliance enforcedab-000884 · data-sourcing-provenanceProhigh
- No scraping of login-walled content without ToS authorizationab-000885 · data-sourcing-provenanceProcritical
- Purchased list age verificationab-000883 · data-sourcing-provenanceProhigh
- robots.txt parser present and enforced for scrapersab-000881 · data-sourcing-provenanceProcritical
- Scraping rate limits configurable per-domainab-000882 · data-sourcing-provenanceProhigh
- Backpressure when pipeline is saturatedab-000896 · data-sourcing-provenanceProlow
- Dedup check before insertab-000893 · data-sourcing-provenanceProhigh