Loading video...

Video Failed to Load

There was a problem loading this video. This could be due to a temporary network issue or the video might be unavailable.

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

Matt Dancho (Business Science)

96,107 subscribers

77,293 views • 1 year ago •via X (Twitter)

Science & Technology Education Comedy

Anya Rossi• Live Now

Private livecam show

12 Comments

🔥 Matt Dancho (Business Science) 🔥1 year ago

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:

🔮 metaschool1 year ago

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

Adam Lawson1 year ago

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

🔥 Matt Dancho (Business Science) 🔥1 year ago

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

StockNTricks 🥷 YAHUWAH-IS-All 🍄1 year ago

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

🔥 Matt Dancho (Business Science) 🔥1 year ago

Thank you !

Edwina aka ALF1 year ago

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

🔥 Matt Dancho (Business Science) 🔥1 year ago

@88choppertime Year of the bot 🤖

jaykee1 year ago

good

Yaser Abbass1 year ago

Automating SQL with AI can save countless hours. Impressive!

Dr.Yev🔥1 year ago

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

🔥 Matt Dancho (Business Science) 🔥1 year ago

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.

Related Videos

I'm excited to introduce my AI Machine Learning Agent that built 32 ML models in 30 seconds. Today, I'll share with you how to automate building 100s of ML models with the AI ML Agent, which is available on GitHub. We'll create an ML Agent focusing on a Customer Churn Problem. I'll guide you through setting up the ML Agent, creating dozens of ML models, and loading the best model for production. This AI is a huge time-saver! Table of Contents: 00:00 Introduction to my AI Data Science Team 02:56 Setting Up AI Data Science Team 04:48 Running the ML Agent Code 07:12 Create (and Run) the AI Machine Learning Agent 09:53 Reviewing ML Model Summary 12:00 Saving and Loading Models 13:00 Next Steps + Project Roadmap + AI Bootcamp Github to AI Data Science Team (Data Science Agents): Get the Code and Future Updates 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, May 21st, I'm sharing one of my best AI Projects: AI Customer Segmentation Agent with Python Register here (570+ registered):

I'm excited to introduce my AI Machine Learning Agent that built 32 ML models in 30 seconds. Today, I'll share with you how to automate building 100s of ML models with the AI ML Agent, which is available on GitHub. We'll create an ML Agent focusing on a Customer Churn Problem. I'll guide you through setting up the ML Agent, creating dozens of ML models, and loading the best model for production. This AI is a huge time-saver! Table of Contents: 00:00 Introduction to my AI Data Science Team 02:56 Setting Up AI Data Science Team 04:48 Running the ML Agent Code 07:12 Create (and Run) the AI Machine Learning Agent 09:53 Reviewing ML Model Summary 12:00 Saving and Loading Models 13:00 Next Steps + Project Roadmap + AI Bootcamp Github to AI Data Science Team (Data Science Agents): Get the Code and Future Updates 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, May 21st, I'm sharing one of my best AI Projects: AI Customer Segmentation Agent with Python Register here (570+ registered):

Matt Dancho (Business Science)

35,428 views • 1 year ago

I'm excited to introduce my AI Machine Learning Agent that built 32 ML models in 30 seconds. Today, I'll share with you how to automate building 100s of ML models with the AI ML Agent, which is available on GitHub. We'll create an ML Agent focusing on a Customer Churn Problem. I'll guide you through setting up the ML Agent, creating dozens of ML models, and loading the best model for production. This AI is a huge time-saver! Table of Contents: 00:00 Introduction to my AI Data Science Team 02:56 Setting Up AI Data Science Team 04:48 Running the ML Agent Code 07:12 Create (and Run) the AI Machine Learning Agent 09:53 Reviewing ML Model Summary 12:00 Saving and Loading Models 13:00 Next Steps + Project Roadmap + AI Bootcamp Github to AI Data Science Team (Army of Copilots): Get the Code and Future Updates 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, January 29th, I'm sharing one of my best AI Projects: Time Series Forecasting with AI Register here (1570+ registered):

