# 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: 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:

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

The question should be specific, self-contained, and written in natural language.
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.