More Than a Vibe: AI-Driven SQL that Actually Works
In this hands-on workshop, we will demonstrate how AI can empower you to "vibe code"—using AI to write accurate SQL, enabled only by the magic of MotherDuck & DuckDB. Participants will work with a real life spatial data set to tackle real-world challenges and see firsthand how AI-Driven DuckDB SQL can transform data handling into a rapid, low-risk, interactive process. By the end of the workshop, participants will have experienced an end-to-end workflow: from ingesting and querying spatial data with DuckDB/MotherDuck, to refining query results with AI, and finally presenting insights through Python visualizations. This session is designed to empower you to confidently incorporate AI in your coding processes, transforming how you approach data analysis and decision making in real-world business scenarios. 1. Key Components of the Workshop: Dataset Handling: Participants will work with a spatial dataset to evaluate potential locations for opening a new BBQ restaurant. Thanks to MotherDuck, the dataset is easily brought down locally in a highly compressed format, ensuring a quick and safe environment for experimentation. 2. Live AI-Assisted Coding: The workshop will feature a live demonstration where an AI tool iteratively generates SQL queries. Rather than pre-defining metrics, the AI assists in exploring and defining the spatial parameters necessary to identify the optimal restaurant location—a process that mirrors real-world, dynamic decision-making. 3. Real-Time Data Visualization: As queries are refined and executed, Python will be used to chart the results on the fly. Utilizing uv for environment management alongside visualization libraries such as Seaborn and Matplotlib, participants will see how spatial insights are translated into clear, actionable charts. 4. Iterative, Low-Risk Workflow: The session emphasizes a low-risk, experimental approach. If the AI-generated code isn't perfect, no harm is done—files can be quickly deleted or corrected, encouraging a creative, hands-on learning environment where trial and error lead to deeper understanding.