Error

A valid request URL is required to generate request examples

{
  "data": {
    "readOnly": {
      "title": "<string>",
      "sql": "<string>",
      "runAs": "<string>",
      "note": "<string>"
    },
    "write": {
      "title": "<string>",
      "sql": "<string>",
      "runAs": "<string>",
      "note": "<string>"
    },
    "generatedPassword": "<string>"
  }
}

Integrations

Generate database setup scripts

Generates the copy-paste SQL to create a scoped database user for the connection: a least-privilege read-only user (SELECT on current and future tables) and a scoped read-write script (INSERT/UPDATE on only the tables your write skills target — never blanket write). If you don’t supply a password, a strong one is generated and returned once. Pure generation — it never touches your database. Pass database (required), and optionally ro_user, rw_user, tables (comma-separated write-skill tables), and password.

GET

integrations

{kind}

sql

scripts

Error

A valid request URL is required to generate request examples

{
  "data": {
    "readOnly": {
      "title": "<string>",
      "sql": "<string>",
      "runAs": "<string>",
      "note": "<string>"
    },
    "write": {
      "title": "<string>",
      "sql": "<string>",
      "runAs": "<string>",
      "note": "<string>"
    },
    "generatedPassword": "<string>"
  }
}

Authorizations

Authorization

string

header

required

Flowyte secret API key (Authorization: Bearer flowyte_sk_live_…). Scope-gated; is scoped to your organization — a key can never reach another tenant. The listed scopes in each operation's apiKey requirement are the scopes that key must hold. The tokenUrl is nominal: keys are minted in the dashboard.

Path Parameters

kind

enum<string>

required

Available options:

google_calendar,

google_sheets,

calendly,

hubspot,

square,

opentable,

shopify,

postgres,

mysql

Query Parameters

database

string

required

ro_user

string

rw_user

string

tables

string

comma-separated write-skill tables

password

string

optional; a strong one is generated if omitted

Response

The generated setup scripts.

data

object

Show child attributes

Test a database connection Get a connection's data scoping

⌘I