VS Code + Copilot + MCP + Kusto = Effortless Analytics

Hi everyone, I’m Todd and welcome back to AI Powered PM. Today we’re diving into something that will completely change how you write and explore Kusto queries — no code required. 📥 Download the prompt file: 👉 https://bit.ly/aipm1 💻 https://github.com/taipoweredpm/ai-powered-pm In this video, I’ll show you how to: ✅ Connect to a Kusto database using the Azure MCP extension in VS Code Insiders Edition ✅ Automatically discover schema, generate queries, and create reports using GitHub Copilot prompts ✅ Save and share your results through prompt.md files for easy reuse across your team This workflow lets AI do all the heavy lifting. You’ll see how Copilot can explore tables, summarize data, and even generate demo reports — all from a single prompt. If you’ve ever watched someone write, debug, and rerun Kusto queries manually, this is the faster, smarter way. Next video: We’ll move from developer mode to dashboards and reports that non-technical users can run. Stay tuned — it’s going to be even more powerful.