> For the complete documentation index, see [llms.txt](https://docs.simplifyqa.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.simplifyqa.ai/introduction-to-test-management-in-simplifyqa/create-a-database-test-case.md).
# Create a Database Test Case
**Database testing** is a critical aspect of software quality assurance that focuses on verifying the correctness, integrity, and performance of a database system. It involves testing various aspects of the database.
Database automation testing involves creating scripts or code that can automatically execute database queries, validate results, and report on test outcomes. This can be achieved using various tools and programming languages.
### Prerequisites
* Access to the project for which you want and privilege to create data base automation test case.
* Necessary Database connection details (host, port, database name, username, password).
* SimplifyQA Wizard needs to be installed and running. Learn how to setup Wizard here [Setup QAWIzard](/simplifyqa-installation-and-setup.md).
### How to Create a Database Test Case
1. Navigate to **Test Case** from the left-hand panel.
2. Click on '**+ Test Case'**.
3. From the **Automation** dropdown, select **Database**.
4. Enter a meaningful **Test Case Name**.
5. In the **Action** section of each step, select the appropriate [database action](/introduction-to-test-management-in-simplifyqa/supported-actions.md) (e.g., *Connect to DB*).
6. In the **Parameter** section, input the required [parameters](/introduction-to-parameters/create-and-utilise-parameters-in-your-test-case.md) details which will be prompted (e.g., *Database Type, Host, Port, Username, Password, Database Name*)
{% hint style="info" %}
The Test Data for the parameters can be added from the Test Data Tab. Database Type should be all in capitals e.g., POSTGRES or MYSQL.
{% endhint %}
7. After establishing the connection, you can directly input your **SQL queries**. Each query and its corresponding assertion can be saved as a separate step.
8. Arrange these steps in the desired sequence to define the test case flow.
Once all relevant steps are added, click **Save** to finalise the test case and select the appropriate module.
### Use Case: Create, Insert, Update & Validate Data in PostgreSQL Database
**Objective:**\
To validate the creation of a database table, insert multiple records, update a specific record, and confirm the update via query validation.
#### **Steps Overview:**
1. Establish Database Connection
* DB Type: PostgreSQL
* Host: `64.227.131.72`
* Port: `5432`
2. Execute a SQL query to create a table named `Simplify`
3. Insert test data into the newly created table
4. Read Data for Validation
* Use a Read Query action to retrieve current data from the `simplify` table.
* Store the result in a Runtime Parameter for validation.
5. Update a specific record’s last name
6. Read Updated Data for VerificationExecute another Read Query to validate the updated `last_name`
* Again, store this result in a Runtime Parameter to verify if the `last_name` has changed to `Doe-Smith`.
**Validation Outcome:**
This test case validates:
* Successful table creation
* Accurate data insertion
* Proper update functionality
* Reliable data retrieval for assertions
Database test case in SimplifyQA empowers users to validate backend data operations efficiently without the need for complex scripting. With a user-friendly interface, support for various databases, and step-wise execution flow, testers can quickly connect to databases, run queries, assert results, and ensure data integrity.
Whether you're validating application behavior or performing backend regression testing, SimplifyQA makes it seamless to integrate database validation into your automation strategy.
### Frequently Asked Questions (FAQs)
What types of databases does SimplifyQA support?
SimplifyQA supports all major structural and non-structural databases.
Can I use multiple queries in a single test case?
Yes, each query can be added as a separate step in the test case. You can organise them in the required sequence.
What if my connection fails during the test execution?
The execution log will capture connection errors. Make sure host, port, credentials, and firewall rules are correctly configured.
---
# 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.simplifyqa.ai/introduction-to-test-management-in-simplifyqa/create-a-database-test-case.md?ask=&goal=
```
`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.