# Best Practices

* **Use Parameterization for Queries**: Avoid hardcoding credentials or queries; use parameters for reusability and easy maintenance.
* **Multiple Level Validation**: Cross-check data between the application UI and the database to ensure accuracy.
* **Handle Dynamic Data with Variables**: Store and reuse database outputs in dynamic variables (e.g., {DB\_Data\[1]\[2]}) for flexible validations.
* **Always Open and Close Connections**: Properly open and close database connections to prevent performance issues.
* **Reuse Test Step Groups**: Create reusable test step groups for common validations to improve efficiency and consistency.


---

# 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/avo-assure-supported-technologies-for-automation/database-automation/best-practices.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.