Skip to content
Changelog

Report a bug

Rocketadmin integration: operations for AI agents

Rocketadmin connects to Type.com as an integration. This page lists the 230 operations documented for Claude and Codex in Type.com: 94 read, 74 write, 62 destructive.

About Rocketadmin

Save months of work developing custom admin panels with our secure solution for your MySQL, PostgreSQL, MSSQL, Oracle DB or MongoDB project.

Categories: Developer Tools & IT

How to connect Rocketadmin to Type.com

Access
Organization connection: one shared account for the workspace.

To add the connection, follow the steps in Space connections.

Documented operations

230 operations. Your connection's permissions determine which operations are available. API references describe the vendor surface; they do not expand your connection's credentials or access.

230 operations listed.

App

  • Read

    App Controller get Hello

    GET /hello

Cedar Authorization

  • Read

    Get the current cedar schema used for authorization

    GET /connection/cedar-schema/{connectionId}

  • Read

    Validate a cedar schema against the Cedar engine

    POST /connection/cedar-schema/validate/{connectionId}

  • Read

    Get the public (unauthenticated) read permissions configured for a connection

    GET /connection/public-permissions/{connectionId}

  • Write

    Save a cedar policy for a group, generating classical permissions for backward compatibility

    POST /connection/cedar-policy/{connectionId}

  • Destructive

    Set the public (unauthenticated) read permissions for a connection

    Generates and stores a Cedar policy granting public users QueryTable + ColumnRead on the listed tables. Pass an empty "tables" array to disable public access.

Connection

  • Read

    Get all connections where user have access

    GET /connections

  • Read

    Get all users in connection

    GET /connection/users/{connectionId}

  • Read

    Check connection master password

    GET /connection/masterpwd/verify/{connectionId}

  • Read

    Find one connection by id

    GET /connection/one/{connectionId}

  • Read

    Find all groups in connection

    GET /connection/groups/{connectionId}

  • Read

    Get group permissions for connection

    GET /connection/permissions

  • Read

    Get user permissions for group and connection

    GET /connection/user/permissions

  • Read

    Check connection agent token validity

    GET /connection/token

  • Read

    Generate new connection token

    GET /connection/token/refresh/{connectionId}

  • Read

    Get Mermaid diagram of connection database structure (SQL only)

    GET /connection/diagram/{connectionId}

  • Read

    Preview Mermaid diagram with proposed DDL changes applied (SQL only).

    Preview Mermaid diagram with proposed DDL changes applied (SQL only). Nothing is executed against the real database — statements are parsed and applied to an in-memory copy of the schema.

  • Write

    Create new connection

    POST /connection

  • Write

    Create new group in connection

    POST /connection/group/{connectionId}

  • Write

    Test connection

    POST /connection/test

  • Destructive

    Update connection

    PUT /connection/{connectionId}

  • Destructive

    Delete connection

    PUT /connection/delete/{connectionId}

  • Destructive

    Delete group from connection

    PUT /connection/group/delete/{connectionId}

  • Destructive

    Change connection master password

    PUT /connection/encryption/update/{connectionId}

  • Destructive

    Restore connection encrypted with master password

    PUT /connection/encryption/restore/{connectionId}

  • Destructive

    Unfreeze connection

    PUT /connection/unfreeze/{connectionId}

  • Destructive

    Update connection title

    PUT /connection/title/{connectionId}

User

  • Read

    Find user

    GET /user

  • Read

    Request user email verification

    GET /user/email/verify/request

  • Read

    Verify user email

    GET /user/email/verify/{verificationString}

  • Read

    Request user email change

    GET /user/email/change/request

  • Read

    Validate two-factor authentication token for login with second factor

    POST /user/otp/login

  • Read

    Find user session settings

    GET /user/settings

  • Write

    Login with email and password

    POST /user/login

  • Write

    Log out

    POST /user/logout

  • Write

    Change user password

    POST /user/password/change

  • Write

    Verify user password reset

    POST /user/password/reset/verify/{verificationString}

  • Write

    Request user password reset

    POST /user/password/reset/request

  • Write

    Verify user email change

    POST /user/email/change/verify/{verificationString}

  • Write

    Generate one time token and QR Code

    POST /user/otp/generate

  • Write

    Verify one time token

    POST /user/otp/verify

  • Write

    Disable user two-factor authentication

    POST /user/otp/disable

  • Write

    Save user session settings

    POST /user/settings

  • Destructive

    Change user name

    PUT /user/name

  • Destructive

    Delete user account

    PUT /user/delete

  • Destructive

    Toggle display mode of test connections

    PUT /user/test/connections/display

