quality_assurance · travel · workflow
Agoda integrates GPT into CI/CD pipeline to optimize SQL stored procedures
SQL stored procedure optimization consumed approximately 366 man-days per year at Agoda, with 320 of those days on performance test failures alone, and 90th-percentile MR approval times reaching 4.1 hours.
How it works
Common implementation structure
How this type of workflow is generally built, generalized across documented cases — not tied to any one vendor's stack. Click any stage to read what happens there. Specific products that implement these stages appear in “Tools commonly seen” below.
Stage 1 · SP merge request triggers CI/CD test
Every new stored procedure triggers a merge request, which kicks off performance tests in the CI/CD pipeline.
Tools used
GPT
Outcome
After integrating GPT, the team observed reduced manual review time and improved SP quality, with GPT optimization accuracy reaching around 25%.
Results
Time savedapproximately 366 man-days
Volumearound 25%
Grounding & classification
Source type: technical build writeup
23 fields verified against source quotes.
code generationsummarizationcode diff prfailure mode describedhuman review describedmetric backednamed customerproduction runtime claimedtools describedworkflow describedtravelaccuracy improvementemployee productivitytime savedtechnical build writeupquality assuranceai draft human approval