1. compliance
prorm
  • prorm documentation
  • Known test gaps
  • Architecture
  • Core concepts
  • Database types & coverage
  • Getting started
  • Going further
  • compliance
    • Compliance
    • The security toolkit: `prorm audit`
    • Checklists by regulation
    • Declaring personal data
    • Evidence bundles
    • Evidence
    • Frameworks: `@Security`
    • Jurisdictions
    • Platform policies
    • Protecting data
    • The regulation dataset
    • Residency and cross-border transfers
    • Retention & integrity
    • Status
    • Subject rights
  • decorators
    • prorm with decorators
    • Models with decorators
    • Querying a decorated model
    • Relations with decorators
  • diagrams
    • Diagram generators
    • Chen diagram
    • Class diagram
    • Dependency diagram
    • ER diagram
    • Flow diagram
    • From your models to a diagram
    • Gantt diagram
    • Index diagram
    • Migration diagram
    • Model diagram
    • Package diagram
    • Crow’s-foot diagram
    • Schema documentation
    • Sequence diagram
    • State diagram
    • Tree diagram
  • dialects
    • SQL dialects
    • AlloyDB Dialect
    • AlloyDB Omni Dialect
    • Amazon Athena Dialect
    • Aurora DSQL Dialect
    • Amazon Aurora MySQL Dialect
    • Amazon Aurora PostgreSQL Dialect
    • Azure Database for MySQL Dialect
    • Azure Database for PostgreSQL Dialect
    • Azure SQL Database Dialect
    • Azure SQL Managed Instance Dialect
    • Google BigQuery Dialect
    • Citus Dialect
    • ClickHouse dialect
    • Cloud Authentication (`cloud-auth`)
    • Cloud SQL for SQL Server Dialect
    • Cloud SQL for MySQL Dialect
    • Cloud SQL for PostgreSQL Dialect
    • CockroachDB Dialect
    • Azure Cosmos DB for PostgreSQL Dialect
    • CrateDB Dialect
    • Cloudflare D1 Dialect
    • Databricks dialect
    • IBM Db2 Dialect
    • Dolt Dialect
    • Apache Doris Dialect
    • Druid Dialect
    • DuckDB Dialect
    • Exasol dialect
    • Microsoft Fabric Data Warehouse Dialect
    • Firebird Dialect
    • Greenplum Dialect
    • SAP HANA Dialect
    • MySQL HeatWave Dialect
    • Azure Data Explorer (Kusto) Dialect — T-SQL
    • MariaDB Dialect
    • Materialize Dialect
    • MonetDB Dialect
    • MotherDuck Dialect
    • Microsoft SQL Server Dialect
    • MySQL Dialect
    • Neon Dialect
    • OceanBase Dialect
    • openGauss Dialect
    • Oracle Dialect
    • Oracle Autonomous Database Dialect
    • ParadeDB Dialect
    • PolarDB Dialect
    • PostgreSQL Dialect
    • Presto Dialect
    • QuestDB Dialect
    • Aurora RDS Data API Dialect (`rdsdata`)
    • Amazon RDS for Db2 Dialect
    • Amazon RDS for MariaDB Dialect
    • Amazon RDS for SQL Server Dialect
    • Amazon RDS for MySQL Dialect
    • Amazon RDS for Oracle Dialect
    • Amazon RDS for PostgreSQL Dialect
    • Amazon Redshift
    • Amazon Redshift Data API Dialect
    • RisingWave Dialect
    • rqlite Dialect
    • SingleStore Dialect
    • Snowflake Dialect
    • Google Cloud Spanner Dialect
    • Spanner (PostgreSQL interface) Dialect
    • SQLite Dialect
    • StarRocks Dialect
    • Supabase Dialect
    • Azure Synapse Analytics (dedicated SQL pool)
    • Teradata Dialect
    • TiDB Dialect
    • TimescaleDB Dialect
    • Trino Dialect
    • Turso / libSQL Dialect
    • Vertica dialect
    • Vitess Dialect
    • Yellowbrick Dialect
    • YugabyteDB Dialect
  • guides
    • Access rules and behaviour profiles
    • ArangoDB (AQL)
    • Associations
    • Audit levels and escalation
    • Audit logging
    • In the browser
    • Bulk operations
    • Caching
    • Capabilities, tiers and team roles
    • CLI
    • Cloudflare
    • Compliance & data protection
    • Connection Pooling & Performance
    • Security in the console
    • Couchbase: structured N1QL queries
    • Data types
    • Decorators
    • Eager loading
    • Enums and constants
    • Error handling & error types
    • Extensions
    • External fields
    • Foreign data wrappers
    • Graph databases
    • Hooks & lifecycle events
    • Indexes & constraints
    • InfluxDB: structured Flux pipelines
    • klock-errors
    • klock — the `.klock` file
    • Local databases (`prorm db up`)
    • Structured log search — Splunk, Graylog, Papertrail, Sumo Logic
    • Logging
    • Grafana Loki: structured LogQL queries
    • MCP server
    • Migrate — the data transfer subsystem
    • Migrations & Schema Sync
    • Models from an existing database
    • Defining models
    • Multiple databases
    • OrientDB, Neptune and TigerGraph
    • Passwords
    • Importing a Prisma schema
    • Structured PromQL and MetricsQL
    • Query firewall
    • QueryInterface
    • Query operators reference
    • Query optimization
    • Composing find options with `pipe()` and `Q`
    • Query safety: the fail-closed WHERE guard
    • Querying
    • Raw Queries & Query Building
    • Read replicas
    • Schema diffing & migration generation
    • Views, triggers & other schema objects
    • Scopes & default scopes
    • Seeders
    • SPARQL / RDF triplestores
    • SQL constants
    • SQL features
    • SQL function builders
    • SQLite advanced features
    • StoreKey — a prod-orm database as the storage
    • Streaming results
    • Terraform
    • Transactions & Isolation Levels
    • Type mapping: legacy and modern
    • TypeScript types
    • Database users, roles & privileges
    • Validation & constraints
    • Virtual & Computed Fields
    • Writing docs
  • javascript
    • prorm in JavaScript
    • Models in JavaScript
    • Querying in JavaScript
    • Relations in JavaScript
  • runbooks
    • Operational runbooks
    • Connection failures
    • Credential rotation
    • Failover
    • Incident checklist
    • Deploying klock v2
    • Migration rollback
  • running-databases
    • Running databases in Docker
    • Running prorm under Bun in Docker
    • Running Cassandra in Docker with prorm
    • Running ClickHouse in Docker with prorm
    • Running CockroachDB in Docker with prorm
    • Running prorm under Deno in Docker
    • Running Elasticsearch in Docker with prorm
    • Running MariaDB in Docker with prorm
    • Running MongoDB in Docker with prorm
  • prorm control plane
    • Introduction
    • Authentication
    • Errors
    • Getting started
      • Service
        • Is it up
        • This description
    • Account
      • Sign-up and verification
        • Create an account
        • Exchange credentials for a token
        • Verify with the emailed code
        • Verify by clicking the emailed link
        • Name the parent or guardian
        • What a consent link is about
        • Give consent for a child's account
        • Ask the parent or guardian again
        • Send a new code and link
      • Family
        • Everyone this account is responsible for
        • One child, in detail
        • Turn a limit on or off
      • Profile
        • Who am I
        • Change the account
        • Every address on the account
        • Add an address
        • Confirm an address with the code mailed to it
        • Mail a fresh code to an unconfirmed address
        • Make an address primary
        • Remove an address
        • What this caller may do
    • Security
      • Sessions
        • Everywhere this account is signed in
        • Sign out everywhere else
        • Sign one out
        • A token for the CLI on a named machine
        • A token for the customer console, from the staff one
        • Park a sign-in for the CLI to collect
        • The CLI collecting its sign-in
        • The team's members' live sessions
        • Sign a member's session out
        • Sign an account out everywhere
        • Everywhere the account is signed in
        • Sign an account's session out
      • Single sign-on
        • Begin a single sign-on
        • The provider's return
        • Link the signed-in account to a team's provider
        • Which team an address signs in to
        • The team's single sign-on, as a member sees it
        • Set the team's OpenID Connect provider up, or change it
        • Remove the provider
        • The team's domain claims and the DNS record each needs
        • Prove a claimed domain
      • MFA and passwords
        • Start enrolling a second factor
        • Prove the app has it
        • Remove the second factor
        • Ask for a reset link
        • Set a new password with the emailed token
      • Klock
        • Open a device-bound klock session
        • Check in, for the next grant
        • Step up the session asking
        • Rotate the device key
        • Freeze a session
        • Unfreeze a session
        • A guest grant
        • The revocation feed
        • The published keyset
        • What this control plane supports
      • Devices
        • Your devices, or a team's
        • Approve a new device's pairing code
        • One device
        • Rename a device
        • Revoke a device
        • Suspend a device
        • Reinstate a suspended device
        • Wipe a device
        • Ask a device to rotate its key
        • The team's members' devices
        • Revoke a member's device
        • An account's devices
        • Revoke an account's device
        • Wipe an account's device
        • The device fleet
      • Access rules and behaviour
        • The access rules that bear on you
        • Add an access rule
        • This request, as the rules see it
        • One access rule
        • Remove an access rule
        • The behaviour profiles that bear on you
        • Add or change a behaviour profile
        • The profile presets
        • Your behaviour findings
        • Acknowledge a finding
        • One behaviour profile
        • Remove a behaviour profile
        • The team's access rules
        • Add a team access rule
        • Remove a team access rule
        • The team's behaviour profiles
        • Add or change a team behaviour profile
        • Remove a team behaviour profile
        • What the team's profiles caught
        • Acknowledge a team finding
      • Recovery and lockdown
        • Ask for a recovery link
        • Recover access with the emailed code
        • Is the account locked down
        • Lock the account down
        • Release a lockdown
        • Lock a member down
        • Release a member's lockdown
      • MCP tokens
        • Make a delegated token for one MCP client
        • The account's delegated tokens
        • Revoke a delegated token
        • What a delegated token may do now
        • Run one MCP tool with a delegated token
        • Run a device-signed MCP tool call relayed by the MCP Worker
      • Kerberos
        • Give the team its own Kerberos realm
        • The team's realm
        • Remove the team's realm
    • Logging and monitoring
      • Audit log
        • What has been done to the account
        • What has happened to this account
        • The account's audit trail
      • Operations
        • Everything that has been asked of this database
        • One, with its steps
        • Stop it
        • Put a failed one back in the queue
        • Every operation, across all accounts
      • Metrics and events
        • Every measurement, for a graph
        • Who did what to it
    • Billing
      • Plans and pricing
        • What the plans allow
        • The rate card
        • What one database would cost
        • What this account is paying for, itemised
      • Subscriptions and invoices
        • What this month's invoice will say
        • What this account is on
        • What it has been charged
        • Start a Stripe Checkout session
        • Open the customer portal
        • Stripe's events
        • Buy more connection pools
      • Team billing
        • The team's billing account
        • What the team has been charged
        • What this month's invoice will say
        • The team's cards
        • Add a card, through a Stripe-hosted setup session
        • Make a card the team's default
        • Remove a card
        • Start the team paying
        • Open the Stripe portal on the team's customer
        • Change the team's plan
        • Who receives the team's bills
        • How the team pays for transfers
    • Support
      • Support chat
        • My conversations
        • Start a conversation
        • Every support conversation, open first
        • A ticket for the socket
        • One conversation, with who is in it and who is connected
        • Rename a group; open or close a support conversation
        • The lines, oldest first
        • Say something
        • Add somebody
        • Mark read
    • Administration
      • Users
        • Every account
        • One account, with everything hanging off it
        • Grant or revoke admin
        • Verify an account by hand
        • Lock or unlock sign-in
        • Allow or hold provisioning
        • Send the verification mail again
        • Set the plan by hand
      • Platform
        • Every database and store, across all accounts
        • The counts worth putting on a dashboard
      • Staff and permissions
        • What kind of admin the caller is, and which scopes they hold
        • The admin presets
        • Every admin, and the scopes each resolves to
        • Make an account an admin of a kind
        • Change an admin's kind, or a custom admin's scopes
        • Revoke admin
      • Team administration
        • Every team, with its owner and size
        • One team in full — members with their accounts, and projects
        • Hand the team to another member
        • Put an account in the team, active at once
        • Change a member's role
        • Remove a member
      • Assumed identities
        • Assume an identity — act as a customer account
        • The identities the caller holds open
        • End an assumed identity
      • Support inbox
        • The platform's addresses
        • Add a platform address
        • One address, with its counts
        • Change an address's label, routing, or whether it accepts mail
        • Remove an address that holds no mail
        • Make, adopt or repair the address's routing rule
        • Every admin's personal address, made where missing
        • File a raw message, as if it had arrived
        • The inbox
        • One message, whole
        • Mark a message
        • Hand a message to an admin, or take it back
        • Leave an internal note
        • Reply, from the address the message came to
        • What is waiting
    • Databases
      • Databases
        • Data stores
          • Every data store on the account
          • Provision a data store
          • Change a data store that is already running
          • One data store
          • Deprovision it
          • Report what it is using
          • How to reach a data store
        • Connections and credentials
          • The api keys on a database
          • Issue a key
          • Revoke a key
          • The engine users we created
          • Create a user inside the database
          • Give a user a new password
          • Drop a user
          • How the database is reached
          • Set how it is reached
          • Revoke every api key on it
          • How to connect to it
          • The ssh keys that open its bastion
          • Add a key, or have one made
          • The private half of a generated key, once
          • Revoke an ssh key
        • Schema and objects
          • The SQL objects we put in it
          • Create one, and apply it
          • What is in the database, as the engine reports it
          • One table
          • What it would run, without running it
          • Redefine an object in place
          • Drop it
          • The extensions installed in it
        • Migrations
          • A plan compiled to statements, recording nothing
          • The migrations recorded for it
          • Record one
          • Apply everything recorded and not yet run
          • Apply everything pending, oldest version first
        • Lifecycle
          • Grow or shrink it
          • Stop it accepting connections
          • Start it again
          • Move it to another region
        • Backups and replicas
          • Take a backup
          • The backups it has
          • Restore one into it
          • What has been restored into it, and from where
          • Its read copies
          • Add one
        • Policies
          • The catalog
          • One policy
          • What this database is held to
          • Switch a policy on, or change its knobs
          • Switch it off
          • Mark the policies reviewed
          • Evaluate the periodic policies now
          • Who is behind a credential
        • Passwordless
          • The database's passwordless sessions
          • Issue a passwordless session (v1)
          • Revoke a passwordless session
          • Bind a session to a device key
          • Issue a v2 session for a host to bind
          • Redeem an enrolment ticket on the host
          • Check a passwordless credential
          • Run one described query under a passwordless credential
        • Database roles
          • The database's roles
          • Define a role
          • One role
          • Change what a role permits
          • Delete a role, and revoke every key granted it
          • Grant a role, which mints a key
          • Who holds a role
          • The api keys bound to a role
        • Pools
          • A database's connection pools, and how busy each is
          • Open another pool
          • Rename a pool or change its size
          • Close a pool
        • Data plane
          • Run a query against a database
          • Several statements, in order, over one connection
          • Is this database answering
          • What the proxy itself is holding
        • Transfers
          • The strategies this account's tier may use
          • Price a transfer without creating it
          • The account's transfer jobs, newest first
          • Create a transfer job
          • One job, and whether its certificate holds
          • Cancel an unfinished job
          • Start a created job, confirming its price
          • Report a job's status (the runner, or the owner's side of a local run)
        • Every database on the account
        • Provision a database
        • Change a database that is already running
        • One database
        • Deprovision it
        • Read or write it
        • Report what it is using
        • The engines this API will provision
        • Where a managed database can be put
    • Teams
      • Teams
        • Members
          • Who is on it
          • Invite somebody
          • Accept an invitation
          • Change somebody's role
          • Remove somebody
        • Projects
          • The projects a team runs
          • Start one
          • Rename a project, or move its environment
          • Delete a project
          • One project, and what is in it
          • Put a database or store in it
          • What is in a project
          • Take one out
        • The teams this account is on
        • Start one
        • The twelve roles, and what each may do
        • Rename a team
        • Close a team
        • One team
        • Hand the team to somebody else
        • Leave a team
    • Schemas
      • Error
      • ValidationErrors
      • Token
      • PolicyCategory
      • PolicySeverity
      • PolicyAction
      • PolicyTrigger
      • PolicyParam
      • Policy
      • PolicyCatalog
      • PolicyAssignment
      • PolicyOutcome
      • PolicyFiring
      • CredentialTrace
      • Relation
      • Restrictions
      • ChildSummary
      • SignupRequest
      • SigninRequest
      • UpdateMeRequest
      • User
      • Address
      • GeoPoint
      • D1Region
      • Usage
      • UsageReport
      • Resource
      • Database
      • DataStore
      • NewDatabase
      • NewDataStore
      • QueryRequest
      • DatabasePrivilege
      • ApiKey
      • DbUser
      • Access
      • AccessRequest
      • DatabaseObject
      • NewDatabaseObject
      • NewMigration
      • SchemaOperation
      • Migration
      • Operation
      • Session
      • AdminPowers
      • Admin
      • AuditEntry
      • TeamRole
      • Conversation
      • ChatMessage
      • TeamSso
      • Team
      • TeamMember
      • SshKey
      • ConnectionInfo
      • InboxAddress
      • InboxMailbox
      • InboxMessageSummary
      • InboxMessage
      • InboxNote
      • Page
      • Quote
      • Plan
      • ApiError
      • CapabilityRefusal
      • KlockErrorCode
      • PageWindow
      • SessionView
      • KlockStepUpRequest
      • KlockOpenRequest
      • KlockOpenedSession
      • UpdateMeResult
      • CapabilitiesView
      • SessionLimits
      • Device
      • DeviceListed
      • DeviceTeamRef
      • DeviceCommand
      • DeviceAuditLine
      • DeviceActionRequest
      • StaffActionRequest
      • ManagedSession
      • SessionRevoked
      • AccessRule
      • AccessRuleRequest
      • BehaviourProfile
      • BehaviourProfileRequest
      • BehaviourProfileSaved
      • BehaviourFinding
      • BehaviourFindingAck
      • StepUpProof
      • Removed
      • MemberLockdownRequest
      • McpClient
      • McpDelegatedView
      • McpToolCall
      • McpForwardRequest
      • PasswordlessScope
      • RoleScope
      • PasswordlessSession
      • PasswordlessTlsMaterial
      • PasswordlessKerberosMaterial
      • ServiceDeviceKeys
      • ServiceSession
      • DatabaseRole
      • TransferEndpoint
      • TransferJobRequest
      • TransferQuote
      • TransferStrategy
      • TransferJob
      • TransferJobAccess
      • Pool
      • PoolAllowance
      • BillingSubscription
      • Invoice
      • BillingContact
      • PaymentMethod
      • UpcomingCharges
      • TeamBilling
      • TeamKerberosRealm
      • TeamSsoDomain
      • TeamSsoResponse
      • StoreConnection
      • BatchFailure
      • ProxyStatus
  1. compliance

