One Prompt is NOT enough: Using AutoGen to code a Multi-Agent Postgres AI Tool

There's only so much you can do with a single prompt. There comes a point in time where you can only do so much with prompt engineering before you hit a wall. Thankfully the code bros at Microsoft have been cooking up AUTOGEN. A simple way to build prompts that work together to solve a problem. AKA a multi-agent framework for problem solving.

In this video we enhance our AI charged Postgres Data Analytics agent backed by GPT-4 and we make it MULTI-AGENT. By splitting up our BI analytics tool into separate agents we can assign individual roles as if our AI was a small working software data analytics company. We build a data analytics agent, a Sr Data Analytics agent, and a Product Manager Agent. Each agent has a specific role and we can assign them special functions that only they can run.

Of course, we utilize our favorite AI pair programming assistant AIDER to generate a first pass of our code in no time with the help of a couple prompt engineering techniques. We build in python and use poetry as our dependency manager. Our goal is to move closer to the future of AI engineering and build a fully functional AI powered data analytics tool with ZERO code. Agentic software is likely the future, so let's stay on the edge of AI engineering and build a multi-agent data analytics tool with AutoGen.

👍 THE CODEBASE

✅ Watch Part One - building a Postgres Data Analytics Agent From Scratch

🤖💻 AI Engineering Resources

🤖 ZERO Touch coding with AIDER?

📘 Chapters
00:00 One MAJOR Problem
00:45 Okay so what is AutoGen?
02:00 Make our app Multi-Agent with AutoGen
05:00 Defining our agents
06:10 Let AI Code for you with AIDER
08:30 Half way there let's clean it up
14:04 Our Multi-Agent Analytics App is Born
18:40 Is AutoGen The Future of AI Engineering?
20:30 AutoGen Pros
21:54 AutoGen Cons
23:10 My take and what's next

🐛 tags
#dataanalytics #agentic #promptengineering

[atchutram]

I have seen many tutorials for Autogen. Almost all of them used the authors' examples. This is the first tutorial with original use case that I saw. Good job.

[fermion]

For anyone that is wondering, YES Microsoft Autogen can run on a Local LLM, you do not need it to use OpenAI. So you can get this whole system to run locally without any data being sent to the cloud, or paying a single cent for it. Got it running yesterday. Of course considerably slower on the local system.

[SeansCorporation]

Immediately subscribed. Very good content and the only real world example I have found using AutoGen yet. Glad you do this and I can't wait for the follow-up video where you allow more tables and columns in total in the database. Very good content. I am sure this is going to blow up by time :)

[ddwinhzy]

This is the right place to learn about autogen. I'm fascinated by the blogger.

[j.hanleysmith]

Best auto Gen video yet. Looking forward to more!

[JRMI]

Dude I’m watching this series like a hawk 🙏🏽💎

[muhammadrazadocs]

I wished I discovered this channel earlier


You definitely earned my subscribe

[GabrielMartins-gxxv]

Honestly your videos are extraordinary! please keep em coming, you’re opening a lot of eyes.

[MarshallMelnychuk]

Great demo, you just opened a bunch of new ideas for me. Much appreciated.

[theDrewDag]

This tutorial is just great. Can't wait for the next part.

[sergk]

well done mate! extremely good quality video, thanks a lot!

[DOCTOR-FLEX]

Thank you for posting a real world example

[Karrq]

Gained a sub. Searched for autogen but everyone is just super long winded with no substance, almost feels like I’m hearing a script from a very repetitive LLM. You are straight to the point ignore the fluff but still give quick and short explanations for everything.
Also ++++ want to follow along with the project because it sounds super interesting

[JJSeattle]

No problems here. 1 prompt to rule them all. Works for me.

[teddyfulk]

Fascinating, you friend have got yourself a subscriber

[lorenminiuk]

Powerful agents .. Very intersting. Thx 🙏🏻

[justriseandgrind]

I'm so glad you did your own example. it helps

[supernewuser]

these professional talking hands really know their shit

[alexanderroodt]

Very neat and well constructed. Thanks for sharing!

[TyMcAuley]

Great video, I’ve been looking at Agentic approaches and waiting for Agentic frameworks for o mature before bringing it more broadly to the attention of others in my company. This is a great state of play/how to video - Thanks!!!!