Optimize SQL Stored Procedures with LLM [Agoda]
Episode 130 of the Snacks Weekly on Data Science podcast, hosted by Pan Wu, titled "Optimize SQL Stored Procedures with LLM [Agoda]" was published on March 23, 2026 and runs 7 minutes.
March 23, 2026 ·7m · Snacks Weekly on Data Science
Summary
In this episode, we explore how Agoda tackled a costly engineering bottleneck by integrating GPT into their CI/CD pipeline to analyze failing SQL stored procedures automatically and suggest optimizations — complete with rewritten queries, index recommendations, and side-by-side performance comparisons. The result is a human-in-the-loop system where AI handles the heavy lifting and engineers make the final call, leading to significant improvements in engineering productivity.For more details, you can refer to their published tech blog, linked here for your reference: https://medium.com/agoda-engineering/how-agoda-uses-gpt-to-optimize-sql-stored-procedures-in-ci-cd-29caf730c46c
Episode Description
In this episode, we explore how Agoda tackled a costly engineering bottleneck by integrating GPT into their CI/CD pipeline to analyze failing SQL stored procedures automatically and suggest optimizations — complete with rewritten queries, index recommendations, and side-by-side performance comparisons. The result is a human-in-the-loop system where AI handles the heavy lifting and engineers make the final call, leading to significant improvements in engineering productivity.
For more details, you can refer to their published tech blog, linked here for your reference: https://medium.com/agoda-engineering/how-agoda-uses-gpt-to-optimize-sql-stored-procedures-in-ci-cd-29caf730c46c
Similar Episodes
Dec 11, 2025 ·20m
Nov 12, 2025 ·19m
Nov 4, 2025 ·16m
Oct 8, 2025 ·31m
Sep 24, 2025 ·5m
Sep 18, 2025 ·19m