When it comes to automating tests for your application, some outcomes may be difficult or impossible to validate through the UI alone. With Database Connectivity, you can integrate queries to your database directly into your browser and mobile tests to ensure that your application functions correctly from both the user's perspective and at the data level.
Now generally available, Database Connectivity supports the following use cases:
- Validating that changes in the UI are appropriately reflected in the database
- Validating that changes in the database are appropriately reflected in the UI
- Populating mabl test data using data from your database
- Setting up data to simulate a specific state in your application (also known as data seeding) and tearing it down when the test is complete
The Query Editor also features an AI Query Generator, which you can use to generate a query using a natural language description of what you want to accomplish. The AI Query Generator is a great option if you're new to writing queries or want to jumpstart writing a more complex query.
Creating a query with GenAI
Database Connectivity highlights
Database Connectivity unlocks the potential for more robust, efficient, and complex testing workflows, including the following highlights:
- Create queries that are dynamically generated from parameters you define.
- Direct the same query to run against different database environments by defining environment-specific overrides.
- Seamlessly use the same queries across multiple tests, and centrally manage these reusable queries for any updates you need to make.
- Store and manage your database access credentials securely, directly in mabl.
- Securely access non-public databases through mabl Link or by allowlisting mabl IP addresses.
Supported databases
Mabl currently supports connections to the following database types:
- MySQL
- Microsoft SQL Server
- PostreSQL
- MariaDB
In the next few months, we will also add support for MongoDB, followed by Oracle.
Learn more
To learn more about Database Connectivity at mabl, check out the following articles: