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.

You can now access AI directly from your database! Here is a step-by-step demo that uses GPT-4 to classify customer reviews from a MySQL dataset. And I'm only writing SQL instructions! You have to see it! The model acts as another table in the database. I can query it... show more

Santiago

452,863 subscribers

209,454 views • 3 years ago •via X (Twitter)

Science & Technology Education

Anya Rossi• Live Now

Private livecam show

10 Comments

Raul Junco3 years ago

A common business requirement is solved in a smart way.

Kris Lukanov3 years ago

That's super cool 😎

John3 years ago

Looks very interesting, but I would like to know more about the actual connection to your DB. ie: does MindsDB have access to your actual login details for that db?

Juan Andrés Arriaga3 years ago

Kind of worried about security with this implementation. This is a great start but may not be useful with sensitive data

Rajasekar Nonburaj (𝑅𝒥)3 years ago

Super cool and remind me of sparksql.

Munsif3 years ago

Looks great

Yippee Ki Yay3 years ago

what about SQLite

Marcus Gill Greenwood3 years ago

please tell me it caches! 😬

Luke Skyward3 years ago

Smart!

Yasar Arafath3 years ago

@jaleeledathol

Related Videos

Step-by-step instructions on how to build a RAG system using Oracle + Langchain. The time of the specialized vector store is over. Every major database management system now supports vectors. This is huge! It's one fewer system to worry about, and one fewer component to break. Oracle 26ai comes packed with AI-first features, and I decided to put a simple step-by-step guide on how to use it with Langchain. Check the attached video. You need a couple of things to follow along: 1. Create an Oracle 26ai database—you can do this for free online on the Oracle cloud. 2. Use the notebook linked below for the code. Here is a link to the GitHub Repository with the notebook: Thanks to the Oracle team for the collaboration on getting this video out and for hosting the notebook on their GitHub repository.

Step-by-step instructions on how to build a RAG system using Oracle + Langchain. The time of the specialized vector store is over. Every major database management system now supports vectors. This is huge! It's one fewer system to worry about, and one fewer component to break. Oracle 26ai comes packed with AI-first features, and I decided to put a simple step-by-step guide on how to use it with Langchain. Check the attached video. You need a couple of things to follow along: 1. Create an Oracle 26ai database—you can do this for free online on the Oracle cloud. 2. Use the notebook linked below for the code. Here is a link to the GitHub Repository with the notebook: Thanks to the Oracle team for the collaboration on getting this video out and for hosting the notebook on their GitHub repository.

Santiago

11,366 views • 10 months ago

$Google open-sourced MCP Toolbox for Databases. I gave it access to everything else. For context, Google's MCP Toolbox for Databases is an open-source server that lets AI agents securely query structured databases like PostgreSQL and MySQL through the MCP protocol However, most enterprise knowledge doesn't actually live in databases. It's scattered across emails, Slack threads, GitHub repos, Salesforce records, customer reviews, and internal docs. So Agents can't see any of it, which means they're working with a fraction of the context they need. I fixed that using MindsDB. It acts as a universal SQL layer that sits on top of all your data sources: structured, semi-structured, and unstructured. This means you can query Salesforce, Gmail, GitHub, S3 files, Jira, and 200+ more sources using SQL syntax. The clever part is how it connects to the MCP Toolbox. MindsDB exposes everything through MySQL, so from the Agent's perspective, it's just running SQL and getting context back. It doesn't know or care that the data came from five different sources behind the scenes. This setup unlocks some powerful capabilities: → One SQL interface for dozens of enterprise sources → Cross-datasource joins (combine GitHub and CRM data in a single query) → Built-in ML capabilities for working with unstructured data → Simple MCP tools that now have massively expanded reach In the video below, the Agent queries GitHub data and a customer review database in one SQL query. So what used to require ETL pipelines and weeks of engineering effort now happens instantly. At the end of the day, AI agents are only as useful as the data they can access. This gives them a lot more to work with. I have shared the GitHub repo in the replies, where you can find more details about this.$

