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}
No operations match.
See How connections work for access and permissions, or browse all integrations.