Connection properties

  • Read

    Find connection properties

    GET /connection/properties/{connectionId}

  • Write

    Create new connection properties

    POST /connection/properties/{connectionId}

  • Destructive

    Update connection properties

    PUT /connection/properties/{connectionId}

  • Destructive

    Delete connection properties

    DELETE /connection/properties/{connectionId}

Conversion

  • Read

    Conversion Controller get Conversions

    GET /conversions

Custom fields

  • Read

    Find custom fields

    GET /fields/{connectionId}

  • Write

    Create new custom field

    POST /field/{connectionId}

  • Destructive

    Update custom field

    PUT /field/{connectionId}

  • Destructive

    Delete custom field

    DELETE /field/{connectionId}

Group

  • Read

    Find all user groups

    GET /groups

  • Read

    Find all users in group

    GET /group/users/{groupId}

  • Destructive

    Add user in company and group in company

    PUT /group/user

  • Destructive

    Delete group

    DELETE /group/{groupId}

  • Destructive

    Remove user from group

    PUT /group/user/delete

  • Destructive

    Update group title

    PUT /group/title

Permissions

  • Read

    List available permissions derived from the Cedar schema

    GET /permissions/available

  • Destructive

    Create or update permissions in group

    PUT /permissions/{slug}

Table logs

  • Read

    Find all connection logs.

    You can provide the following query parameters: - tableName=value: Specify the table name. - order=ASC|DESC: Sorting order by creation time. - page=value: Page number for pagination. - perPage=value: Number of records per page. - dateFrom=value: Start date to filter logs.

  • Read

    Export connection logs as a CSV file.

    You can provide the following query parameters: - tableName=value: Specify the table name. - order=ASC|DESC: Sorting order by creation time. - page=value: Page number for pagination. - perPage=value: Number of records per page. - dateFrom=value: Start date to filter logs.

Table

  • Read

    Find tables in connection. API+

    Return all found tables in connection. Support access with api key.

  • Read

    Find tables in connection. API+

    Return all found tables in connection with categories. Support access with api key.

  • Read

    Get all table rows with filter parameters in body. API+

    Return all found table rows. Support access with api key. Support search, filtering and pagination.

  • Read

    Get table structure. API+

    Return table structure. Support access with api key.

  • Read

    Get table structure without cache. API+

    Return table structure fetched directly from the database, bypassing the structure cache. Support access with api key.

  • Read

    Find row in table by primary key. API+

    Return row by primary key. Support access with api key.

  • Read

    Export table as csv file. API+

    Export data from table as csv file. Support search, filtering and pagination. Support access with api key.

  • Write

    Add new row in table. API+

    Add new row in table. Support access with api key.

  • Write

    Import csv file in table. API+

    Import data from csv file in table. Support access with api key.

  • Destructive

    Update row in table by primary key. API+

    Update row in table by primary key (if table has primary key). Support access with api key.

  • Destructive

    Delete row from table by primary key. API+

    Delete row from table by primary key (if table has primary key). Support access with api key.

  • Destructive

    Multiple delete rows from table by primary key. API+

    Remove multiple rows from table. Support access with api key.

  • Destructive

    Multiple update rows in table by primary key. API+

    Set new values to several rows. Support access with api key.

Table pure CRUD operations

  • Read

    Read a single row from a table by primary key. API+

    Return only the found row by primary key. Support access with api key.

  • Read

    Get table rows with filter parameters in body. API+

    Return only rows and pagination. Support search, filtering (in body), ordering and pagination. Support access with api key.

  • Write

    Create a single row in a table. API+

    Insert a new row and return only the created row. Support access with api key.

  • Destructive

    Update a single row in a table by primary key. API+

    Update a row by primary key and return only the updated row. Support access with api key.

  • Destructive

    Delete a single row from a table by primary key. API+

    Delete a row by primary key and return only the deleted row. Support access with api key.