I'm excited to introduce my AI Machine Learning Agent that built 32 ML models in 30 seconds. Today, I'll share with you how to automate building 100s of ML models with the AI ML Agent, which is available on GitHub. We'll create an ML Agent focusing on a Customer Churn Problem. I'll guide you through setting up the ML Agent, creating dozens of ML models, and loading the best model for production. This AI is a huge time-saver! Table of Contents: 00:00 Introduction to my AI Data Science Team 02:56 Setting Up AI Data Science Team 04:48 Running the ML Agent Code 07:12 Create (and Run) the AI Machine Learning Agent 09:53 Reviewing ML Model Summary 12:00 Saving and Loading Models 13:00 Next Steps + Project Roadmap + AI Bootcamp Github to AI Data Science Team (Army of Copilots): Get the Code and Future Updates 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, January 29th, I'm sharing one of my best AI Projects: Time Series Forecasting with AI Register here (1570+ registered):

🔥 Matt Dancho (Business Science) 🔥

240,806 views • 1 year ago

I'm excited to introduce my AI Exploratory Data Analysis (EDA) Agent that built EDA reports, performs correlation analysis, and missing data analysis in 20 seconds. Today, I'll share with you how to automate creating EDA reports with the AI EDA Agent, which is available on GitHub. We'll create an EDA Agent focusing on a Customer Churn Problem. I'll guide you through setting up the EDA Agent, creating EDA reports, and analyzing the findings. This AI agent is a huge time-saver! Table of Contents: 00:00 Introduction to EDA Tools Agent 01:20 Get the AI Data Science Team 04:49 Create the EDA Tools Agent 06:35 Using the EDA Tools Agent for Missing Data and Correlation Funnels 10:00 Get SweetViz EDA Reports with AI 12:00 8-Week AI Bootcamp Github to AI Data Science Team (Army of Copilots): Get the Code and Future Updates 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: Business Intelligence with AI Register here (1570+ registered):

I'm excited to introduce my AI Exploratory Data Analysis (EDA) Agent that built EDA reports, performs correlation analysis, and missing data analysis in 20 seconds. Today, I'll share with you how to automate creating EDA reports with the AI EDA Agent, which is available on GitHub. We'll create an EDA Agent focusing on a Customer Churn Problem. I'll guide you through setting up the EDA Agent, creating EDA reports, and analyzing the findings. This AI agent is a huge time-saver! Table of Contents: 00:00 Introduction to EDA Tools Agent 01:20 Get the AI Data Science Team 04:49 Create the EDA Tools Agent 06:35 Using the EDA Tools Agent for Missing Data and Correlation Funnels 10:00 Get SweetViz EDA Reports with AI 12:00 8-Week AI Bootcamp Github to AI Data Science Team (Army of Copilots): Get the Code and Future Updates 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: Business Intelligence with AI Register here (1570+ registered):

Matt Dancho (Business Science)

31,079 views • 1 year ago

I'm excited to introduce my FREE AI Pandas Data Analyst Copilot which created a data analysis report with dozens of charts from my questions in under 30 seconds. Today, I'll share with you how to automate data analysis with my Pandas AI Agent + Copilot, which is available on GitHub. I'll guide you through setting up the Copilot app, creating dozens of data analysis charts from any CSV or Excel file, and interacting with your data live. This AI is a BIG help! Table of Contents: 00:00 Introduction to the App 02:24 Setting Up the App 04:25 Using the App 08:58 Understanding the Python Code Github to AI Data Science Team (app is in the apps folder): Get the Code and Future Updates by Joining my Python AI/ML Tips Newsletter: === Want to learn how to build AI projects companies actually want? (live Python Code) On Wednesday, April 9th, I'm sharing one of my best AI Projects: Time Series Forecasting with AI Register here (500 Seats):

