Skip to main content

Sync Schema

  • AfterOpen setting up a connection, sync theyour database schemaconnection soand click Sync Schema to scan your schema.
  • SWAIN canwill inspectimport metadata including tables, columns, data typestypes, and constraints.
  • constraints
  • Schemasuch sync readsas primary keys, foreign keyskeys, uniqueness, and othernullability.
  • constraints
  • After syncing, you’ll see a visual summary of your schema.
  • The schema metadata drives the mapping UI for authentication, roles, and permissions, allowing you to generateselect relationshipstables and API endpoints.columns.
  • EnsurePrimary keys, foreign keys, and data types are automatically detected from your databaseexisting schema.
  • If your schema is up to date before syncing;changes, you can re‑re-sync if the schema changes.
  • Syncing prepares SWAIN to generateupdate endpointsSWAIN’s for your data model.metadata.