Table settings

  • Read

    Find all table settings in this connection

    GET /settings

  • Write

    Create new table settings

    POST /settings

  • Destructive

    Update table settings

    PUT /settings

  • Destructive

    Delete table settings

    DELETE /settings

Table widget

  • Read

    Find all table widgets

    GET /widgets/{connectionId}

  • Write

    Create new table widget

    POST /widget/{connectionId}

User actions

  • Write

    Create new user action

    POST /action

Saas

  • Read

    Get user info by id webhook

    GET /saas/user/{userId}

  • Read

    Get users infos by email webhook

    GET /saas/users/email/{userEmail}

  • Read

    List company members and outstanding invitations for the SaaS service

    GET /saas/company/{companyId}/users

  • Read

    Validate an end-user JWT on behalf of the SaaS service

    POST /saas/user/validate-token

  • Read

    Get the full user profile on behalf of the SaaS service (findMe parity)

    GET /saas/user/{userId}/profile

  • Read

    Get user session settings on behalf of the SaaS service

    GET /saas/user/{userId}/settings

  • Read

    Get companies where a user with this email is registered

    GET /saas/company/my/email/{email}

  • Read

    Get company info by user id

    GET /saas/user/{userId}/company

  • Read

    Get connections info by ids

    POST /saas/connections/info

  • Read

    Get decrypted credentials for a hosted connection

    POST /saas/connection/hosted/credentials

  • Write

    Company registered webhook

    POST /saas/company/registered

  • Write

    User register webhook

    POST /saas/user/register

  • Write

    Re-send the email-confirmation letter on behalf of the SaaS service

    POST /saas/user/email/verify/request

  • Write

    Verify user email on behalf of the SaaS service

    POST /saas/user/email/verify/{verificationString}

  • Write

    Request a password-reset email on behalf of the SaaS service

    POST /saas/user/password/reset/request

  • Write

    Consume a password-reset token on behalf of the SaaS service

    POST /saas/user/password/reset/verify/{verificationString}

  • Write

    Request an email-change letter on behalf of the SaaS service

    POST /saas/user/email/change/request

  • Write

    Consume an email-change token on behalf of the SaaS service

    POST /saas/user/email/change/verify/{verificationString}

  • Write

    Invite a user into a company on behalf of the SaaS service

    POST /saas/company/{companyId}/invite

  • Write

    Accept a company invitation on behalf of the SaaS service

    POST /saas/company/invite/verify/{verificationString}

  • Write

    User logout webhook — blacklist an end-user JWT issued by the SaaS service

    POST /saas/user/logout

  • Write

    User login webhook

    POST /saas/user/login

  • Write

    Change a user password on behalf of the SaaS service

    POST /saas/user/password/change

  • Write

    Save user session settings on behalf of the SaaS service

    POST /saas/user/settings

  • Write

    Generate an OTP secret and QR code on behalf of the SaaS service

    POST /saas/user/otp/generate

  • Write

    Verify an OTP code (finish 2FA enrolment) on behalf of the SaaS service

    POST /saas/user/otp/verify

  • Write

    Disable 2FA on behalf of the SaaS service

    POST /saas/user/otp/disable

  • Write

    Complete a 2FA login on behalf of the SaaS service: validates the temporary token (blacklist + TEMPORARYJWTSECRET) and…

    Complete a 2FA login on behalf of the SaaS service: validates the temporary token (blacklist + TEMPORARYJWTSECRET) and verifies the OTP code.

  • Write

    Login or create user with google webhook

    POST /saas/user/google/login

  • Write

    Login or create user with github webhook

    POST /saas/user/github/login

  • Write

    Created connection of hosted database

    POST /saas/connection/hosted

  • Write

    Update password of hosted database connection

    POST /saas/connection/hosted/password

  • Destructive

    Remove a user from a company on behalf of the SaaS service

    DELETE /saas/company/{companyId}/user/{userId}

  • Destructive

    Revoke a pending company invitation on behalf of the SaaS service

    PUT /saas/company/{companyId}/invitation/revoke

  • Destructive

    Update company user roles on behalf of the SaaS service

    PUT /saas/company/{companyId}/users/roles

  • Destructive

    Change a user name on behalf of the SaaS service

    PUT /saas/user/name

  • Destructive

    Delete a user account on behalf of the SaaS service

    PUT /saas/user/delete

  • Destructive

    Toggle display mode of test connections on behalf of the SaaS service

    PUT /saas/user/test-connections

  • Destructive

    Delete connection of hosted database

    POST /saas/connection/hosted/delete

