# Ability to connect to our DB to run DB validations. What are the possible connectivity issues and possibility to connect? You can create a SQL script that do DB SQL queries and validate them as the following example:
[Copy](javascript:void(0);)
``` -- step=Connect

-- username=aiq

-- password=thePasswordGoesHere

-- url=jdbc:mysql://mysqlsmoketest.us-west-2.rds.amazonaws.com:3306/aiq

-- driver_class=com.mysql.jdbc.Driver

-- database=aiq

-- dialect=org.appvance.hibernate.dialect.MySQLDialect

-- connect

-- step=Step1

SELECT * FROM `aiq`.`SummaryElement` LIMIT 100;

-- step=Step2

SELECT * FROM `aiq`.`Definition` LIMIT 100;

-- step=Step3

SELECT * FROM `aiq`.`NodePerScenario` LIMIT 100;

-- step=Step4

SELECT * FROM `aiq`.`SummaryElement` LIMIT 100;

-- step=Step5

SELECT * FROM `aiq`.`UTPIterationPerExecution` LIMIT 100;

-- step=Step6

SELECT * FROM `aiq`.`TypeLong` LIMIT 100;

-- step=Step7

SELECT * FROM `aiq`.`UTPScenarioExecution` LIMIT 100;

-- step=Step8

SELECT * FROM `aiq`.`UTPIterationPerExecution` LIMIT 100;

-- step=Step9

SELECT * FROM `aiq`.`DefaultPercentil` LIMIT 100;

-- step=Step10

SELECT * FROM `aiq`.`DetailedDuration` LIMIT 100;

-- step=Step11

SELECT * FROM `aiq`.`DetailedElementAttribute` LIMIT 100;

-- step=Step12

SELECT * FROM `aiq`.`SummaryChildElement` LIMIT 100;

-- step=Step13

SELECT * FROM `aiq`.`SummaryElement` LIMIT 100;

-- step=Step14

SELECT * FROM `aiq`.`Definition` LIMIT 100;

-- step=Step15

SELECT * FROM `aiq`.`NodePerScenario` LIMIT 100;

-- step=Step16

SELECT * FROM `aiq`.`SummaryElement` LIMIT 100;

-- step=Step17

SELECT * FROM `aiq`.`UTPIterationPerExecution` LIMIT 100;

-- step=Step18

SELECT * FROM `aiq`.`TypeLong` LIMIT 100;

-- step=Step19

SELECT * FROM `aiq`.`UTPScenarioExecution` LIMIT 100;

-- step=Step20

SELECT * FROM `aiq`.`UTPIterationPerExecution` LIMIT 100;

-- step=Step21

SELECT * FROM `aiq`.`DefaultPercentil` LIMIT 100;

-- step=Step22

SELECT * FROM `aiq`.`DetailedDuration` LIMIT 100;

-- step=BeforeDisc

-- step=Disconnect

-- disconnect ```
if the sql script contains a line after a SELECT line \-- storeInLocker=MyTestLockerKey1 then the result from the SELECT call will be stored in TheLocker (memory) with a name "MyTestLockerKey1" You can then use a next script in your use case that consume that response (Java, TestNG, TestDesigner, or others)
--- Last updated: June 02, 2023 If you have any feedback on this topic, please contact us at