Google open-sourced MCP Toolbox for Databases. I gave it access to everything else. For context, Google's MCP Toolbox for Databases is an open-source server that lets AI agents securely query structured databases like PostgreSQL and MySQL through the MCP protocol However, most enterprise knowledge doesn't actually live in databases. It's scattered across emails, Slack threads, GitHub repos, Salesforce records, customer reviews, and internal docs. So Agents can't see any of it, which means they're working with a fraction of the context they need. I fixed that using MindsDB. It acts as a universal SQL layer that sits on top of all your data sources: structured, semi-structured, and unstructured. This means you can query Salesforce, Gmail, GitHub, S3 files, Jira, and 200+ more sources using SQL syntax. The clever part is how it connects to the MCP Toolbox. MindsDB exposes everything through MySQL, so from the Agent's perspective, it's just running SQL and getting context back. It doesn't know or care that the data came from five different sources behind the scenes. This setup unlocks some powerful capabilities: → One SQL interface for dozens of enterprise sources → Cross-datasource joins (combine GitHub and CRM data in a single query) → Built-in ML capabilities for working with unstructured data → Simple MCP tools that now have massively expanded reach In the video below, the Agent queries GitHub data and a customer review database in one SQL query. So what used to require ETL pipelines and weeks of engineering effort now happens instantly. At the end of the day, AI agents are only as useful as the data they can access. This gives them a lot more to work with. I have shared the GitHub repo in the replies, where you can find more details about this.

Akshay 🚀

40,562 views • 8 months ago

Here is an open-source tool to generate a complete dataset. 1. Describe the data you want 2. An orchestrator agent searches the web 3. Sub-agents run in parallel to fetch the data 4. You get a structured dataset you can download For example, you can run Bigset with the query "all leica lenses being sold on amazon", or "leica stores in kyoto with their opening hours and ratings". Bigset uses TinyFish's free Search and Fetch APIs in the background. You can configure it to refresh the data on a schedule. You can self-host it with your own keys. Here is the GitHub repository: You can get free TinyFish API keys here: Thanks to the TinyFish team for partnering with me on this post.

Here is an open-source tool to generate a complete dataset. 1. Describe the data you want 2. An orchestrator agent searches the web 3. Sub-agents run in parallel to fetch the data 4. You get a structured dataset you can download For example, you can run Bigset with the query "all leica lenses being sold on amazon", or "leica stores in kyoto with their opening hours and ratings". Bigset uses TinyFish's free Search and Fetch APIs in the background. You can configure it to refresh the data on a schedule. You can self-host it with your own keys. Here is the GitHub repository: You can get free TinyFish API keys here: Thanks to the TinyFish team for partnering with me on this post.

Santiago

20,877 views • 5 months ago

This is, by far, one of the best uses of modern AI. If you don't use embeddings when querying your database, you are definitely leaving a lot on the table. In this video, I'll show you how to run semantic searches using OpenAI and PostgreSQL. It's all thanks to Pgai, an open-source PostgreSQL extension: Here's what will happen: 1. We'll create a simple table with news articles 2. We'll generate embeddings for those articles 3. We'll run queries on top of those embeddings For this video, I generated the embeddings using a simple query, but pgai Vectorizer would do the same automatically as new information makes it into the database. This is awesome! If you have a PostgreSQL database with data you are searching over, you should start experimenting with semantic searches immediately. For most use cases, a combination of full-text search + semantic search is the best approach. If you don't have a PostgreSQL database around, you can try free for 30 days using Timescale: Thanks to the TimescaleDB (by Tiger Data) team for partnering with me on this post!

This is, by far, one of the best uses of modern AI. If you don't use embeddings when querying your database, you are definitely leaving a lot on the table. In this video, I'll show you how to run semantic searches using OpenAI and PostgreSQL. It's all thanks to Pgai, an open-source PostgreSQL extension: Here's what will happen: 1. We'll create a simple table with news articles 2. We'll generate embeddings for those articles 3. We'll run queries on top of those embeddings For this video, I generated the embeddings using a simple query, but pgai Vectorizer would do the same automatically as new information makes it into the database. This is awesome! If you have a PostgreSQL database with data you are searching over, you should start experimenting with semantic searches immediately. For most use cases, a combination of full-text search + semantic search is the best approach. If you don't have a PostgreSQL database around, you can try free for 30 days using Timescale: Thanks to the TimescaleDB (by Tiger Data) team for partnering with me on this post!

Santiago

110,133 views • 1 year ago

