Introducing my SQL Agent: How to automate SQL with AI. Today I'll share how to make a SQL AI Agent that can automatically connect to databases, understand the tables and schema, and write and execute high-quality SQL queries. I'll guide you through setting up the SQL Agent, creating dozens... of SQL queries, and returning the data from those queries. This AI is a huge help!! Table of Contents: 00:00 Introduction 01:30 How to Get The AI Data Science Agents 03:23 AI Tips Newsletter: Get The Code 04:00 Project Setup 06:30 Setting Up Your First SQL Agent 11:00 Running SQL Queries with the SQL Agent 14:25 Next Steps, Project Roadmap, & AI Bootcamp Github to AI Data Science Team (Army of Copilots): Get the Code by Joining my Python AI/ML Tips Newsletter: P.S. - Want to learn how to build AI projects companies actually want? (live Python Code) On Wednesday, February 12th, I'm sharing one of my best AI Projects: SQL-Writing Business Intelligence Team Register here (570+ registered):show more

P.S. Want free AI, Machine Learning, and Data Science Tips with Python code every Sunday? Don't forget to sign up for my AI/ML Tips Newsletter Here:

How to build an AI agent: 1. Buy this AI Agent Template ($29) 2. Replace "your-data-here" 3. Ship it.

Could this be used for modernization efforts? Say sql SSRS/SSIS to pipelines for a modern data warehouse? Medallion architecture etc

I’m sure it could. As long as the schema and tables are provided then it should work.

this is so cool, ive been waiting for a tool like this. Thank you

Thank you !

@88choppertime Isn’t it the year of the Snake? 🐍

@88choppertime Year of the bot 🤖

good

Automating SQL with AI can save countless hours. Impressive!

the SQL part you think more for beginners to figure out or for advanced data scientists to leverage better with AI?

Both. With advances in LLM, sql will be nothing for an AI as long as it has good knowledge of the database (schema, tables, etc). It’s extremely powerful even for tricky SQL. And you can stack it with a data wrangler AI (pandas agent) that can do stuff SQL can’t handle. So yeah, future is bright for this kinda thing.