I'm excited to introduce my FREE AI Pandas Data Analyst Copilot which created a data analysis report with dozens of charts from my questions in under 30 seconds. Today, I'll share with you how to automate data analysis with my Pandas AI Agent + Copilot, which is available on GitHub. I'll guide you through setting up the Copilot app, creating dozens of data analysis charts from any CSV or Excel file, and interacting with your data live. This AI is a BIG help! Table of Contents: 00:00 Introduction to the App 02:24 Setting Up the App 04:25 Using the App 08:58 Understanding the Python Code Github to AI Data Science Team (app is in the apps folder): Get the Code and Future Updates by Joining my Python AI/ML Tips Newsletter: === Want to learn how to build AI projects companies actually want? (live Python Code) On Wednesday, April 9th, I'm sharing one of my best AI Projects: Time Series Forecasting with AI Register here (500 Seats):

Matt Dancho (Business Science)

12,701 views • 1 year ago

How to automate data cleaning with AI. Today, I'll show you how to automate data cleaning using my free AI co-pilot available on GitHub. We'll create an AI co-pilot to automate data-cleaning tasks, focusing on cleaning a customer churn dataset. I'll guide you through setting up the co-pilot and using it effectively. This AI agent is a big help. Table of Contents: 00:00 Introduction 02:52 Setting Up Libraries 06:31 Setting Up LLMs 08:31 Creating Data Cleaner Code 11:02 Data Cleaning Process 13:02 Examining Data Cleaner Function 15:02 Final Thoughts Github to AI Data Science Team (Army of Copilots): Get the Code and Future Updates by Joining my Python AI/ML Tips Newsletter:

How to automate data cleaning with AI. Today, I'll show you how to automate data cleaning using my free AI co-pilot available on GitHub. We'll create an AI co-pilot to automate data-cleaning tasks, focusing on cleaning a customer churn dataset. I'll guide you through setting up the co-pilot and using it effectively. This AI agent is a big help. Table of Contents: 00:00 Introduction 02:52 Setting Up Libraries 06:31 Setting Up LLMs 08:31 Creating Data Cleaner Code 11:02 Data Cleaning Process 13:02 Examining Data Cleaner Function 15:02 Final Thoughts Github to AI Data Science Team (Army of Copilots): Get the Code and Future Updates by Joining my Python AI/ML Tips Newsletter:

Matt Dancho (Business Science)

50,763 views • 1 year ago

I made an AI data science team with Python. I'm excited to share my new project, the AI Data Science Team, a Python package for creating AI co-pilots and agents to assist in common data science tasks. I walk you through the GitHub page, showcasing the progress and potential of this project. I'll explain how these agents can streamline tasks like code generation and modeling pipeline creation, making data science projects more efficient. Introduction to AI Data Science Team Project Integrating Human-in-the-Loop Example: Accessing Agents for Feature Engineering Setting up Feature Engineering Agent Code On GitHub: Python AI-Tips Newsletter (stay updated as I build this project in the open):

I made an AI data science team with Python. I'm excited to share my new project, the AI Data Science Team, a Python package for creating AI co-pilots and agents to assist in common data science tasks. I walk you through the GitHub page, showcasing the progress and potential of this project. I'll explain how these agents can streamline tasks like code generation and modeling pipeline creation, making data science projects more efficient. Introduction to AI Data Science Team Project Integrating Human-in-the-Loop Example: Accessing Agents for Feature Engineering Setting up Feature Engineering Agent Code On GitHub: Python AI-Tips Newsletter (stay updated as I build this project in the open):

Matt Dancho (Business Science)

11,799 views • 1 year ago

Secure your code against SQL injection! 🛡️ GitHub Copilot can help you write safer SQL queries and avoid vulnerabilities. ✅ Learn how and get more security best practices with Copilot here. ⬇️

Secure your code against SQL injection! 🛡️ GitHub Copilot can help you write safer SQL queries and avoid vulnerabilities. ✅ Learn how and get more security best practices with Copilot here. ⬇️