MCP is mind-blowing. Here is a genius setup that will earn you a promotion with your manager. I have multiple data sources: data in S3, MySQL, and local files. Using Spice (an open-source project), I can co-locate all of that data behind a single SQL endpoint and augment it using MCP. Before, accessing data was slow, and I had to make multiple requests to get anything. After using Spice, I can query the data much faster (since it's mirrored locally), and I don't have to worry about where the data is coming from. Spice acts as an MCP server, so I can connect to it from my IDE or the Claude Desktop app and have access to all the data. But even more cool than that: Spice also acts as an MCP client, so it can connect to other MCP servers. This is where things get really interesting! Watch the video. I'm querying multiple data sources from my IDE and using the Google Maps MCP server for driving directions.

MCP is mind-blowing. Here is a genius setup that will earn you a promotion with your manager. I have multiple data sources: data in S3, MySQL, and local files. Using Spice (an open-source project), I can co-locate all of that data behind a single SQL endpoint and augment it using MCP. Before, accessing data was slow, and I had to make multiple requests to get anything. After using Spice, I can query the data much faster (since it's mirrored locally), and I don't have to worry about where the data is coming from. Spice acts as an MCP server, so I can connect to it from my IDE or the Claude Desktop app and have access to all the data. But even more cool than that: Spice also acts as an MCP client, so it can connect to other MCP servers. This is where things get really interesting! Watch the video. I'm querying multiple data sources from my IDE and using the Google Maps MCP server for driving directions.

Santiago

142,696 views • 1 year ago

English is the most powerful language in the world. MongoDB just added support for MCP, and literally anyone can now query data without knowing anything about databases. If you know English, you are all set. I recorded a quick video to show you how I connect to a sample Airbnb database and run different queries: • How many listings? • How many listings in the US? • What's the list of countries in these listings? It takes 10 seconds to configure Claude, Cursor, WindSurf, or any other AI assistant to connect to MongoDB's MCP Server. By the way, the server supports much more than queries: • You can explore your collections • You can fetch schema information • You can generate app code snippets • You can manage your databases • You can handle cluster/user/admin tasks Here is a link to the MCP server GitHub repository: This is huge for developers. It's even bigger for non-developers. Thanks to the MongoDB team for collaborating with me on this post.

English is the most powerful language in the world. MongoDB just added support for MCP, and literally anyone can now query data without knowing anything about databases. If you know English, you are all set. I recorded a quick video to show you how I connect to a sample Airbnb database and run different queries: • How many listings? • How many listings in the US? • What's the list of countries in these listings? It takes 10 seconds to configure Claude, Cursor, WindSurf, or any other AI assistant to connect to MongoDB's MCP Server. By the way, the server supports much more than queries: • You can explore your collections • You can fetch schema information • You can generate app code snippets • You can manage your databases • You can handle cluster/user/admin tasks Here is a link to the MCP server GitHub repository: This is huge for developers. It's even bigger for non-developers. Thanks to the MongoDB team for collaborating with me on this post.

Santiago

44,855 views • 1 year ago

Building with AI gets easier every day. Here is an open-source library that makes integrating AI into an application extremely easy: Star the repository! This library alone can make React the best front-end framework out there! There are a bunch of cool things I like about CopilotKit. Here are 3 of them: 1. It allows you to take any -powered agent and bring it into your application. (This is a brand-new feature!) 2. You can build an AI-powered chatbot in your application. The chatbot will have access to your context and can act on the application. 3. You can build a RAG workflow to process and answer questions from a real-time knowledge base. I recorded a video to show you how simple it is to make some of this happen. A few lines of code, and you are in business. Here is a link to the sample application: CopilotKit is open-source. You can self-host it. You can use it with any LLM. Thanks to the team for showing me their tool and collaborating with me on this post!

Santiago

108,884 views • 2 years ago

Imagine an AI application that can type anywhere you can and use the full context of what's on your screen. This is the application we all deserve (at least if you have macOS.) Check out Omnipilot. It's an app that works with every other macOS application and uses Claude Sonet 3.5 in the background—it also supports Gemini and GPT-4o. Here is the idea: You can use the tool to ask questions about anything on your screen. Or you can use it to autocomplete the text you are typing. You don't need to copy and paste anymore or waste your time providing context to a model. It sees what you see. It works right where you are. That's pretty cool. Here are a couple of cool examples: • Use it to reply to an email • Use it in the terminal to autocomplete a command • Use it to finish a document • Use to send a message on Slack AI at the system level is bonkers. You can read a ton more on their Product Hunt launch page: Thanks to the Omnipilot team for collaborating with me on this post!

Imagine an AI application that can type anywhere you can and use the full context of what's on your screen. This is the application we all deserve (at least if you have macOS.) Check out Omnipilot. It's an app that works with every other macOS application and uses Claude Sonet 3.5 in the background—it also supports Gemini and GPT-4o. Here is the idea: You can use the tool to ask questions about anything on your screen. Or you can use it to autocomplete the text you are typing. You don't need to copy and paste anymore or waste your time providing context to a model. It sees what you see. It works right where you are. That's pretty cool. Here are a couple of cool examples: • Use it to reply to an email • Use it in the terminal to autocomplete a command • Use it to finish a document • Use to send a message on Slack AI at the system level is bonkers. You can read a ton more on their Product Hunt launch page: Thanks to the Omnipilot team for collaborating with me on this post!

Santiago

72,306 views • 2 years ago

Supabase RLS tester is here! You can run a query as another user and see which RLS policy took effect! It also supports testing queries via client libraries, with AI converting them to SQL. Enable it today from the feature preview section on the dashboard!

Supabase RLS tester is here! You can run a query as another user and see which RLS policy took effect! It also supports testing queries via client libraries, with AI converting them to SQL. Enable it today from the feature preview section on the dashboard!

Tyler Shukert

16,336 views • 5 months ago

With Opus 4.7 out, I wanted to remind you that there is an official Supabase connector, and it is the easiest way to add a backend to your app! You can - Run SQL - Create database migrations - Deploy Edge Functions - Access logs to debug - Fetch the security advisor output All while chatting with it!

With Opus 4.7 out, I wanted to remind you that there is an official Supabase connector, and it is the easiest way to add a backend to your app! You can - Run SQL - Create database migrations - Deploy Edge Functions - Access logs to debug - Fetch the security advisor output All while chatting with it!

Tyler Shukert

26,531 views • 6 months ago

This is a very clever idea to use an LLM with your SQL data. SQL + AI has been tried before, but one of the best parts of this solution is getting the same exact OpenAI's completion API. In other words: You are now talking to an LLM that knows everything about your database and you don't even notice it! I recorded a 2-min video to show you how it works. Thanks to the team for the collaboration, listening to my feedback, and helping me understand what they built. Go to to try this yourself.

This is a very clever idea to use an LLM with your SQL data. SQL + AI has been tried before, but one of the best parts of this solution is getting the same exact OpenAI's completion API. In other words: You are now talking to an LLM that knows everything about your database and you don't even notice it! I recorded a 2-min video to show you how it works. Thanks to the team for the collaboration, listening to my feedback, and helping me understand what they built. Go to to try this yourself.

Santiago

230,551 views • 2 years ago

The era of manually analyzing data will come to an end. AI can now do a lot of this automatically. It's a huge time saver. I do data analysis for a living, and I'm a huge fan of writing Jupyter notebooks to do it all, but it's now hard to justify manually writing code that you can generate in a few seconds. I still check everything manually, but breaking down datasets into tables and charts is now 10x easier than it's ever been. Here is a video where I'm using Retool. I load a dataset and generate a few charts as quickly as I can think. The speed at which we can go from one idea to a working solution is astonishing.

The era of manually analyzing data will come to an end. AI can now do a lot of this automatically. It's a huge time saver. I do data analysis for a living, and I'm a huge fan of writing Jupyter notebooks to do it all, but it's now hard to justify manually writing code that you can generate in a few seconds. I still check everything manually, but breaking down datasets into tables and charts is now 10x easier than it's ever been. Here is a video where I'm using Retool. I load a dataset and generate a few charts as quickly as I can think. The speed at which we can go from one idea to a working solution is astonishing.

Santiago

70,812 views • 1 year ago

OpenAI Dev Day Just kicked off and it was the biggest day for AI since the launch of GPT-4 in April. Here's a 3 minute video with everything you need to know and a full summary: 1. GPT-4 Turbo is released. It is much better than GPT-4, can accept up to 128k characters and is 3x cheaper. The knowledge cut off is now April 2023 2. Text to Speech is also being released. They offer 6 hyper-realistic voice models that are the best I've heard from any other AI t-t-s software on the market. 3. Copyright Shield. OpenAI will actually defend your legal costs if you get sued for copyright infringement using their API! 4. GPTs. Maybe the most exciting IMHO, you can now create custom "GPTs" by training your own model of GPT and selling it on their store. This will create a massive shakeup of the current AI software landscape and is the first step towards autonomous agents.

OpenAI Dev Day Just kicked off and it was the biggest day for AI since the launch of GPT-4 in April. Here's a 3 minute video with everything you need to know and a full summary: 1. GPT-4 Turbo is released. It is much better than GPT-4, can accept up to 128k characters and is 3x cheaper. The knowledge cut off is now April 2023 2. Text to Speech is also being released. They offer 6 hyper-realistic voice models that are the best I've heard from any other AI t-t-s software on the market. 3. Copyright Shield. OpenAI will actually defend your legal costs if you get sued for copyright infringement using their API! 4. GPTs. Maybe the most exciting IMHO, you can now create custom "GPTs" by training your own model of GPT and selling it on their store. This will create a massive shakeup of the current AI software landscape and is the first step towards autonomous agents.

Mark Gadala-Maria

79,199 views • 3 years ago

I can search a database with 32 million records in less than 50 milliseconds. This speed is insane! There's no reason your search is slow. There's no reason you aren't using this library when building applications with a lot of data. Take a look at typesense |. It's an open-source search engine. It's crazy fast and easy to use. They are sponsoring this post. Here is their GitHub repository: You can use the library in Python, JavaScript, PHP, Ruby, Swift, and pretty much any other programming language out there. Here are some of the things you can do with Typesense: • Vector search over embeddings • Conversational search for RAG applications • Image similarity search • Voice search And it does all of this extremely fast. A few interesting notes about the library: • Optimized for developer happiness • Works out of the box for most use cases • Very intuitive API • Easy to deploy and scale Probably the best way to compare them is against ElasticSearch. The latter is much more complex to configure and run with a steep learning curve. Check their GitHub repository. They have examples, tutorials, and everything you need.

I can search a database with 32 million records in less than 50 milliseconds. This speed is insane! There's no reason your search is slow. There's no reason you aren't using this library when building applications with a lot of data. Take a look at typesense |. It's an open-source search engine. It's crazy fast and easy to use. They are sponsoring this post. Here is their GitHub repository: You can use the library in Python, JavaScript, PHP, Ruby, Swift, and pretty much any other programming language out there. Here are some of the things you can do with Typesense: • Vector search over embeddings • Conversational search for RAG applications • Image similarity search • Voice search And it does all of this extremely fast. A few interesting notes about the library: • Optimized for developer happiness • Works out of the box for most use cases • Very intuitive API • Easy to deploy and scale Probably the best way to compare them is against ElasticSearch. The latter is much more complex to configure and run with a steep learning curve. Check their GitHub repository. They have examples, tutorials, and everything you need.

Santiago

160,154 views • 2 years ago

The World Cup is pulling in millions of views right now. The question is: How can you use AI and YouTube Automation to benefit from all that attention? This girl sheres the step by step of how creators are using it to generate views and monetize content 👇

The World Cup is pulling in millions of views right now. The question is: How can you use AI and YouTube Automation to benefit from all that attention? This girl sheres the step by step of how creators are using it to generate views and monetize content 👇

Christabel | AI Video Producer

23,354 views • 5 months ago

You can now use OpenAIReview directly in your browser 📷. This is a part of our mission to make quality AI-assisted reviewing open and accessible to everyone. Reviews on the web version are free of charge, and you can get up to 3 reviews a day. Try it here!

You can now use OpenAIReview directly in your browser 📷. This is a part of our mission to make quality AI-assisted reviewing open and accessible to everyone. Reviews on the web version are free of charge, and you can get up to 3 reviews a day. Try it here!

Chenhao Tan

46,166 views • 7 months ago

This is huge! This fixes the universal problem with conversational agents: hallucinations! Every company that builds customer-facing agents struggles to align them with business rules and make them consistent. If you solve this, you'll become a hero overnight. Check out Parlant, a free, open-source library taking off on GitHub. This is why it's big: 1. You have 10x more control over what your conversation agent says 2. You control how it conducts conversations 3. You control the service protocols and rules it follows 4. You control what it can and can't say Here is how Parlant's engine works behind the scenes as soon as your agent receives a question from a customer: 1. It loads the necessary domain terminology 2. It finds the relevant guidelines to answer the question 3. It invokes your tools to gather any relevant information 4. It implements self-critique to craft/evaluate its response iteratively All of this makes it very hard for an agent to hallucinate. Here is the GitHub repository: And here is a paper showing the prompt engineering method Parlant uses behind the scenes (4.8% more accurate than Chain of Thought!):

This is huge! This fixes the universal problem with conversational agents: hallucinations! Every company that builds customer-facing agents struggles to align them with business rules and make them consistent. If you solve this, you'll become a hero overnight. Check out Parlant, a free, open-source library taking off on GitHub. This is why it's big: 1. You have 10x more control over what your conversation agent says 2. You control how it conducts conversations 3. You control the service protocols and rules it follows 4. You control what it can and can't say Here is how Parlant's engine works behind the scenes as soon as your agent receives a question from a customer: 1. It loads the necessary domain terminology 2. It finds the relevant guidelines to answer the question 3. It invokes your tools to gather any relevant information 4. It implements self-critique to craft/evaluate its response iteratively All of this makes it very hard for an agent to hallucinate. Here is the GitHub repository: And here is a paper showing the prompt engineering method Parlant uses behind the scenes (4.8% more accurate than Chain of Thought!):

Santiago

93,080 views • 1 year ago