# Rocketadmin

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

- **Category:** developer tools
- **Auth:** API_KEY
- **Composio Managed App Available?** N/A
- **Tools:** 17
- **Triggers:** 0
- **Slug:** `ROCKETADMIN`
- **Version:** 20260312_00

## Tools

### Check API Key

**Slug:** `ROCKETADMIN_CHECK_API_KEY`

Tool to validate whether an API key is legitimate and active. Use when you need to verify that the current API key is valid before performing other operations.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Table Row by Primary Key

**Slug:** `ROCKETADMIN_DELETE_TABLE_ROW`

Tool to delete a single row from a database table by primary key. Use when you need to remove a specific row identified by its ID. This is an API+ feature.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `id` | string | Yes | The primary key value of the row to delete. Can be a string or integer depending on the table schema. |
| `tableName` | string | Yes | The name of the table from which the row will be deleted. |
| `connectionId` | string | Yes | The unique identifier for the database connection where the deletion will occur. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Verify Company Invitation Link

**Slug:** `ROCKETADMIN_GET_COMPANY_INVITE_VERIFY`

Tool to check if a company invitation verification link is available and valid. Use when you need to verify a company invitation token before accepting the invitation.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `verificationString` | string | Yes | A unique verification token string used to validate the company invitation link and check if it is still available and valid. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get All Connections

**Slug:** `ROCKETADMIN_GET_CONNECTIONS`

Tool to retrieve all database connections where the user has access. Use when you need to discover available connections in the user's workspace.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Connection Tables V2

**Slug:** `ROCKETADMIN_GET_CONNECTION_TABLES_V2`

Tool to retrieve all tables in a database connection organized with category information. Use when you need to discover available tables in a specific connection.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `connectionId` | string | Yes | The unique identifier for the database connection to query tables from. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Validate Connection Token

**Slug:** `ROCKETADMIN_GET_CONNECTION_TOKEN`

Tool to validate if connection agent token is valid. Use when you need to check if the current connection token is still authorized and active.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Hello

**Slug:** `ROCKETADMIN_GET_HELLO`

Tool to retrieve a hello greeting message from the Rocketadmin API. Use when testing API connectivity or getting a simple greeting response.

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get SaaS Users by Email

**Slug:** `ROCKETADMIN_GET_SAAS_USERS_EMAIL`

Tool to retrieve user information by email address. Use when you need to get details about a specific user by their email.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `user_email` | string | Yes | The email address of the user to retrieve information for |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Table Row by Primary Key

**Slug:** `ROCKETADMIN_GET_TABLE_ROW`

Tool to retrieve a single row from a database table using its primary key. Use when you need to fetch specific row data by its ID from a RocketAdmin connection.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `id` | string | Yes | The primary key value of the row to retrieve. Can be a string or integer depending on the table schema. |
| `tableName` | string | Yes | The name of the database table to query. |
| `connectionId` | string | Yes | The unique identifier for the database connection. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Table Structure

**Slug:** `ROCKETADMIN_GET_TABLE_STRUCTURE`

Tool to retrieve the structural information of a database table including columns, data types, constraints, and relationships. Use when you need to understand the schema of a specific table in a RocketAdmin connection.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `tableName` | string | Yes | The name of the database table to retrieve structure for. |
| `connectionId` | string | Yes | The unique identifier for the database connection. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Verify User Email

**Slug:** `ROCKETADMIN_GET_USER_EMAIL_VERIFY`

Tool to verify a user's email address using a verification token. Use when you need to confirm a user's email address after registration or email change.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `verificationString` | string | Yes | A unique verification token string used to authenticate and validate the user's email address during the verification process. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Export Table as CSV

**Slug:** `ROCKETADMIN_POST_TABLE_CSV_EXPORT`

