A valid request URL is required to generate request examples{
"data": {
"readOnly": {
"title": "Read-only user",
"sql": "CREATE ROLE flowyte_readonly LOGIN PASSWORD '...'; GRANT SELECT ON ALL TABLES IN SCHEMA public TO flowyte_readonly;"
},
"write": {
"title": "Scoped read-write user",
"sql": "GRANT INSERT, UPDATE ON orders, tickets TO flowyte_write;"
},
"generatedPassword": "x9F2-qP7m-Lk4t"
}
}{
"type": "about:blank",
"title": "<string>",
"status": 123,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"errors": [
{
"field": "<string>",
"message": "<string>"
}
]
}{
"type": "about:blank",
"title": "<string>",
"status": 123,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"errors": [
{
"field": "<string>",
"message": "<string>"
}
]
}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.
A valid request URL is required to generate request examples{
"data": {
"readOnly": {
"title": "Read-only user",
"sql": "CREATE ROLE flowyte_readonly LOGIN PASSWORD '...'; GRANT SELECT ON ALL TABLES IN SCHEMA public TO flowyte_readonly;"
},
"write": {
"title": "Scoped read-write user",
"sql": "GRANT INSERT, UPDATE ON orders, tickets TO flowyte_write;"
},
"generatedPassword": "x9F2-qP7m-Lk4t"
}
}{
"type": "about:blank",
"title": "<string>",
"status": 123,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"errors": [
{
"field": "<string>",
"message": "<string>"
}
]
}{
"type": "about:blank",
"title": "<string>",
"status": 123,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"errors": [
{
"field": "<string>",
"message": "<string>"
}
]
}Authorizations
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.
- Token URL
- /api/v1/api-keys
Path Parameters
The integration provider (connector). One of the supported connector slugs: native providers (google_calendar, google_sheets, calendly, hubspot, ``, square, opentable, shopify), SQL databases (postgres, mysql), the universal Zapier MCP fallback (zapier), or Composio (composio).
google_calendar, google_sheets, calendly, hubspot, square, opentable, shopify, postgres, mysql, zapier, composio Query Parameters
The target database name the scripts GRANT against.
Name for the generated least-privilege READ-ONLY role (defaults to a flowyte_readonly-style name).
Name for the generated SCOPED read-write role (only when write skills need it).
comma-separated write-skill tables
optional; a strong one is generated if omitted
Response
The generated setup scripts.
Show child attributes
Show child attributes