> For the complete documentation index, see [llms.txt](https://docs.avoautomation.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.avoautomation.com/avo-assure/actions/generic/database-operations.md).

# Database Operations

Database Actions in Avo Assure enable you to interact with various Databases during test execution. This actions allow connecting to the configured Database, executing queries, retrieving results, and validating data directly from the application under test. By using Database Actions, you can ensure data accuracy, verify backend operations, and perform end-to-end validation across UI and Database layers.

Here are the categories under Database Actions:

| Actions                                                                                              | Descritpion                                                                                                                  |
| ---------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------- |
| [Get DataDB](/avo-assure/actions/generic/database-operations/get-data-db.md)                         | The **Get DataDB** Action fetches specific data from the database.                                                           |
| [Verify DataDB](/avo-assure/actions/generic/database-operations/verify-data-db.md)                   | The **Verify DataDB** Action compares the expected data from a local Excel file with the actual data in the database.        |
| [Export DataDB](/avo-assure/actions/generic/database-operations/export-data-db.md)                   | The **Export DataDB** Action fetches data from the database and exports it into an Excel file.                               |
| [Run QueryDB](/avo-assure/actions/generic/database-operations/run-query-db.md)                       | The **Run QueryDB** Action allows executing an SQL query.                                                                    |
| [Get Data SecurelyDB](/avo-assure/actions/generic/database-operations/get-data-securely-db.md)       | The **Get Data SecurelyDB** Action fetches specific data from the database.                                                  |
| [Verify Secure DataDB](/avo-assure/actions/generic/database-operations/verify-secure-data-db.md)     | The **Verify Secure DataDB** Action compares the expected data from a local Excel file with the actual data in the database. |
| [Export Data SecurelyDB](/avo-assure/actions/generic/database-operations/export-data-securely-db.md) | The **Export Data SecurelyDB** Action fetches data from the database and exports it into an Excel file.                      |
| [Run Query SecurelyDB](/avo-assure/actions/generic/database-operations/run-query-securely-db.md)     | The **Run Query SecurelyDB** Action allows executing an SQL query.                                                           |

## Supported Database Numbers and Tags

Avo Assure supports the following Databases with their respective Database Numbers and Database Tags.

### **Relational Database**

Here are the Relational Databases with their respective Database Numbers and Database Tags:

{% hint style="info" %}
**Note**: The database tags are not case sensitive
{% endhint %}

| Database Tags | Database Numbers |
| ------------- | ---------------- |
| MSSQL         | 4                |
| Oracle        | 5                |
| PostgreSQL    | 14               |

### Non- Relational Database

Here are the Non- Relational Databases with their respective Database Numbers and Database Tags:

| Database Tags | Database Numbers |
| ------------- | ---------------- |
| Mongo DB      | 9                |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.avoautomation.com/avo-assure/actions/generic/database-operations.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.