Tool to export table data as a CSV file from RocketAdmin. Use when you need to download table data in CSV format. This is an API+ feature that exports the specified table with optional filtering, pagination, and sorting.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `page` | integer | No | Page number for pagination, must be >=1. |
| `email` | string | No | Filter by user email address. |
| `limit` | integer | No | Maximum records to return. Default is 500 if pagination is not used. Must be >=1. |
| `order` | string | No | Sorting parameter (e.g., 'ASC' for ascending, 'DESC' for descending). |
| `dateTo` | string | No | End date for date range filtering (ISO8601 format). |
| `perPage` | integer | No | Number of records per page, must be >=1. |
| `dateFrom` | string | No | Start date for date range filtering (ISO8601 format). |
| `tableName` | string | Yes | Specifies which table to export. |
| `connectionId` | string | Yes | The unique identifier for the database connection. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Add Row to Table

**Slug:** `ROCKETADMIN_POST_TABLE_ROW`

Tool to add a new row to a database table in RocketAdmin. Use when you need to insert data into a specific table. This is an API+ feature that creates a new row with the provided field values.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `row_data` | object | Yes | The row data to insert. Keys should match table column names and values should match expected data types. The structure depends on the target table schema. |
| `tableName` | string | Yes | The name of the database table where the row should be inserted. |
| `connectionId` | string | Yes | The unique identifier for the database connection where the row will be added. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Find Table Rows with Filters

**Slug:** `ROCKETADMIN_POST_TABLE_ROWS_FIND`

Tool to retrieve all rows from a database table with filter parameters in the request body. Use when you need to fetch rows with complex filtering conditions. This is an API+ feature that supports advanced filtering with operators like equals, greater than, less than, like, in, etc.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `page` | integer | No | Pagination page number for retrieving specific page of results. |
| `filters` | object | No | Filter parameters to apply to the table rows query. Structure: {column_name: {operator: value}}. Operators include 'eq' (equals), 'ne' (not equals), 'gt' (greater than), 'gte' (greater than or equal), 'lt' (less than), 'lte' (less than or equal), 'like' (pattern matching), 'in' (in list), 'notin' (not in list), 'isnull' (is null), 'isnotnull' (is not null). |
| `perPage` | integer | No | Number of results per page for pagination. |
| `tableName` | string | Yes | The name of the database table to query rows from. |
| `connectionId` | string | Yes | The unique identifier for the database connection. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Update Table Row by Primary Key

**Slug:** `ROCKETADMIN_PUT_TABLE_ROW`

Tool to update a row in a database table by its primary key. Use when you need to modify existing row data in a RocketAdmin connection. This is an API+ feature.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `id` | string | Yes | The primary key value of the row to update. Can be a string or integer depending on the table schema. |
| `row_data` | object | Yes | The row data to update. Keys should match table column names and values should match expected data types. Only include fields that need to be updated. |
| `tableName` | string | Yes | The name of the database table containing the row to update. |
| `connectionId` | string | Yes | The unique identifier for the database connection where the row will be updated. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Delete Multiple Table Rows

**Slug:** `ROCKETADMIN_PUT_TABLE_ROWS_DELETE`

Tool to delete multiple rows from a table by primary key. Use when you need to batch delete rows identified by their primary keys. This is an API+ feature.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `rows` | array | Yes | Array of objects containing the primary key field(s) and their values for rows to be deleted. Each object must include the primary key field name(s) that identify the row. |
| `tableName` | string | Yes | The name of the table from which rows will be deleted. |
| `connectionId` | string | Yes | The unique identifier for the database connection where the deletion will occur. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Update Multiple Table Rows

**Slug:** `ROCKETADMIN_PUT_TABLE_ROWS_UPDATE`

Tool to update multiple rows in a table by primary key. Use when you need to batch update rows identified by their primary keys with the same new values. This is an API+ feature.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `newValues` | object | Yes | Object containing the field names and new values to be set for all identified rows. Keys should match table column names. |
| `tableName` | string | Yes | The name of the table where rows will be updated. |
| `primaryKeys` | array | Yes | Array of objects containing the primary key field(s) and their values for rows to be updated. Each object must include the primary key field name(s) that identify the row. |
| `connectionId` | string | Yes | The unique identifier for the database connection where the update will occur. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |