Product

Features

Capabilities at a glance. Scale by tier, not by rows or named users.

Database engines

  • SQL Server — Fabric Warehouse, Azure SQL; Entra ID or SQL login.
  • PostgreSQL, Oracle, MySQL — same features, dialect-aware SQL.
  • One deployment, one backend — all config. Platforms overview

Template catalog

  • Built-in common entities (reference and business templates) with metadata and defaults.
  • One-click install via UI/API: save YAML, deploy tables, import seed JSON or backend-specific SQL seed.
  • Install-time overrides for entity name, domain, display name, approval, and history behavior.

Entity definitions

  • Built-in YAML code editor — edit entity definitions directly in the app with validation-friendly workflow.
  • YAML — columns, refs, validations, optional consumption views.
  • Validate + tier checks before save; deploy / redeploy with schema preview.
  • YAML parse/validate endpoints, naming rules, and machine-readable error responses.

Deploy & schema lifecycle

  • Initial deploy, redeploy preview, full redeploy (archive + migrate), and deployment history.
  • Archive snapshot listing + restore, archive-table cleanup, and deployment removal actions.
  • Reference-safe migration workflow for production schema evolution.

Master data

  • List with filters (WHERE DSL), paging, sort.
  • Create, update, soft / hard delete; restore where allowed.
  • Validation endpoints for create/update, reference pickers, column suggestions, similar-record detection.
  • Bulk import/export (JSON, CSV, XLSX) Pro+.
  • Bulk update/delete by SQL filter and per-row SQL expression Enterprise — UI and API; see docs.
  • Time travel Enterprise — view and export published data as of a UTC instant when historization is enabled; list/export asOfUtc, bounds API, clock control on Data. See docs.
  • Saved filters Enterprise — per-user named WHERE/view presets on the Data grid (flat entities); save, load, apply to URL, delete. See docs.
  • Aliases Pro+ — faster form prefill.

Approvals & history Pro+

  • Edit vs approved tables when approval is required.
  • Approve or reject by row or by edit_batch_name batch.
  • Optional history with valid-from / valid-to windows.
  • Entity analytics snapshot — per-column fill/null/distinct stats for data stewardship.

Permissions & audit

  • Scoped by domain and entity: read, write, approve, admin.
  • Entra app roles for global admins.
  • Permissions YAML import/export; role ↔ entity matrix.
  • Audit log query API Enterprise — who did what, when.

Admin controls

  • API keys — create/delete keys, optional global-admin mode, and scoped permissions.
  • Role management — list roles, assign/remove users in app roles.
  • Global admin tooling for permissions, webhooks, packages, and operational governance.

API & integrations

  • REST /api/v1/… + OpenAPI; stable problem+json codes.
  • Webhooks Enterprise — created/updated/deleted/edited/rejected/restored events.
  • Change log API Enterprise — incremental sync.
  • Packages (ZIP) Enterprise — promote entities + config across environments.
  • YAML import/export for permissions and webhooks; package deploy with overwrite controls.

Operations & runtime

  • Authentication modes: browser session (OIDC) plus bearer/API key for integrations.
  • Health endpoints for liveness/readiness and deployment-safe monitoring.
  • CLI for automation plus downloadable Windows and Ubuntu/Linux packages.

Security

  • Security headers — CSP, X-Frame-Options, HSTS, Referrer-Policy out of the box.
  • Rate limiting — configurable per-client API throttling (fixed window).
  • Webhook URL policy — configurable validation (default off) with AllowAllExceptLocalhost or strict allowlist mode.
  • Audit-friendly blocking logs — blocked webhook calls are logged with mode, URL, and reason.
  • Data classification masking — built-in and custom restriction tags (managed in System security settings) are masked as * in views/exports unless the caller has view restricted permission.
  • Parameterized queries — all SQL via safe DSL; no raw user input in queries.
  • ZIP deploy safety — path traversal validation on package imports.
  • Regex timeout — validation patterns run with bounded execution time.

Web application

  • Entity hub, YAML editor, grids, pending approvals, audit, permissions.
  • Package tools for admins Enterprise.
  • Saved Data grid filters Enterprise — named WHERE presets, apply to URL, per user.
  • Blazor Server — responsive layouts for day-to-day MDM work.