Agents microservice

  • Read

    Validate an end-user JWT on behalf of the agents microservice

    POST /internal/agents/auth/validate-user-token

  • Read

    Check Cedar permission for an AI request on a table

    POST /internal/agents/auth/validate-table-ai-request

  • Read

    Check Cedar permission for editing a connection

    POST /internal/agents/auth/validate-connection-edit

  • Read

    Get AI-relevant connection context (type, schema, MongoDB flag)

    POST /internal/agents/ai/data/{connectionId}/context

  • Read

    List connection tables the user may read (grounds website feasibility)

    POST /internal/agents/ai/data/{connectionId}/tables

  • Read

    Get permission-aware table structure for the AI tool loop

    POST /internal/agents/ai/data/{connectionId}/table-structure

  • Read

    Validate and execute a read-only SQL query for the AI tool loop

    POST /internal/agents/ai/data/{connectionId}/raw-query

  • Read

    Fetch permission-filtered sample rows and a row count (grounds website generation)

    POST /internal/agents/ai/data/{connectionId}/sample-rows

  • Read

    Validate and execute a read-only MongoDB aggregation pipeline for the AI tool loop

    POST /internal/agents/ai/data/{connectionId}/aggregation-pipeline

  • Read

    Read a user's company subscription metadata (agents-core owns all feature policy)

    POST /internal/agents/company/subscription-info

  • Write

    Grant public (anonymous) read on connection tables — website-generation agent flow

    Re-checks Cedar connection:edit for the given user, then merges the tables into the existing public policy (mode=merge, default) or replaces it (mode=replace). Called by agents-core after the user approved the setpublicreadpermissions consent question.

  • Write

    Write the site data contract (runtime manifest) for a generated site — agent finalize flow

    Re-checks Cedar connection:edit for the given user, then stores the manifest on the connection (siteruntimepolicy, replacing any previous one).

  • Write

    Run the AI settings/widgets scan, streaming progress chunks

    POST /internal/agents/ai/data/{connectionId}/settings-scan

Sitenova microservice

  • Read

    Return decrypted connection credentials plus the end-user JWT signing key.

    Serves the universal-backend service so it can open the customer database itself and sign/verify generated-site end-user tokens. Agent connections are rejected (no stored credentials).

  • Write

    Report a generated-site visitor row write so the table actions configured for it run.

    universal-backend reports EVERY visitor write (create/update/delete, registration, file upload) here; the core runs only the table actions the connection owner attached to this table + event in RocketAdmin (URL webhook / Slack / email) and answers how many matched.

  • Write

    Evaluate the connection public policy for an anonymous table read.

    Same Cedar evaluation SitenovaPublicReadGuard applies on the core /sitenova data routes, plus the publicly readable subset of the submitted columns — for satellites running the query themselves.

  • Write

    Execute a raw, write-capable SQL statement against the connected database.

    Runs arbitrary SQL (DDL/DML) so the SiteNova agent can provision schema (e.g. CREATE TABLE) in the user connection. No read-only validation is applied; the connected DB user privileges are the only constraint.

