Summarize with:ChatGPTPerplexityGrokClaude

Overview

What is DB Connector? DB Connector lets you run a query against your own database directly inside a test. Once a database step is added, it executes your query and stores the response in a local variable — which you can then assert on or reuse in later steps. Supported queries: SELECT, INSERT, and UPDATE.

Pre-requisite

• User should have Pcloudy account
• User should have Qpilot access
• User should have DB details

How it works

There are three stages:

Create a connection — save your database connection details once, under Connectors.

Add a database step — in your test, select that connection and write your query.

Use the output — the query result is saved to a local variable you can reuse and assert on.

Step 1 — Create a database connection

Connection details are stored first, under Connectors, so they can be reused across tests.

1. From the dashboard, Go to Qstidio->Qpilot ->open Connectors.
2. Click Create Connection. The Add Database Connection Details panel opens.
3. Fill in the connection fields:
   • Connection Type — e.g. TCP/IP.
   • Connection Name — a name you’ll recognise (e.g. RVN).
   • Database Type — PostgreSQL, MySQL, or MSSQL.
   • Description — optional.
   • DB Connection Details — Hostname/IP, Port, Username, Password, and Database Name.
4. Save - The connection now appears in the Connectors table, where you can edit or delete it from the Actions column.

note

Note: You must save a connection before you can add a database step — the step picks the connection from this saved list.

Step 2 — Add a database step to your test

Open the test case you want to add the query to, then add a database step from the step composer. The Add database query window opens.

1. In the connection list on the left, select (or search for) the connection you created. Its host, port, and database name appear on the right.
2. Write your query in the Query Editor. The query type (for example SELECT) is detected and shown.
3. Click Add Database Step.

The step is added to your test as “Execute a database query”, showing the Host, DB Name, DB Type, and the query you wrote.

Step 3 — Use the query output

When the step runs, the database response is stored in a local variable — shown next to Output on the step (for example):

Output:  {{pgTablesResult}}  =  
[{"schemaname":"information_schema", ...}] 

You can view all stored values under the Local Variables tab.

From there you can reuse the variable in later steps — reference it with the

{{variable_name}}

syntax to assert on the result, extract a value, or feed it into the next step.

Supported queries & databases

• Query types (current): SELECT, INSERT, UPDATE.
• Database types: PostgreSQL, MySQL, MSSQL.
• Connection sharing: Private Connectors (only you) or Team Connectors (shared with your team).

Tips

• Save the connection once and reuse it across multiple tests and steps.
• Give connections clear names — you’ll select them by name when adding a step.
• Use the show/hide control on the Password field to confirm credentials before saving.
• Reference the output variable with in any later step.