Checklists by regulation

Each regulation, as a checklist in three columns: what it asks, what in this
library answers it, and what stays yours. The third column is the honest
one. A library can encrypt a column; it cannot appoint your data-protection
officer, sign your processor agreements, or decide that your legitimate
interest outweighs a subject's. Where a row says yours, plan for it.
Rows marked platform are answered by the managed platform's
policies when you run there, and are otherwise yours.
These tables are for reading. The checklists a tool evaluates, 171 items
across SOC 2, ISO/IEC 27001:2022, the HIPAA Security Rule, PCI DSS v4.0.1 and
GDPR, with a status per item, live in compliance/checklists/*.yaml and are
described on the security toolkit page.

GDPR (and UK GDPR)#

Start with @Jurisdiction('EU') — or the member state, 'EU-DE' — and
@Security({ frameworks: [SecurityFramework.GDPR] }).
ArticleAsksprormYours
5(1)(c) minimisationhold only what is needed@Personal on every personal field; the sheet lists what is helddeciding what is needed
5(1)(e) storage limitationno longer than necessary@Personal(…, { retention }), DataRetentionPolicy, weekly purge (platform)the schedule, if not on the platform
6 lawful basisa basis for every processing@Personal(…, { basis }) — refused without one under EU; a basis India does not recognise is refused under EU+INchoosing the right basis; the legitimate-interests assessment
7 consentdemonstrable, withdrawableConsentRecord — append-only, versioned, with withdrawalthe consent UI; not bundling
8 childrenconsent age 13–16 by member state; parental consent belowthe age gate on @DataSubjectAge / @ParentalConsent; per-state ages in the registry; the parental flow (platform)verifying the parent is a parent
9 special categoriesexplicit basis and purposerefused without boththe Art. 9(2) exemption you rely on
12–14 transparencytell them what you dorenderComplianceSheet() is the material for the noticethe notice itself
15 access, 20 portabilitywithin one month, in a usable formatDSARWorkflow, DataPortabilityExporter (JSON/CSV/NDJSON); requestDeadlineDays: 30 on the sheetidentity verification; the deadline tracking table
16 rectificationan update() — and the audit trail records itthe request handling
17 erasureRightToErasure with cascade; subject: true keys itbackups; the erasure register
18 restriction, 21 objectionDSARWorkflow request typesthe processing pause itself
22 automated decisions—yours entirely
25 by design and defaultthe declaration is the design record; @Security the defaults
28 processors—your DPA with the platform / host
30 records of processingthe sheets, one per modelassembling the register
32 securityencryption, pseudonymisation, integrity, resilienceFieldEncryption, PseudonymizationService, ImmutableRecord, audit trail; backups and restores (platform)key management; the risk assessment
33 breach to the regulator within 72 hbreachNotificationHours: 72 on the sheet; compliance.breach-clock.72h reminder (platform); BreachDetectordetecting a breach you did not cause; the notification
34 breach to subjects—yours
35 DPIAbefore high-risk processingPrivacyImpactAssessment records and approvalsdoing the assessment
37 DPO—yours
44–49 transfersadequacy, SCCs, or derogationsCrossBorderLog.checkTransferAllowed(), the transfer log, the transfer-outside findingthe SCCs; the transfer impact assessment

Two GDPR rows, worked#

Art. 33, the 72-hour clock. The library's half is to notice and to start
counting. BreachDetector raises the alert, and the gdpr-72h-breach
escalation preset turns it into an incident that escalates at 4, 24, 48 and
66 hours while nobody acknowledges it (drawn as a timeline in
audit levels and escalation):
import {
  BreachDetector,
  forwardBreachAlerts,
  registerNotifier,
  useEscalationPolicy,
  WebhookNotifier,
} from 'ts-prorm-orm';

// The preset's channels: dpo, security, counsel, manager, exec.
registerNotifier(
  'dpo',
  new WebhookNotifier({ url: 'https://hooks.example.com/dpo', secret: process.env.DPO_HOOK_SECRET }),
);
registerNotifier(
  'security',
  new WebhookNotifier({ url: 'https://hooks.example.com/sec', secret: process.env.SEC_HOOK_SECRET }),
);

const manager = useEscalationPolicy(prorm, 'gdpr-72h-breach');
BreachDetector.create(prorm, { alertCallback: forwardBreachAlerts(manager, { tags: ['pii'] }) });
Deciding whether it is notifiable, and writing to the supervisory authority,
stay in the "yours" column.
Art. 28, processor contracts. Nothing in code can show this one, so the
checklist item is manual, and only a person moves it:
$ prorm audit attest gdpr.art28-processor-contracts \
    --by dpo@example.com --role "Data protection officer" \
    --statement "A signed DPA is on file for every processor in the register" \
    --evidence DPA-2026-003,DPA-2026-011
✓ Attestation recorded: .prorm/attestations/gdpr.art28-processor-contracts.yaml
The next prorm audit run --framework gdpr reports that item as attested,
with the reason Attested by dpo@example.com (Data protection officer) on 2026-09-26. It stays attested until the attestation expires (one year after
its date unless you pass --expires) or the item's freshness window runs out,
whichever comes first.

CCPA / CPRA (California) and the US state acts#

@Jurisdiction('US-CA') — or 'US-VA', 'US-CO', and the rest. Federal
COPPA is layered in automatically. @Security({ frameworks: [SecurityFramework.CCPA] }).
SectionAsksprormYours
1798.100 notice at collectionthe sheet's "what is held"the notice
1798.105 deletion45 daysRightToErasure; requestDeadlineDays: 45verification; service-provider pass-through
1798.110/115 knowDataPortabilityExporter
1798.120 opt out of sale/sharingConsentRecord with purpose 'sale'; opt-out-sale on the sheetthe "Do Not Sell" link; honouring GPC
1798.121 limit sensitive PIlimit-sensitive on the sheet; special categories declaredthe limit-use link
1798.125 non-discrimination—yours
1798.130 verified requestsDSARWorkflow statesthe verification
1798.140(ae) sensitive PIgovernment-id, location, protected, health, biometric, genetic are special under US-CA
children under 16opt-in to saleconsent age 16 under US-CA (13 in the other states); the age gatethe opt-in flow
1798.150 breach — reasonable securityencryption, masking, the audit trailthe incident response

HIPAA#

@Security({ frameworks: [SecurityFramework.HIPAA] }) with encrypt naming
the PHI columns; @Jurisdiction('US') marks health special.
SafeguardAsksprormYours
§164.312(a)(1) access controlunique user, role-basedRowLevelSecurity; database roles and GRANTs (User management)the user directory
§164.312(a)(2)(iv) encryption at restFieldEncryption on PHI columns; dedicated instances and disk encryption (platform)key custody
§164.312(b) audit controlsComplianceAuditTrail with user id and IPlog review
§164.312(c) integrityImmutableRecord, DataLineage
§164.312(d) authenticationapi keys per database and privilege; auth.failed.* policies (platform)your identity provider
§164.312(e) transmission securityTLSEnforcer; verify-full at the connection; access.require-verify-full (platform)
§164.308(a)(7) contingencybackups, restore testingBackupVerification register; real backups, data.restore-test.90d (platform)the plan
§164.530(j) retention 6 yearsDataRetentionPolicy with { years: 6 } on the trail
business associate agreement—yours, with the platform
minimum necessarymasking by role; @Personal purposethe policy

PCI DSS v4#

@Security({ frameworks: [SecurityFramework.PCI_DSS], encrypt: ['pan'], mask: { pan: 'card-first6' } }). Better still: do not store the PAN — tokenise at
the processor and hold the token.
RequirementAsksprormYours
3.4 PAN unreadableFieldEncryption; PseudonymizationService tokenskey management (3.6, 3.7)
3.4.1 masking on displayfirst six / last fourMask(…, { pattern: 'card-first6' | 'card-last4' })
3.2 no SAD after authorisation—do not store CVV; nothing here helps you store it safely
4.2 strong cryptography in transitTLSEnforcer; verify-full
6.2 secure developmentinjectionparameterised queries everywhere; QueryFirewall behind themcode review
7 least privilegereadonly / readwrite / admin keys; database rolesthe access matrix
8.3.9 password / key rotation≤ 90 dayscredentials.rotate.90d, credentials.key-age.90d, credentials.key-without-expiry (platform)rotation elsewhere
8.3 lockout on failed attemptsauth.failed.* (platform)
10 loggingevery access to cardholder dataaudit trail; events feed and query log (platform)12 months online, review
10.7 log integrityImmutableRecord on the trail; WORMStorage's SHA-256 chain (application-level)storage-level immutability
11 testing—your scans and pen tests
12 policy—yours

SOC 2 (Trust Services Criteria)#

@Security({ frameworks: [SecurityFramework.SOC_2] }) requires audit,
encryption and retention. SOC 2 is about your controls operating over a
period, so most of the evidence is firings and logs, not configuration.
CriterionAsksprormYours
CC6.1 logical accessper-database keys with privilege and expiry; auth.failed.*, compliance.owner-without-mfa (platform)the access review meeting
CC6.2 provisioning and deprovisioningcompliance.access-review.30d, credentials.idle-key.* (platform)acting on the review
CC6.3 role-basedrestrict-readonly policies; credentials.owner-key-exists (platform)
CC6.6 boundariesip allowlists; access.require-ip-allowlist, access.allowlist-cleared.* (platform)
CC6.7 data in transit / exfiltrationaccess.bulk-read.* (platform); TLSDLP beyond the database
CC7.2 anomaly detectionBreachDetector; auth.new-country.*, auth.new-ip.notify (platform)triage
CC7.3–7.5 incident responsethe events feed; policy.fired with outcomesthe runbook
CC8.1 change managementchange.schema.*, change.migration.* (platform); migrationsapprovals
A1.2 backupsreal backups, data.backup-age.*, data.no-backup-ever (platform)
A1.3 recovery testingdata.restore-test.90d (platform)running one
CC2.1 / CC3.2 information and riskcompliance.sheet.30d, change.policy-review.90d (platform)reading them

SOX (and SEC 17a-4)#

@Security({ frameworks: [SecurityFramework.SOX] }) requires audit,
immutability, retention, lineage and WORM.
AsksprormYours
records cannot be alteredImmutableRecord; versioning appendsREVOKE UPDATE, DELETE at the database
seven-year retentionDataRetentionPolicy with { years: 7 }, and no shorter policy on those tables
write-once storageWORMStorage state machine with a SHA-256 tamper-evident chain (application-level)object-lock on the archive
who changed whatComplianceAuditTrail, DataLineagesegregation of duties
change controlchange.* policies (platform)approvals

COPPA and children generally#

The registry knows the age in every regime; the gate enforces it.
AsksprormYours
know the age@DataSubjectAge() on a date of birthasking for it neutrally
verifiable parental consent below the threshold@ParentalConsent() gate; the parent-nomination → consent flow with the parent named by email and username, consent links that expire (platform)the verification method COPPA accepts for your risk level
parents can review and deleteRightToErasure; a parent's dashboard over the child's account and its restrictions (platform)
no more than needed from a childchild is a special category under US, CA, IN, CN, SG, ZA, ID — needs basis and purpose
the child comes of ageemancipation at 18, automatically (platform)
no purchases by a childchild accounts cannot start billing (platform)

What no checklist can give you#

Three things recur in the "yours" column and are worth naming once.
A person who is accountable. GDPR calls them a controller and sometimes a
DPO; SOC 2 calls them control owners; HIPAA a privacy officer. The sheets and
the firings are addressed to that person. Decide who it is.
Verification of identity. Every subject-rights flow starts with "prove
you are who you say", and no ORM can do that. The workflow's states begin
after it.
The paperwork with third parties. Processor agreements, business associate
agreements, standard contractual clauses. The platform will sign its side;
the obligation to have them is yours.
Next: Platform policies.
Modified at 2026-10-04 00:40:16
Previous
The security toolkit: `prorm audit`
Next
Declaring personal data
Built with