Sitenova site

  • Read

    List rows (public-read; gated by the connection public policy).

    POST /sitenova/{connectionId}/data/rows

  • Read

    Read a row by primary key (public-read; gated by the connection public policy).

    POST /sitenova/{connectionId}/data/read

  • Write

    Register a generated-site end-user (creates a row in the connection users table).

    POST /sitenova/{connectionId}/auth/register

  • Write

    Log a generated-site end-user in and return a Bearer token.

    POST /sitenova/{connectionId}/auth/login

  • Write

    Create a row (requires a valid end-user token).

    POST /sitenova/{connectionId}/data/create

  • Write

    Update a row by primary key (requires a valid end-user token).

    POST /sitenova/{connectionId}/data/update

  • Destructive

    Delete a row by primary key (requires a valid end-user token).

    POST /sitenova/{connectionId}/data/delete

Company

  • Read

    Get user company

    GET /company/my

  • Read

    Get company name by id

    GET /company/name/{companyId}

  • Read

    Get users in company

    GET /company/users/{companyId}

  • Read

    Get companies where user with this email registered

    GET /company/my/email/{email}

  • Read

    Get user company full info

    GET /company/my/full

  • Read

    Check is verification link is available

    GET /company/invite/verify/{verificationString}

  • Read

    [temporary] Company white label properties — always empty (white label retired)

    GET /company/white-label-properties/{companyId}

  • Write

    Verify invitation in company

    POST /company/invite/verify/{verificationString}

  • Destructive

    Delete company

    DELETE /company/my

  • Destructive

    Update company name

    PUT /company/name/{companyId}

  • Destructive

    Invite user in company and connection group

    PUT /company/user/{companyId}

  • Destructive

    Remove user from company

    DELETE /company/{companyId}/user/{userId}

  • Destructive

    Revoke invitation in company

    PUT /company/invitation/revoke/{companyId}

  • Destructive

    Set company test connections visibility

    PUT /company/connections/display

  • Destructive

    Update users roles in company

    PUT /company/users/roles/{companyId}

  • Destructive

    Update 2fa auth for users in company

    PUT /company/2fa/{companyId}

  • Destructive

    Suspend users in company

    PUT /company/users/suspend/{companyId}

  • Destructive

    Unsuspend users in company

    PUT /company/users/unsuspend/{companyId}

Table actions and rules

  • Read

    Find rules for table

    GET /action/rules/{connectionId}

  • Read

    Find custom rules for table

    GET /action/events/custom/{connectionId}

  • Read

    Find rule by id

    GET /action/rule/{ruleId}/{connectionId}

  • Write

    Create new rule and actions for table

    POST /action/rule/{connectionId}

  • Write

    Activate all actions with custom event in this rule

    POST /event/actions/activate/{eventId}/{connectionId}

  • Destructive

    Update rule by id

    PUT /action/rule/{ruleId}/{connectionId}

  • Destructive

    Delete rule for table

    DELETE /action/rule/{ruleId}/{connectionId}

Api Key

  • Read

    Get all user api keys

    GET /apikeys

  • Read

    Get api key by id

    GET /apikey/{apiKeyId}

  • Read

    Check api key

    GET /check/apikey

  • Write

    Create new API key

    POST /apikey

  • Destructive

    Delete api key by id

    DELETE /apikey/{apiKeyId}

Table filters

  • Read

    Find all table filters

    GET /table-filters/{connectionId}/all

  • Read

    Find table filter set by id

    GET /table-filters/{connectionId}/{filterId}

  • Write

    Add new table filters object

    POST /table-filters/{connectionId}

  • Destructive

    Delete table all filters for table

    DELETE /table-filters/{connectionId}/all

  • Destructive

    Update table filters object

    PUT /table-filters/{connectionId}/{filterId}

  • Destructive

    Delete filter set by id

    DELETE /table-filters/{connectionId}/{filterId}

Table categories

  • Read

    Find table categories

    GET /table-categories/{connectionId}

  • Read

    Find table categories with tables

    GET /table-categories/v2/{connectionId}

  • Destructive

    Add new table categories

    PUT /table-categories/{connectionId}

Secrets

  • Read

    Get all company secrets

    GET /secrets

  • Read

    Get secret by slug

    GET /secrets/{slug}

  • Read

    Get secret audit log

    GET /secrets/{slug}/audit-log

  • Write

    Create new secret

    POST /secrets

  • Destructive

    Update secret

    PUT /secrets/{slug}

  • Destructive

    Delete secret

    DELETE /secrets/{slug}

