# 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](https://docs.avoautomation.com/actions/generic/database-operations/get-data-db)                         | The **Get DataDB** Action fetches specific data from the database.                                                           |
| [Verify DataDB](https://docs.avoautomation.com/actions/generic/database-operations/verify-data-db)                   | The **Verify DataDB** Action compares the expected data from a local Excel file with the actual data in the database.        |
| [Export DataDB](https://docs.avoautomation.com/actions/generic/database-operations/export-data-db)                   | The **Export DataDB** Action fetches data from the database and exports it into an Excel file.                               |
| [Run QueryDB](https://docs.avoautomation.com/actions/generic/database-operations/run-query-db)                       | The **Run QueryDB** Action allows executing an SQL query.                                                                    |
| [Get Data SecurelyDB](https://docs.avoautomation.com/actions/generic/database-operations/get-data-securely-db)       | The **Get Data SecurelyDB** Action fetches specific data from the database.                                                  |
| [Verify Secure DataDB](https://docs.avoautomation.com/actions/generic/database-operations/verify-secure-data-db)     | The **Verify Secure DataDB** Action compares the expected data from a local Excel file with the actual data in the database. |
| [Export Data SecurelyDB](https://docs.avoautomation.com/actions/generic/database-operations/export-data-securely-db) | The **Export Data SecurelyDB** Action fetches data from the database and exports it into an Excel file.                      |
| [Run Query SecurelyDB](https://docs.avoautomation.com/actions/generic/database-operations/run-query-securely-db)     | 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 |
| --------------- | ---------------- |
| DB2             | 2                |
| MS Assess Files | 3                |
| MSSQL           | 4                |
| Oracle          | 5                |
| Sybase          | 7                |
| Mysql           | 8                |
| SQLite          | 12               |
| Snowflake       | 13               |
| PostgreSQL      | 14               |
| Sql             | 15               |

### Non- Relational Database

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

| Database Tags | Database Numbers |
| ------------- | ---------------- |
| Mongo DB      | 9                |
| Redis         | 10               |
| Cassandra     | 11               |