How do I create a new entity SQL schema?

How do I create the SQL schema for a new entity in ORE Studio?

1. Confirm the org model under projects/ores.<component>/modeling/ carries #+type: ores.codegen.entity (UUID PK) or ores.codegen.junction (composite text PK). Scaffold it with compass add entity_org if it does not exist yet.
2. Generate the SQL schema file (written directly to projects/ores.sql/):

./compass.sh codegen entity generate <entity> --address ores.sql.schema

1. Register the new schema file in the orchestration script for the component (typically projects/ores.sql/scripts/{component}_schema.sh).
2. Add RLS policies for the new entity. Every entity table with tenant_id needs a tenant isolation policy; tables that also have party_id need a party isolation policy on top. Add them to projects/ores.sql/create/{component}/{component}_rls_policies_create.sql (create the file if the component has none) and register it in projects/ores.sql/create/rls/rls_create.sql. See SQL entity schema patterns §Row-Level Security for the exact policy templates.
3. Run schema validation:

./projects/ores.sql/utility/validate_schemas.sh

1. Raise a PR with title [sql] Add {entity} schema.

./projects/ores.sql/utility/validate_schemas.sh — verifies idempotency and naming conventions for all schema files.

• SQL entity schema patterns — naming conventions and idempotency rules.
• compass-codegen-add-sql-schema — skill that drives this workflow.
• Entity lifecycle — layer ordering overview.