This project demonstrates how AutoGen agents can be used to dynamically execute functions through a discussion where it can be easily integrate with existing systems.
This application showcases the integration of AutoGen's AI agents with a Flask-based web API and a SQL Server database. It demonstrates how AI agents can:
- Engage in dynamic conversations with users
- Interpret user intents
- Execute database operations based on the conversation
- 🤖 Dynamic AI-driven chat interface
- 📊 Real-time inventory management with DataTables
- 🔄 Automatic refresh after operations
- 💾 CRUD operations through both chat and UI
- 🔍 Advanced search and filtering capabilities
-
AutoGen Agents:
AssistantAgent
: Interprets user requests and manages the conversation flowUserProxyAgent
: Executes functions as directed by the AssistantAgent
-
Flask API: Provides endpoints for starting chats, sending messages, and retrieving responses
-
Database Integration: Uses pyodbc to connect to a SQL Server database for CRUD operations on inventory items
- Dynamic Function Execution: The AI can decide which function to call based on the conversation context.
- Database Operations:
- Add new items to the inventory
- Retrieve item information
- Conversational UI: Users interact with the system through natural language.
- Asynchronous Processing: Utilizes asyncio for non-blocking operations.
- Clone the repository
git clone https://github.com/ranga-tec/Autogen-dynamic-functions.git
- Install dependencies
pip install -r requirements.txt
-
Configure your database connection in
app.py
-
Run the application
python app.py
- This approach is very useful when it comes to voice control systems or for integrating voice control for existing systems.
- Easily can be extended to enhance advanced autogen AI capabilities to systems.
UI influenced by Yeyu Huang's work