OptiTech
    Docs
    Log inBook a demo
    /APIs & SDKs/Checks, documents and data/data-api

    OptiTech CLI command: data-api

    Provision and manage the OptiTech Data API from the CLI

    The data-api command provisions and manages the OptiTech Data API for a database. For Console-based management, see Manage Data API.

    Requires optitech 2.22.2 or later. Check your version with optitech --version.

    Subcommands: create, delete, get, refresh-schema, update

    If --project-id, --branch, or --database are omitted, the CLI resolves them from your context file, auto-selects when there is only one option, and prompts otherwise.

    Settings flags

    The create and update subcommands share a set of settings flags that configure how the Data API serves your database:

    FlagDescriptionType
    --db-aggregates-enabledEnable aggregate functions in queriesboolean
    --db-anon-roleDatabase role used for anonymous (unauthenticated) requestsstring
    --db-extra-search-pathExtra schemas appended to the search pathstring
    --db-max-rowsMaximum number of rows returned by a single requestnumber
    --db-schemasComma-separated list of schemas exposed via the Data APIstring
    --jwt-role-claim-keyJWT claim path used to extract the rolestring
    --jwt-cache-max-lifetimeMaximum JWT cache lifetime in secondsnumber
    --openapi-modeOpenAPI mode. Choices: ignore-privileges, disabledstring
    --server-cors-allowed-originsCORS allowed originsstring
    --server-timing-enabledEnable Server-Timing response headersboolean

    optitech data-api create

    Provisions the OptiTech Data API for a database.

    optitech data-api create [options]
    OptionDescriptionTypeDefaultRequired
    --add-default-grantsGrant all permissions on tables in the public schema to authenticated usersboolean—No
    --auth-providerAuthentication provider Possible values: optitech_auth, externalstring—No
    --db-aggregates-enabledEnable aggregate functions in queriesboolean—No
    --db-anon-roleDatabase role used for anonymous (unauthenticated) requestsstring—No
    --db-extra-search-pathExtra schemas appended to the search pathstring—No
    --db-max-rowsMaximum number of rows returned by a single requestnumber—No
    --db-schemasComma-separated list of schemas exposed via the Data APIstring—No
    --jwks-urlURL that lists the JWKS (used with external auth)string—No
    --jwt-audienceExpected JWT audience claimstring—No
    --jwt-cache-max-lifetimeMaximum JWT cache lifetime in secondsnumber—No
    --jwt-role-claim-keyJWT claim path used to extract the rolestring—No
    --openapi-modeOpenAPI mode Possible values: ignore-privileges, disabledstring—No
    --provider-nameName of the auth provider (e.g. Clerk, Stytch, Auth0)string—No
    --server-cors-allowed-originsCORS allowed originsstring—No
    --server-timing-enabledEnable Server-Timing response headersboolean—No
    --skip-auth-schemaSkip creating the auth schema and RLS functionsboolean—No
    --branchBranch ID or namestring—No
    --databaseDatabase namestring—No
    --project-idProject IDstring—No

    create also accepts settings flags to configure the Data API at provision time.

    Provision the Data API with Managed Better Auth:

    optitech data-api create --database optitechdb --auth-provider optitech_auth

    optitech data-api get

    Shows the OptiTech Data API status and settings.

    optitech data-api get [options]
    OptionDescriptionTypeDefaultRequired
    --branchBranch ID or namestring—No
    --databaseDatabase namestring—No
    --project-idProject IDstring—No
    optitech data-api get --database optitechdb

    optitech data-api update

    Updates OptiTech Data API settings. By default, the flags you provide are merged with the current settings. Pass --replace to overwrite all settings with only the flags you provide.

    optitech data-api update [options]
    OptionDescriptionTypeDefaultRequired
    --db-aggregates-enabledEnable aggregate functions in queriesboolean—No
    --db-anon-roleDatabase role used for anonymous (unauthenticated) requestsstring—No
    --db-extra-search-pathExtra schemas appended to the search pathstring—No
    --db-max-rowsMaximum number of rows returned by a single requestnumber—No
    --db-schemasComma-separated list of schemas exposed via the Data APIstring—No
    --jwt-cache-max-lifetimeMaximum JWT cache lifetime in secondsnumber—No
    --jwt-role-claim-keyJWT claim path used to extract the rolestring—No
    --openapi-modeOpenAPI mode Possible values: ignore-privileges, disabledstring—No
    --replaceReplace settings with only the flags provided. Omitted settings revert to server defaults.booleanfalseNo
    --server-cors-allowed-originsCORS allowed originsstring—No
    --server-timing-enabledEnable Server-Timing response headersboolean—No
    --branchBranch ID or namestring—No
    --databaseDatabase namestring—No
    --project-idProject IDstring—No

    update requires at least one settings flag. To refresh the schema cache without changing settings, use refresh-schema instead.

    optitech data-api update --database optitechdb --db-max-rows 1000

    optitech data-api refresh-schema

    Refreshes the Data API schema cache without changing settings.

    optitech data-api refresh-schema [options]
    OptionDescriptionTypeDefaultRequired
    --branchBranch ID or namestring—No
    --databaseDatabase namestring—No
    --project-idProject IDstring—No
    optitech data-api refresh-schema --database optitechdb

    optitech data-api delete

    Deletes the OptiTech Data API for a database.

    optitech data-api delete [options]
    OptionDescriptionTypeDefaultRequired
    --branchBranch ID or namestring—No
    --databaseDatabase namestring—No
    --project-idProject IDstring—No
    optitech data-api delete --database optitechdb
    Was this page helpful?
    Previous bucketsNext optitech-auth

    On this page

    Copy neon init command