Table Schema Changes

  • Read

    List schema-change history for a connection (newest first).

    GET /table-schema/{connectionId}/changes

  • Read

    Get a single schema change.

    GET /table-schema/change/{changeId}

  • Read

    Get every change in a batch (ordered by orderInBatch).

    GET /table-schema/batch/{batchId}

  • Write

    Generate one or more schema changes from a natural-language prompt.

    Generate one or more schema changes from a natural-language prompt. The response is always a batch envelope; single-change prompts return a length-1 array.

  • Write

    Approve and apply a pending schema change.

    POST /table-schema/change/{changeId}/approve

  • Write

    Reject a pending schema change.

    POST /table-schema/change/{changeId}/reject

  • Write

    Roll back a previously applied schema change.

    POST /table-schema/change/{changeId}/rollback

  • Write

    Approve and apply every pending change in a batch in dependency order.

    Approve and apply every pending change in a batch in dependency order. Halts on first failure and rolls back already-applied items in reverse.

  • Write

    Reject every pending change in a batch.

    POST /table-schema/batch/{batchId}/reject

  • Write

    Roll back every applied change in a batch in reverse order.

    POST /table-schema/batch/{batchId}/rollback

Sign In Audit

  • Read

    Find sign-in audit logs for the company.

    You can provide the following query parameters: - order=ASC|DESC: Sorting order by creation time. - page=value: Page number for pagination. - perPage=value: Number of records per page. - dateFrom=value: Start date to filter logs. - dateTo=value: End date to filter logs.

Personal table settings

  • Read

    Find user personal table settings

    GET /settings/personal/{connectionId}

  • Destructive

    Create or update user personal table settings

    PUT /settings/personal/{connectionId}

S3 Widget

  • Read

    Get pre-signed URL for S3 file download

    GET /s3/file/{connectionId}

  • Read

    Get pre-signed URL for S3 file upload

    POST /s3/upload-url/{connectionId}

Saved database queries

  • Read

    Get all saved queries for a connection

    GET /connection/{connectionId}/saved-queries

  • Read

    Get a saved query by id

    GET /connection/{connectionId}/saved-query/{queryId}

  • Write

    Create a new saved query

    POST /connection/{connectionId}/saved-query

  • Write

    Execute a saved query

    POST /connection/{connectionId}/saved-query/{queryId}/execute

  • Write

    Test a query without saving it

    POST /connection/{connectionId}/query/test

  • Destructive

    Update a saved query

    PUT /connection/{connectionId}/saved-query/{queryId}

  • Destructive

    Delete a saved query

    DELETE /connection/{connectionId}/saved-query/{queryId}

Dashboards

  • Read

    Get all dashboards for a connection

    GET /dashboards/{connectionId}

  • Read

    Get a dashboard by id

    GET /dashboard/{dashboardId}/{connectionId}

  • Write

    Create a new dashboard

    POST /dashboards/{connectionId}

  • Destructive

    Update a dashboard

    PUT /dashboard/{dashboardId}/{connectionId}

  • Destructive

    Delete a dashboard

    DELETE /dashboard/{dashboardId}/{connectionId}

Dashboard Widgets

  • Write

    Create a new widget in a dashboard

    POST /dashboard/{dashboardId}/widget/{connectionId}

  • Write

    Generate a panel using AI

    Creates a new panel with SQL query and chart configuration generated by AI based on natural language description. AI autonomously discovers relevant tables.

  • Write

    Generate a full table dashboard using AI

    AI autonomously discovers database tables, analyzes their structure, and auto-generates multiple panel configurations for a dashboard

  • Destructive

    Update a widget in a dashboard

    PUT /dashboard/{dashboardId}/widget/{widgetId}/{connectionId}

  • Destructive

    Delete a widget from a dashboard

    DELETE /dashboard/{dashboardId}/widget/{widgetId}/{connectionId}

See How connections work for access and permissions, or browse all integrations.