# CYPEX Documentation > Official CYPEX documentation — CYBERTEC's PostgreSQL Application Platform: Organizations, SSO, Connectors, and schema-driven applications. CYPEX is CYBERTEC's PostgreSQL Application Platform: API, security, workflows, and multi-tenant isolation live in PostgreSQL. Build apps at low-code speed; deploy with database guarantees. Current docs version: v2.0.0. Every documentation page and section has a Markdown twin at the same path ending in `index.md` — prefer those links when loading docs into an LLM or agent context. Prose, headings, tables, and code blocks are Markdown; callouts and figures appear as small HTML blocks, and all cross-links are resolved to absolute URLs. This home page is the exception; it is published as HTML only. ## Getting started - [Getting Started with CYPEX](https://cypex.app/getting_started/index.md): Complete first-run admin setup and build your first app with sample applications. ## Platform overview - [CYPEX Documentation](https://cypex.app/documentation/index.md): CYPEX documentation hub — administration, Organizations, SSO, Connectors, Application Designer, and migrations for the PostgreSQL Application Platform. - [Conceptual overview](https://cypex.app/documentation/migrations/v2-upgrade/conceptual-overview/index.md): Conceptual overview of the CYPEX v2.0.0 multi-tenant Organizations model with PostgreSQL Row-Level Security. - [Connectors setup guide](https://cypex.app/documentation/connectors/setup_guide/index.md): Hands-on connector setup: rollout, allowlist, credentials, the guided builder, and audit — from admin UI to a successful, sanitised API call. - [First-run setup guide](https://cypex.app/documentation/administration_panel/setup_guide/index.md): First-run walkthrough for a new CYPEX deployment: first login, organization setup, SSO, connectors, and launching the first application in under 30 minutes. - [Prepare the existing database](https://cypex.app/documentation/migrations/v2-upgrade/organizations/prepare-existing-database/index.md): Pre-flight checks, backups, and staging rehearsal before assigning clients to CYPEX organizations. - [Signing in](https://cypex.app/documentation/sso/signing-in/index.md): The redesigned CYPEX login screen in v2.0.0 — signing in with a password or through an identity provider, the organization picker, and pending approval. - [What is an Organization?](https://cypex.app/documentation/organizations/what-is-an-organization/index.md): An Organization is the unit of multi-tenancy in CYPEX: a tenant-scoped row filter enforced by PostgreSQL Row-Level Security driven by JWT claims. - [Breaking changes](https://cypex.app/documentation/migrations/v2-upgrade/breaking-changes/index.md): Breaking changes introduced by CYPEX v2.0.0: new permissions, new columns, new JWT claims, RLS enabled by default. - [Capabilities vs Data Scope](https://cypex.app/documentation/organizations/capabilities-vs-data-scope/index.md): Roles define what users can do (capabilities); Organizations define which rows they can act on (data scope). Both must agree before a query returns rows. - [Dashboard](https://cypex.app/documentation/administration_panel/dashboard/index.md): The CYPEX admin dashboard — the landing screen after login, the in-product Setup Guide, and the entry point to every section of the administration panel. - [Enable RLS](https://cypex.app/documentation/migrations/v2-upgrade/organizations/enable-rls/index.md): Step-by-step SQL for enabling PostgreSQL Row-Level Security on CYPEX application-schema tables and attaching the baseline policy. - [Filter builder](https://cypex.app/documentation/application_designer/filter_builder/index.md): The visual filter builder for fixed table and list filters in CYPEX v2.0.0 — build rules without writing an expression, or drop to the expression editor. - [OIDC setup guide](https://cypex.app/documentation/sso/oidc/index.md): Hands-on OIDC Gateway setup: add a provider (Azure AD, Keycloak, or any generic OIDC IdP), then trace the JWT claims through to PostgreSQL Row-Level Security. - [Assign clients to organizations](https://cypex.app/documentation/migrations/v2-upgrade/organizations/assign-clients-to-organizations/index.md): Use the client-add-organization-id SQL template to backfill organization_id on existing application-schema tables and assign clients to organizations. - [Behavior changes](https://cypex.app/documentation/migrations/v2-upgrade/behavior-changes/index.md): Behavior changes introduced by CYPEX v2.0.0: default password policy, default Organization, organization_id assignment, and JWT claims for DB sessions. - [Connector data sources](https://cypex.app/documentation/application_designer/connector_data_sources/index.md): Bind a Table, Form, or Autocomplete element to a governed external API connector in the CYPEX Application Designer — pick an operation, map parameters. - [Database](https://cypex.app/documentation/administration_panel/model_builder/index.md): Data Model — the CYPEX ER editor: tables, schemas, queries, workflows, default lookups, auditing, and organization-scoped data across every application. - [LDAP](https://cypex.app/documentation/sso/ldap/index.md): LDAP authentication in CYPEX: connect to a directory (including Active Directory), the three role-mapping modes, and how LDAP coexists with local auth. - [Organization hierarchy and assignment](https://cypex.app/documentation/organizations/org-hierarchy-and-assignment/index.md): How PostgreSQL roles, cypex.t_role_organization, and cypex.t_module_organization fit together — the Organizations model and how clients are assigned. - [Additive changes](https://cypex.app/documentation/migrations/v2-upgrade/additive-changes/index.md): Additive changes introduced by CYPEX v2.0.0: new tables, helper functions, indexes, and the cypex_default virtual module. - [Applications](https://cypex.app/documentation/administration_panel/build_apps/index.md): Applications — the CYPEX application list view: create, render, edit, launch, export, and delete applications. - [Organizations setup guide](https://cypex.app/documentation/organizations/setup_guide/index.md): Operational how-to: create and edit organizations, give users access, configure org-scoped Schema Access, and troubleshoot common misconfigurations. - [Pending and rejected users](https://cypex.app/documentation/sso/user-lifecycle/index.md): The SSO user lifecycle (pending, active, rejected): admin approve/reject/un-reject actions, organization assignment on approval, and the audit trail. - [Saving, save points and releases](https://cypex.app/documentation/application_designer/saving/index.md): How saving works in the CYPEX Application Designer — quick save with Ctrl+S, pre-filled save descriptions listing what changed, save points, and releases. - [Verify and roll back](https://cypex.app/documentation/migrations/v2-upgrade/organizations/verify-and-rollback/index.md): Verification queries and rollback procedure after assigning clients to CYPEX organizations. - [Building apps across organizations](https://cypex.app/documentation/organizations/multi-org-apps/index.md): Building CYPEX applications on a multi-tenant deployment: application visibility per organization, and export/import with organization context. - [Pre-upgrade checklist](https://cypex.app/documentation/migrations/v2-upgrade/pre-upgrade-checklist/index.md): Pre-upgrade checklist for CYPEX v2.0.0: backups, version checks, custom policies, role verification. - [Repository Applications](https://cypex.app/documentation/administration_panel/repository_applications/index.md): CYPEX admin — Repository Applications: load entire ready-to-use applications from a configured Git repository. - [Governance evidence](https://cypex.app/documentation/organizations/governance-evidence/index.md): Where governance evidence for Organization-related decisions lives — the permission audit log and the API event stream for organization management. - [Roles & Capabilities](https://cypex.app/documentation/administration_panel/roles/index.md): CYPEX admin — Roles & Capabilities: roles map to PostgreSQL users and define what operations they can perform; Organizations define where those apply. - [Upgrade test matrix](https://cypex.app/documentation/migrations/v2-upgrade/test-matrix/index.md): Upgrade test matrix for the v2.0.0 Organizations + RLS migration: scenarios executed, results, and the explicit answer on row visibility. - [RLS impact on existing data](https://cypex.app/documentation/migrations/v2-upgrade/rls-row-visibility/index.md): How CYPEX v2.0.0 RLS preserves row visibility for existing single-tenant data, and the queries to verify it on your instance. - [Users](https://cypex.app/documentation/administration_panel/users/index.md): CYPEX admin — Users: local users mapped to PostgreSQL roles, where the role drives both capabilities and organization access. Create and edit users. - [Access Preview](https://cypex.app/documentation/administration_panel/access_preview/index.md): CYPEX admin — Access Preview: see what a role can actually do and see across apps, queries, functions, and state transitions. - [Roles and permissions](https://cypex.app/documentation/migrations/v2-upgrade/roles-permissions/index.md): CYPEX v2.0.0 role model: cypex_admin, cypex_user, organization_admin, and the new JWT claims. - [Capabilities vs data scope (admin UI)](https://cypex.app/documentation/administration_panel/capabilities_vs_data_scope/index.md): CYPEX admin — how Capabilities (PostgreSQL role permissions) and Data Scope (Organization assignment) combine to decide what a user can do and see. - [Default password policy](https://cypex.app/documentation/migrations/v2-upgrade/password-policy/index.md): Default password policy inserted by the CYPEX v2.0.0 upgrade, with verification and override procedures. - [Organizations](https://cypex.app/documentation/administration_panel/organizations/index.md): CYPEX admin — Organizations: the multi-tenant data boundary, where it lives in the sidebar, and what an operator can change there. - [Rollback constraints](https://cypex.app/documentation/migrations/v2-upgrade/rollback-constraints/index.md): What can and cannot be rolled back after the CYPEX v2.0.0 upgrade: RLS, organization_id column, password policy, new tables. - [Schema Access](https://cypex.app/documentation/administration_panel/schema_access/index.md): CYPEX admin — Schema Access: grant PostgreSQL schemas (modules) to organizations. The coarsest access control in v2.0.0; check it first on an empty screen. - [SSO Providers](https://cypex.app/documentation/administration_panel/sso_providers/index.md): CYPEX admin — SSO Providers: configure OIDC/OAuth2 federation to your identity provider (Google, Microsoft, or any generic OIDC IdP). Sits alongside LDAP. - [LDAP (moved to Authentication & SSO)](https://cypex.app/documentation/administration_panel/ldap/index.md): CYPEX admin — LDAP has moved to the sso/ section. - [Login Settings](https://cypex.app/documentation/administration_panel/login_settings/index.md): CYPEX admin — Login Settings: configure the login-page logo and product name to match your company CI. - [Connector Execution](https://cypex.app/documentation/administration_panel/connector_enablement/index.md): CYPEX admin — Connector Execution: a two-step kill switch that controls whether connectors are allowed to run platform-wide and per organization. - [Connector Allowlist](https://cypex.app/documentation/administration_panel/connector_allowlist/index.md): CYPEX admin — Connector Allowlist: the hosts outbound connectors are permitted to call. Connectors cannot reach any host that is not allowlisted. - [Credentials](https://cypex.app/documentation/administration_panel/connector_secrets/index.md): CYPEX admin — Credentials (Integrations): write-only, versioned connector credentials, scoped per organization. - [Connectors](https://cypex.app/documentation/administration_panel/connectors/index.md): CYPEX admin — Connectors: build and publish governed REST connectors as immutable versions. - [REST API](https://cypex.app/documentation/administration_panel/data_api/index.md): CYPEX admin — REST API: every query is automatically exposed as an API endpoint. Test endpoints directly from the admin panel. - [Internal API](https://cypex.app/documentation/administration_panel/backend_api_explorer/index.md): CYPEX admin — Internal API: explore and test CYPEX backend endpoints from the generated OpenAPI specification. System Administrator only. - [Files](https://cypex.app/documentation/administration_panel/files/index.md): CYPEX admin — Files: upload, store, and serve binary content (images, documents, attachments) inside the database. - [User Reports](https://cypex.app/documentation/administration_panel/reports/index.md): CYPEX admin — Reports: browse and download PDF reports generated by CYPEX applications. - [Audit](https://cypex.app/documentation/administration_panel/audit/index.md): CYPEX admin — Audit: table-level change history (`cypex.t_history`) and user login activity under Monitor & Audit. - [Connector Audit](https://cypex.app/documentation/administration_panel/connector_audit/index.md): CYPEX admin — Connector Audit: execution history for outbound connectors, filterable by organization, connector, action, execution mode, and error category. - [Configuration](https://cypex.app/documentation/administration_panel/configuration/index.md): CYPEX admin — Configuration: system admin platform settings (instance-level, not tenant-level) — session length and connector SSRF protections. - [Sessions and tokens](https://cypex.app/documentation/administration_panel/sessions_and_tokens/index.md): How CYPEX sessions work in v2.0.0 — the short-lived access token, the refresh token that bounds the session, and the environment variables governing both. - [Database Migrations (runner)](https://cypex.app/documentation/administration_panel/migrations/index.md): CYPEX admin — Database Migrations: the in-app runner that applies CYPEX framework schema migrations. System Administrator only. - [Storage Repositories](https://cypex.app/documentation/administration_panel/storage_repositories/index.md): CYPEX admin — Storage Repositories: define Git repositories CYPEX uses to fetch extensions and ready-to-use applications. - [Internal Schema Browser](https://cypex.app/documentation/administration_panel/internal_schema_browser/index.md): CYPEX admin — Internal Schema Browser: read-only view of the internal cypex schema, for advanced debugging. System Administrator only. - [Install extensions](https://cypex.app/documentation/administration_panel/extensions/index.md): CYPEX admin — Extensions: install SQL fragments and procedures from a configured repository. ## Organizations and multi-tenancy - [Organizations & Row-Level Security](https://cypex.app/documentation/organizations/index.md): Multi-tenant Organizations in CYPEX: PostgreSQL Row-Level Security isolates tenants by JWT claims — not application-layer filters. - [What is an Organization?](https://cypex.app/documentation/organizations/what-is-an-organization/index.md): An Organization is the unit of multi-tenancy in CYPEX: a tenant-scoped row filter enforced by PostgreSQL Row-Level Security driven by JWT claims. - [Capabilities vs Data Scope](https://cypex.app/documentation/organizations/capabilities-vs-data-scope/index.md): Roles define what users can do (capabilities); Organizations define which rows they can act on (data scope). Both must agree before a query returns rows. - [Organization hierarchy and assignment](https://cypex.app/documentation/organizations/org-hierarchy-and-assignment/index.md): How PostgreSQL roles, cypex.t_role_organization, and cypex.t_module_organization fit together — the Organizations model and how clients are assigned. - [Organizations setup guide](https://cypex.app/documentation/organizations/setup_guide/index.md): Operational how-to: create and edit organizations, give users access, configure org-scoped Schema Access, and troubleshoot common misconfigurations. - [Building apps across organizations](https://cypex.app/documentation/organizations/multi-org-apps/index.md): Building CYPEX applications on a multi-tenant deployment: application visibility per organization, and export/import with organization context. - [Governance evidence](https://cypex.app/documentation/organizations/governance-evidence/index.md): Where governance evidence for Organization-related decisions lives — the permission audit log and the API event stream for organization management. ## Single sign-on - [SSO (OIDC & LDAP)](https://cypex.app/documentation/sso/index.md): Single Sign-On in CYPEX: OIDC or LDAP, ending in the same JWT claims and the same PostgreSQL Row-Level Security model as local auth. - [Signing in](https://cypex.app/documentation/sso/signing-in/index.md): The redesigned CYPEX login screen in v2.0.0 — signing in with a password or through an identity provider, the organization picker, and pending approval. - [OIDC setup guide](https://cypex.app/documentation/sso/oidc/index.md): Hands-on OIDC Gateway setup: add a provider (Azure AD, Keycloak, or any generic OIDC IdP), then trace the JWT claims through to PostgreSQL Row-Level Security. - [LDAP](https://cypex.app/documentation/sso/ldap/index.md): LDAP authentication in CYPEX: connect to a directory (including Active Directory), the three role-mapping modes, and how LDAP coexists with local auth. - [Pending and rejected users](https://cypex.app/documentation/sso/user-lifecycle/index.md): The SSO user lifecycle (pending, active, rejected): admin approve/reject/un-reject actions, organization assignment on approval, and the audit trail. ## Administration panel - [Administration Panel](https://cypex.app/documentation/administration_panel/index.md): CYPEX administration panel — the redesigned navigation map, first-run SetupGuide, and per-section reference for every admin entry point. - [First-run setup guide](https://cypex.app/documentation/administration_panel/setup_guide/index.md): First-run walkthrough for a new CYPEX deployment: first login, organization setup, SSO, connectors, and launching the first application in under 30 minutes. - [Dashboard](https://cypex.app/documentation/administration_panel/dashboard/index.md): The CYPEX admin dashboard — the landing screen after login, the in-product Setup Guide, and the entry point to every section of the administration panel. - [Database](https://cypex.app/documentation/administration_panel/model_builder/index.md): Data Model — the CYPEX ER editor: tables, schemas, queries, workflows, default lookups, auditing, and organization-scoped data across every application. - [Applications](https://cypex.app/documentation/administration_panel/build_apps/index.md): Applications — the CYPEX application list view: create, render, edit, launch, export, and delete applications. - [Repository Applications](https://cypex.app/documentation/administration_panel/repository_applications/index.md): CYPEX admin — Repository Applications: load entire ready-to-use applications from a configured Git repository. - [Roles & Capabilities](https://cypex.app/documentation/administration_panel/roles/index.md): CYPEX admin — Roles & Capabilities: roles map to PostgreSQL users and define what operations they can perform; Organizations define where those apply. - [Users](https://cypex.app/documentation/administration_panel/users/index.md): CYPEX admin — Users: local users mapped to PostgreSQL roles, where the role drives both capabilities and organization access. Create and edit users. - [Access Preview](https://cypex.app/documentation/administration_panel/access_preview/index.md): CYPEX admin — Access Preview: see what a role can actually do and see across apps, queries, functions, and state transitions. - [Capabilities vs data scope (admin UI)](https://cypex.app/documentation/administration_panel/capabilities_vs_data_scope/index.md): CYPEX admin — how Capabilities (PostgreSQL role permissions) and Data Scope (Organization assignment) combine to decide what a user can do and see. - [Organizations](https://cypex.app/documentation/administration_panel/organizations/index.md): CYPEX admin — Organizations: the multi-tenant data boundary, where it lives in the sidebar, and what an operator can change there. - [Schema Access](https://cypex.app/documentation/administration_panel/schema_access/index.md): CYPEX admin — Schema Access: grant PostgreSQL schemas (modules) to organizations. The coarsest access control in v2.0.0; check it first on an empty screen. - [SSO Providers](https://cypex.app/documentation/administration_panel/sso_providers/index.md): CYPEX admin — SSO Providers: configure OIDC/OAuth2 federation to your identity provider (Google, Microsoft, or any generic OIDC IdP). Sits alongside LDAP. - [LDAP (moved to Authentication & SSO)](https://cypex.app/documentation/administration_panel/ldap/index.md): CYPEX admin — LDAP has moved to the sso/ section. - [Login Settings](https://cypex.app/documentation/administration_panel/login_settings/index.md): CYPEX admin — Login Settings: configure the login-page logo and product name to match your company CI. - [Connector Execution](https://cypex.app/documentation/administration_panel/connector_enablement/index.md): CYPEX admin — Connector Execution: a two-step kill switch that controls whether connectors are allowed to run platform-wide and per organization. - [Connector Allowlist](https://cypex.app/documentation/administration_panel/connector_allowlist/index.md): CYPEX admin — Connector Allowlist: the hosts outbound connectors are permitted to call. Connectors cannot reach any host that is not allowlisted. - [Credentials](https://cypex.app/documentation/administration_panel/connector_secrets/index.md): CYPEX admin — Credentials (Integrations): write-only, versioned connector credentials, scoped per organization. - [Connectors](https://cypex.app/documentation/administration_panel/connectors/index.md): CYPEX admin — Connectors: build and publish governed REST connectors as immutable versions. - [REST API](https://cypex.app/documentation/administration_panel/data_api/index.md): CYPEX admin — REST API: every query is automatically exposed as an API endpoint. Test endpoints directly from the admin panel. - [Internal API](https://cypex.app/documentation/administration_panel/backend_api_explorer/index.md): CYPEX admin — Internal API: explore and test CYPEX backend endpoints from the generated OpenAPI specification. System Administrator only. - [Files](https://cypex.app/documentation/administration_panel/files/index.md): CYPEX admin — Files: upload, store, and serve binary content (images, documents, attachments) inside the database. - [User Reports](https://cypex.app/documentation/administration_panel/reports/index.md): CYPEX admin — Reports: browse and download PDF reports generated by CYPEX applications. - [Audit](https://cypex.app/documentation/administration_panel/audit/index.md): CYPEX admin — Audit: table-level change history (`cypex.t_history`) and user login activity under Monitor & Audit. - [Connector Audit](https://cypex.app/documentation/administration_panel/connector_audit/index.md): CYPEX admin — Connector Audit: execution history for outbound connectors, filterable by organization, connector, action, execution mode, and error category. - [Configuration](https://cypex.app/documentation/administration_panel/configuration/index.md): CYPEX admin — Configuration: system admin platform settings (instance-level, not tenant-level) — session length and connector SSRF protections. - [Sessions and tokens](https://cypex.app/documentation/administration_panel/sessions_and_tokens/index.md): How CYPEX sessions work in v2.0.0 — the short-lived access token, the refresh token that bounds the session, and the environment variables governing both. - [Database Migrations (runner)](https://cypex.app/documentation/administration_panel/migrations/index.md): CYPEX admin — Database Migrations: the in-app runner that applies CYPEX framework schema migrations. System Administrator only. - [Storage Repositories](https://cypex.app/documentation/administration_panel/storage_repositories/index.md): CYPEX admin — Storage Repositories: define Git repositories CYPEX uses to fetch extensions and ready-to-use applications. - [Internal Schema Browser](https://cypex.app/documentation/administration_panel/internal_schema_browser/index.md): CYPEX admin — Internal Schema Browser: read-only view of the internal cypex schema, for advanced debugging. System Administrator only. - [Install extensions](https://cypex.app/documentation/administration_panel/extensions/index.md): CYPEX admin — Extensions: install SQL fragments and procedures from a configured repository. ## Connectors - [API Connectors](https://cypex.app/documentation/connectors/index.md): Governed REST connectors in CYPEX — outbound calls with platform enablement, host allowlist, org-scoped credentials, and permission audit. - [Connectors setup guide](https://cypex.app/documentation/connectors/setup_guide/index.md): Hands-on connector setup: rollout, allowlist, credentials, the guided builder, and audit — from admin UI to a successful, sanitised API call. ## Application Designer - [Application Designer](https://cypex.app/documentation/application_designer/index.md): Guide to the CYPEX Application Designer — schema-driven application generation on the PostgreSQL Application Platform. - [Filter builder](https://cypex.app/documentation/application_designer/filter_builder/index.md): The visual filter builder for fixed table and list filters in CYPEX v2.0.0 — build rules without writing an expression, or drop to the expression editor. - [Connector data sources](https://cypex.app/documentation/application_designer/connector_data_sources/index.md): Bind a Table, Form, or Autocomplete element to a governed external API connector in the CYPEX Application Designer — pick an operation, map parameters. - [Saving, save points and releases](https://cypex.app/documentation/application_designer/saving/index.md): How saving works in the CYPEX Application Designer — quick save with Ctrl+S, pre-filled save descriptions listing what changed, save points, and releases. ## Upgrade to v2.0.0 - [Upgrade](https://cypex.app/documentation/upgrade/index.md): Mandatory operator upgrade guides for CYPEX major versions. ## Migration reference - [Migrations](https://cypex.app/documentation/migrations/index.md): Upgrade guides for moving CYPEX to multi-tenant Organizations — isolation enforced in PostgreSQL with Row-Level Security (RLS), not application filters. - [Conceptual overview](https://cypex.app/documentation/migrations/v2-upgrade/conceptual-overview/index.md): Conceptual overview of the CYPEX v2.0.0 multi-tenant Organizations model with PostgreSQL Row-Level Security. - [Prepare the existing database](https://cypex.app/documentation/migrations/v2-upgrade/organizations/prepare-existing-database/index.md): Pre-flight checks, backups, and staging rehearsal before assigning clients to CYPEX organizations. - [Breaking changes](https://cypex.app/documentation/migrations/v2-upgrade/breaking-changes/index.md): Breaking changes introduced by CYPEX v2.0.0: new permissions, new columns, new JWT claims, RLS enabled by default. - [Enable RLS](https://cypex.app/documentation/migrations/v2-upgrade/organizations/enable-rls/index.md): Step-by-step SQL for enabling PostgreSQL Row-Level Security on CYPEX application-schema tables and attaching the baseline policy. - [Assign clients to organizations](https://cypex.app/documentation/migrations/v2-upgrade/organizations/assign-clients-to-organizations/index.md): Use the client-add-organization-id SQL template to backfill organization_id on existing application-schema tables and assign clients to organizations. - [Behavior changes](https://cypex.app/documentation/migrations/v2-upgrade/behavior-changes/index.md): Behavior changes introduced by CYPEX v2.0.0: default password policy, default Organization, organization_id assignment, and JWT claims for DB sessions. - [Additive changes](https://cypex.app/documentation/migrations/v2-upgrade/additive-changes/index.md): Additive changes introduced by CYPEX v2.0.0: new tables, helper functions, indexes, and the cypex_default virtual module. - [Verify and roll back](https://cypex.app/documentation/migrations/v2-upgrade/organizations/verify-and-rollback/index.md): Verification queries and rollback procedure after assigning clients to CYPEX organizations. - [Pre-upgrade checklist](https://cypex.app/documentation/migrations/v2-upgrade/pre-upgrade-checklist/index.md): Pre-upgrade checklist for CYPEX v2.0.0: backups, version checks, custom policies, role verification. - [Upgrade test matrix](https://cypex.app/documentation/migrations/v2-upgrade/test-matrix/index.md): Upgrade test matrix for the v2.0.0 Organizations + RLS migration: scenarios executed, results, and the explicit answer on row visibility. - [RLS impact on existing data](https://cypex.app/documentation/migrations/v2-upgrade/rls-row-visibility/index.md): How CYPEX v2.0.0 RLS preserves row visibility for existing single-tenant data, and the queries to verify it on your instance. - [Roles and permissions](https://cypex.app/documentation/migrations/v2-upgrade/roles-permissions/index.md): CYPEX v2.0.0 role model: cypex_admin, cypex_user, organization_admin, and the new JWT claims. - [Default password policy](https://cypex.app/documentation/migrations/v2-upgrade/password-policy/index.md): Default password policy inserted by the CYPEX v2.0.0 upgrade, with verification and override procedures. - [Rollback constraints](https://cypex.app/documentation/migrations/v2-upgrade/rollback-constraints/index.md): What can and cannot be rolled back after the CYPEX v2.0.0 upgrade: RLS, organization_id column, password policy, new tables. ## Building applications - [User and authentication model](https://cypex.app/documentation/user_management/index.md): User management, authentication, and security configuration in CYPEX including integrated, SSO/OIDC, and LDAP authentication - [Workflows & State Transitions](https://cypex.app/documentation/workflows/index.md): Database-backed workflows in CYPEX — state machines with permissioned transitions, demonstrated with a TODO list application. - [Calling server side code](https://cypex.app/documentation/functions/index.md): Creating PostgreSQL functions in the CYPEX admin panel and calling them from an app as PostgREST RPC endpoints. - [Built-in expressions](https://cypex.app/documentation/expressions/index.md): Built-in expression system in CYPEX for calculations, formulas, and dynamic value computation in applications - [Layouts and themes](https://cypex.app/documentation/layouts/index.md): Customizing application layouts, themes, and styling in CYPEX applications - [Image and file elements](https://cypex.app/documentation/files/index.md): File storage and management system in CYPEX for handling file uploads, storage, and access control - [GIS / Spatial Data](https://cypex.app/documentation/gis_data/index.md): PostGIS-native geometry and geography in CYPEX — GeoJSON queries, map elements, and current UI limits. - [PDF Reports](https://cypex.app/documentation/pdf_reports/index.md): Creating and generating PDF reports in CYPEX applications with customizable layouts and data - [Scheduling jobs and Notifications](https://cypex.app/documentation/schedulling_jobs/index.md): Scheduling jobs and automated tasks in CYPEX using pg_timetable for background processing and notifications - [Sample Applications](https://cypex.app/documentation/sample_applications/index.md): Sample applications and tutorials for learning CYPEX application development ## Operations and lifecycle - [History Tracking](https://cypex.app/documentation/history_tracking/index.md): Row-level history tracking in CYPEX — enable auditing so INSERT/UPDATE/DELETE/TRUNCATE land in cypex.t_history with before/after images. - [Export & Import Applications](https://cypex.app/documentation/export_import/index.md): Export and import CYPEX application packages — schema, UI, workflows, permissions, and optional audit data — for promote, backup, and environment sync. - [Release Management](https://cypex.app/documentation/release_management/index.md): Managing application releases, versions, and deployment in CYPEX with save points and version control - [Merge Applications](https://cypex.app/documentation/merge_apps/index.md): Merging multiple CYPEX applications into a single application with conflict resolution and consolidation - [Extension catalogue](https://cypex.app/documentation/extensions/index.md): PostgreSQL extensions and custom functionality in CYPEX for extending platform capabilities - [CYPEX internals](https://cypex.app/documentation/cypex_internals/index.md): CYPEX platform internals, architecture, and technical reference documentation ## Reference - [CYPEX Glossary](https://cypex.app/documentation/glossary/index.md): Glossary of CYPEX terms from the admin panel, Application Designer, and v2.0.0 docs — Organizations, Capabilities, Data Scope, SSO, and Connectors. - [Terminology](https://cypex.app/documentation/terminology/index.md): Terminology and definitions used throughout CYPEX documentation - [Known bugs and pending improvements](https://cypex.app/documentation/known_bugs_and_pendings/index.md): Known bugs, limitations, and pending improvements in CYPEX - [CYPEX Online Academy](https://cypex.app/documentation/academy/index.md): Where to find the CYPEX Online Academy video curriculum, and the documentation pages that cover the same material in written form. ## Release notes - [CYPEX Release Notes](https://cypex.app/release_notes/index.md): Complete release notes and changelog for all CYPEX versions - [Release Notes v2.0.0](https://cypex.app/release_notes/v2.0.0/index.md): Release notes for CYPEX v2.0.0 — Organizations with database-enforced multi-tenancy, Capabilities vs Data Scope roles, Schema Access, and the SSO Gateway. - [Release Notes v1.9.3](https://cypex.app/release_notes/v1.9.3/index.md): Release notes for CYPEX v1.9.3 - Bug-fix release bridging v1.9.2 and v2.0.0. - [Release Notes v1.9.2](https://cypex.app/release_notes/v1.9.2/index.md): Release notes for CYPEX v1.9.2 - New input elements, UI enhancements, and architectural improvements - [Release Notes v1.9.1](https://cypex.app/release_notes/v1.9.1/index.md): Release notes for CYPEX v1.9.1 - PDF reporting, application merging, and PostgreSQL 16 support - [Release Notes v1.9.0](https://cypex.app/release_notes/v1.9.0/index.md): Release notes for CYPEX v1.9.0 - Admin roles, JWT configuration, and materialized views ## Optional - [About CYPEX](https://cypex.app/about/index.md): Core CYPEX concepts and the application life cycle — how PostgreSQL tables become deployable applications on the PostgreSQL Application Platform. - [Contact](https://cypex.app/contact/index.md): Contact CYBERTEC headquarters and regional offices for CYPEX support, sales, and PostgreSQL consulting. - [Product page](https://www.cybertec-postgresql.com/en/products/cypex-postgresql-low-code-development-platform/): Marketing overview of CYPEX - [Source repository](https://github.com/cybertec-postgresql/cypex-app): Application source on GitHub - [HTML documentation home](https://cypex.app/): Full HTML site with search and navigation - [Sitemap](https://cypex.app/sitemap.xml): Machine-readable list of indexable HTML pages