Connect Claude & ChatGPT to Rocketadmin

101 tools for Rocketadmin

These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.

• approve_batchDeletesApprove a batch (batch id). Destructive action; may require approval. API summary: Approve and apply every pending change in a batch in dependency order. Halts on first failure and rolls back already-applied items in revers….
• approve_changeVisible to othersApprove a change (change id). Has effects visible outside this system. API summary: Approve and apply a pending schema change.
• create_batch_rollbackVisible to othersCreate a new rollback for a batch. Has effects visible outside this system. API summary: Roll back every applied change in a batch in reverse order.
• create_change_rollbackChanges dataCreate a new rollback for a change. API summary: Roll back a previously applied schema change.
• create_connectionChanges dataCreate a new connection. Required: master encryption, type, host, port, username or password. Search connections first to avoid duplicates. API summary: Create new connection.
• create_connection_saved_queryChanges dataCreate a new saved query for a connection. Required: name, widget type or query text. Search saved queries first to avoid duplicates.
• create_settingChanges dataCreate a new setting. Required: table name, connection id, autocomplete columns, display name, excluded fields or identification fields. Search settings first to avoid duplicates. API summary: Create new table settings.
• create_table_schema_generateChanges dataCreate a new generate for a table schema. Required: user prompt. API summary: Generate one or more schema changes from a natural-language prompt. The response is always a batch envelope; single-change prompts return a….
• create_testChanges dataCreate a new test. Required: connection id, master encryption, type, host, port or username. API summary: Test connection.
• create_test_saved_db_query_controller_test_queryChanges dataCreate a new test. Required: query text. API summary: Test a query without saving it.
• create_userChanges dataCreate a new user. Required: message. API summary: Create new user action.
• delete_connection_saved_queryDeletesPermanently delete a saved query by query id. Destructive action; may require approval.
• delete_crudDeletesPermanently delete a crud by connection id. Destructive action; may require approval. API summary: Delete a single row from a table by primary key. API+.
• delete_dashboardDeletesPermanently delete a dashboard by connection id. Destructive action; may require approval.
• delete_dashboard_widgetDeletesPermanently delete a widget by connection id. Destructive action; may require approval. API summary: Delete a widget from a dashboard.
• delete_fieldDeletesPermanently delete a field by connection id. Destructive action; may require approval. API summary: Delete custom field.
• delete_groupDeletesPermanently delete a group by group id. Destructive action; may require approval. API summary: Delete group.
• delete_propertyDeletesPermanently delete a property by connection id. Destructive action; may require approval. API summary: Delete connection properties.
• delete_rowDeletesPermanently delete a row by connection id. Destructive action; may require approval. API summary: Delete row from table by primary key. API+.
• delete_ruleDeletesPermanently delete a rule by connection id. Destructive action; may require approval. API summary: Delete rule for table.
• delete_settingsMoves moneyPermanently delete a setting. Financial or irreversible action; may require approval. API summary: Delete table settings.
• delete_table_filterDeletesPermanently delete a table filter by filter id. Destructive action; may require approval. API summary: Delete filter set by id.
• delete_table_filter_allsMoves moneyPermanently delete a all by connection id. Financial or irreversible action; may require approval. API summary: Delete table all filters for table.
• find_all_users_in_groupGet one user by group id. API summary: Find all users in group.
• find_rowsChanges dataRead rows from a table (`table_name`) in a connection. Pass `filters` as an object of column: {operator: value} (e.g. {"status": {"eq": "active"}}), or {} for all rows, and an optional free-text `search`.
• find_rule_by_idGet one rule by connection id. API summary: Find rule by id.
• find_table_categoriesGet one category by connection id. API summary: Find table categories.
• find_table_categories_with_tablesGet one category by connection id. API summary: Find table categories with tables.
• get_batchGet one batch by batch id. API summary: Get every change in a batch (ordered by orderInBatch).
• get_categoryGet one category by connection id. API summary: Find tables in connection. API+.
• get_cedar_schemaGet one cedar schema by connection id. API summary: Get the current cedar schema used for authorization.
• get_changeGet one change by change id. API summary: Get a single schema change.
• get_connectionGet one database connection by `connection_id` (title, database type, host).
• get_crudGet one crud by connection id. API summary: Read a single row from a table by primary key. API+.
• get_customGet one custom by connection id. API summary: Find custom rules for table.
• get_dashboardGet one dashboard (`dashboard_id`) in a connection, with its widgets.
• get_diagramGet one diagram by connection id. API summary: Get Mermaid diagram of connection database structure (SQL only).
• get_exportGet one export by connection id. Results are paginated. API summary: Export connection logs as a CSV file.
• get_fieldGet one field by connection id. API summary: Find custom fields.
• get_groupGet one group by connection id. API summary: Find all groups in connection.
• get_no_cacheGet one no cache by connection id. API summary: Get table structure without cache. API+.
• get_personalGet one personal by connection id. API summary: Find user personal table settings.
• get_propertyGet one property by connection id. API summary: Find connection properties.
• get_public_permissionGet one public permission by connection id. API summary: Get the public (unauthenticated) read permissions configured for a connection.
• get_refreshGet one refresh by connection id. API summary: Generate new connection token.
• get_rowGet one row by connection id. API summary: Find row in table by primary key. API+.
• get_ruleGet one rule by connection id. API summary: Find rules for table.
• get_saved_queryGet one saved query (`query_id`) in a connection, with its SQL.
• get_table_filterGet one table filter by filter id. API summary: Find table filter set by id.
• get_table_structureGet the columns, types, primary key and foreign keys of a table (`table_name`) in a connection.
• get_userGet one user by connection id. API summary: Get all users in connection.
• get_user_permissions_for_group_and_connectionList permissions. API summary: Get user permissions for group and connection.
• get_verifyGet one verify by connection id. API summary: Check connection master password.
• get_widgetGet one widget by connection id. API summary: Find all table widgets.
• list_availablesList availables. API summary: List available permissions derived from the Cedar schema.
• list_change_logList the audit log of changes made through Rocketadmin in a connection, filtered by `table_name`, `email`, date range or operation type.
• list_connectionsList the database connections you can access in Rocketadmin, with their IDs.
• list_dashboardsList the dashboards in a connection.
• list_permissionsList permissions. API summary: Get group permissions for connection.
• list_saved_queriesList the saved SQL queries in a connection.
• list_table_schema_changesList changes for a table schema. Results are paginated. API summary: List schema-change history for a connection (newest first).
• list_tablesList the tables in a connection (`connection_id`).
• reject_batchDeletesReject a batch (batch id). Destructive action; may require approval. API summary: Reject every pending change in a batch.
• reject_changeVisible to othersReject a change (change id). Has effects visible outside this system. API summary: Reject a pending schema change.
• remove_user_from_groupVisible to othersUpdate an existing user. Has effects visible outside this system. API summary: Remove user from group.
• run_saved_queryChanges dataRun a saved query (`query_id`) in a connection and return its results; `table_name` is required by the API.
• search_groupsSearch groups. Use this to find existing groups before creating a new group. API summary: Find all user groups.
• search_settingsSearch settings by table name or connection id. Use this to find existing settings before creating a new setting. API summary: Find all table settings in this connection.
• search_table_filter_allsSearch alls for a table filter by table name. Use this to find existing alls before creating a new all. API summary: Find all table filters.
• submit_diagramVisible to othersPreview a diagram (connection id). Has effects visible outside this system. API summary: Preview Mermaid diagram with proposed DDL changes applied (SQL only). Nothing is executed against the real database — statements are parsed….
• update_categoryChanges dataUpdate an existing category identified by connection id. API summary: Add new table categories.
• update_cedar_policyChanges dataUpdate an existing cedar policy identified by connection id. API summary: Save a cedar policy for a group, generating classical permissions for backward compatibility.
• update_connectionChanges dataUpdate an existing connection identified by connection id. API summary: Update connection.
• update_connection_saved_queryChanges dataUpdate an existing saved query identified by query id. API summary: Update a saved query.
• update_crudChanges dataUpdate an existing crud identified by connection id. API summary: Update a single row in a table by primary key. API+.
• update_dashboardChanges dataUpdate an existing dashboard identified by connection id. API summary: Create a new dashboard.
• update_dashboard_widgetChanges dataUpdate an existing widget identified by connection id. API summary: Create a new widget in a dashboard.
• update_exportChanges dataUpdate an existing export identified by connection id. API summary: Export table as csv file. API+.
• update_fieldChanges dataUpdate an existing field identified by connection id. API summary: Update custom field.
• update_generateChanges dataUpdate an existing generate identified by connection id. API summary: Generate a panel using AI.
• update_generate_table_dashboardChanges dataUpdate an existing generate table dashboard identified by connection id. API summary: Generate a full table dashboard using AI.
• update_groupChanges dataUpdate an existing group identified by connection id. API summary: Create new group in connection.
• update_importChanges dataUpdate an existing import identified by connection id. API summary: Import csv file in table. API+.
• update_permissionDeletesUpdate an existing permission identified by permission slug. Destructive action; may require approval. API summary: Create or update permissions in group.
• update_personalChanges dataUpdate an existing personal identified by connection id. API summary: Create or update user personal table settings.
• update_propertyChanges dataUpdate an existing property identified by connection id. API summary: Update connection properties.
• update_public_permissionDeletesUpdate an existing public permission identified by connection id. Destructive action; may require approval. API summary: Set the public (unauthenticated) read permissions for a connection.
• update_restoreChanges dataUpdate an existing restore identified by connection id. API summary: Restore connection encrypted with master password.
• update_rowChanges dataUpdate an existing row identified by connection id. API summary: Update row in table by primary key. API+.
• update_row_table_pure_crud_operations_controller_get_rowsChanges dataUpdate an existing row identified by connection id. API summary: Get table rows with filter parameters in body. API+.
• update_ruleChanges dataUpdate an existing rule identified by connection id. API summary: Create new rule and actions for table.
• update_settingsVisible to othersUpdate an existing setting. Has effects visible outside this system. API summary: Update table settings.
• update_table_filterChanges dataUpdate an existing table filter identified by connection id. API summary: Add new table filters object.
• update_titleChanges dataUpdate an existing title identified by connection id. API summary: Update connection title.
• update_titlesVisible to othersUpdate an existing title. Has effects visible outside this system. API summary: Update group title.
• update_unfreezeChanges dataUpdate an existing unfreeze identified by connection id. API summary: Unfreeze connection.
• update_updateChanges dataUpdate an existing update identified by connection id. API summary: Change connection master password.
• update_userChanges dataUpdate an existing user identified by connection id. API summary: Delete connection.
• update_usersVisible to othersUpdate an existing user. Has effects visible outside this system. API summary: Add user in company and group in company.
• update_validateChanges dataUpdate an existing validate identified by connection id. API summary: Validate a cedar schema against the Cedar engine.
• update_widgetChanges dataUpdate an existing widget identified by connection id. API summary: Create new table widget.

Questions