GitHub

27,520 views • 1 year ago

SQLFlow - a great tool to visualize SQL queries. #technology #sql #data #programming

SQLFlow - a great tool to visualize SQL queries. #technology #sql #data #programming

Dr Milan Milanović

255,700 views • 2 years ago

We are redesigning the AI Chat Assistant to include a knowledge base and easy context addition (such as items, SQL queries, and SQL files..). It will also support other vendors and will not be limited to ChatGPT only. 👉 Will be available soon on TablePlus and Bolt SQL

We are redesigning the AI Chat Assistant to include a knowledge base and easy context addition (such as items, SQL queries, and SQL files..). It will also support other vendors and will not be limited to ChatGPT only. 👉 Will be available soon on TablePlus and Bolt SQL

TablePlus

13,356 views • 1 year ago

Meet Houston, your AI data engineer. Run natural language queries with prompt-to-SQL and generate instant charts and dashboards. Build a data pipeline in seconds with our OpenAI chatbot. 🚀#MeetHouston

Meet Houston, your AI data engineer. Run natural language queries with prompt-to-SQL and generate instant charts and dashboards. Build a data pipeline in seconds with our OpenAI chatbot. 🚀#MeetHouston

Space and Time

141,557 views • 2 years ago

In DBeaver 25.0, there is a faster way to generate queries using AI. Simply enter the anand iyer command in the SQL Editor, type your prompt, and execute it.

In DBeaver 25.0, there is a faster way to generate queries using AI. Simply enter the anand iyer command in the SQL Editor, type your prompt, and execute it.

DBeaver

22,713 views • 1 year ago

We built a SQL and NoSQL co-pilot: Generate an answer with accompanying code by typing a question to ask your database - built in code editor - AI sanity check - schema explorer - shareable perma-links to past queries Join the private beta here:

We built a SQL and NoSQL co-pilot: Generate an answer with accompanying code by typing a question to ask your database - built in code editor - AI sanity check - schema explorer - shareable perma-links to past queries Join the private beta here:

Use Bink

74,964 views • 3 years ago

Our AI engineer can now build simple agents using the English language! Tell it what to do, and it will try to generate, execute, and deploy code. AI has already replaced SQL. The next step is to replace Python. It's officially in its 3rd month of internship!!

Our AI engineer can now build simple agents using the English language! Tell it what to do, and it will try to generate, execute, and deploy code. AI has already replaced SQL. The next step is to replace Python. It's officially in its 3rd month of internship!!

Bindu Reddy

46,773 views • 1 year ago

New short course: Building Your Own Database Agent, created with Microsoft Microsoft Azure's Adrián González Sánchez (He/Him/His). You'll learn to build an AI assistant that translates natural language questions into SQL queries. Querying with natural language empowers everyone in your organization, from business leaders to developers, to access data insights directly, using plain English. You’ll use the Azure OpenAI Service and LangChain to implement retrieval augmented generation and function calling, and leverage the Assistants API. You'll gain hands-on experience building an agent that can reason over both CSV files and SQL databases. Please sign up here!

New short course: Building Your Own Database Agent, created with Microsoft Microsoft Azure's Adrián González Sánchez (He/Him/His). You'll learn to build an AI assistant that translates natural language questions into SQL queries. Querying with natural language empowers everyone in your organization, from business leaders to developers, to access data insights directly, using plain English. You’ll use the Azure OpenAI Service and LangChain to implement retrieval augmented generation and function calling, and leverage the Assistants API. You'll gain hands-on experience building an agent that can reason over both CSV files and SQL databases. Please sign up here!

Andrew Ng

109,879 views • 2 years ago

claude code can now write sql almost perfectly. but it still needs to be retaught the same definitions over and over. ontology is how AI agents get 7x faster on your database over time. today we shipped Ontology 3.0 — memory for AI agents, specialized for databases:

