> For the complete documentation index, see [llms.txt](https://docs.saturncms.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.saturncms.net/1.0.0/dev/libraries-and-functions/databasemanager/database-actions.md).

# Database Actions

A database action defines what format the function should return the data it retrieves from the database in.

| Action         | Description                                 |
| -------------- | ------------------------------------------- |
| `all:assoc`    | Fetches all rows as an associative array.   |
| `all:num`      | Fetches all rows as a numerical array.      |
| `first:assoc`  | Fetches the first row as an array           |
| `first:num`    | Fetches the first row as a numerical array. |
| `first:object` | Fetches the first row as a JSON Object      |
| `raw`          | Returns the raw result with no processing.  |

##