claude code can now write sql almost perfectly. but it still needs to be retaught the same definitions over and over. ontology is how AI agents get 7x faster on your database over time. today we shipped Ontology 3.0 — memory for AI agents, specialized for databases:

ethan ding 📊

24,928 views • 24 days ago

Your agents can't keep up with real-time data. Especially when it's scattered across dozens of sources. Most teams waste weeks building custom connectors for every database, API, and data warehouse. Then they build ETL pipelines to sync everything. By the time your agent retrieves the data, it's already outdated. Picture this: Your Postgres database updated 5 minutes ago. Your MongoDB collection changed 2 minutes ago. Your agent is still pulling from yesterday's snapshot. This is why most production RAG systems fail. There's a better approach: MindsDB is an open-source AI platform with a federated data engine that lets you query multiple data sources in real-time using SQL - without moving any data. Here's what makes it different: ↳ Your data stays in place. No ETL pipelines or data duplication ↳ Query Postgres, MongoDB, REST APIs, and more using consistent SQL ↳ JOIN across different sources in real-time with a unified interface ↳ Works with both structured and un-structured data And here's the best part: You don't even need to write SQL. Just describe what you want in plain English, and MindsDB converts it to SQL automatically. The system does all the heavy lifting. The breakthrough for AI agents is simple: When data updates at the source, your agent gets fresh results immediately. No sync delays. No stale embeddings. No custom code for each integration. You can literally write a SQL query that joins a Postgres table with a MongoDB collection and gets live results. This is what production AI applications need but rarely get. In this video, I give you a complete walkthrough of what we just discussed and how to actually do it. Make sure you watch this till the end. I've shared the link to MindsDB's GitHub repo in the next tweet!

Your agents can't keep up with real-time data. Especially when it's scattered across dozens of sources. Most teams waste weeks building custom connectors for every database, API, and data warehouse. Then they build ETL pipelines to sync everything. By the time your agent retrieves the data, it's already outdated. Picture this: Your Postgres database updated 5 minutes ago. Your MongoDB collection changed 2 minutes ago. Your agent is still pulling from yesterday's snapshot. This is why most production RAG systems fail. There's a better approach: MindsDB is an open-source AI platform with a federated data engine that lets you query multiple data sources in real-time using SQL - without moving any data. Here's what makes it different: ↳ Your data stays in place. No ETL pipelines or data duplication ↳ Query Postgres, MongoDB, REST APIs, and more using consistent SQL ↳ JOIN across different sources in real-time with a unified interface ↳ Works with both structured and un-structured data And here's the best part: You don't even need to write SQL. Just describe what you want in plain English, and MindsDB converts it to SQL automatically. The system does all the heavy lifting. The breakthrough for AI agents is simple: When data updates at the source, your agent gets fresh results immediately. No sync delays. No stale embeddings. No custom code for each integration. You can literally write a SQL query that joins a Postgres table with a MongoDB collection and gets live results. This is what production AI applications need but rarely get. In this video, I give you a complete walkthrough of what we just discussed and how to actually do it. Make sure you watch this till the end. I've shared the link to MindsDB's GitHub repo in the next tweet!

Akshay 🚀

65,672 views • 7 months ago

AI tools you should know about 1. - Free Access to GPT-4; No Subscriptions, No Usage Limits, Share & earn 2. - Blog to video 3. - GitHub data explorer 4. - SQL queries for Prisma

AI tools you should know about 1. - Free Access to GPT-4; No Subscriptions, No Usage Limits, Share & earn 2. - Blog to video 3. - GitHub data explorer 4. - SQL queries for Prisma

Csaba Kissi

63,119 views • 2 years ago

Here's the first true showcase of the SQL client I'm building. I've added docking features similar to Zed/VSCode, allowing me to edit queries and view table data simultaneously

Here's the first true showcase of the SQL client I'm building. I've added docking features similar to Zed/VSCode, allowing me to edit queries and view table data simultaneously

Antfroze

235,870 views • 1 year ago