DEV Community

Cover image for Customer Support RAG Assistant
kobtze
kobtze

Posted on

Customer Support RAG Assistant

This is a submission for the Open Source AI Challenge with pgai and Ollama

What I Built

I created a customer support RAG assistant.

  1. User request for is submitted (e.g. 'having trouble with XYZ')
  2. Semantic search is performed to look for similar tickets in DB
  3. Prompt to LLM includes user query and similar tickets retrieved
  4. Server returns suggested response to user

Demo

https://bit.ly/4flG7xI
MS Office issue

Tools Used

pgvector

Signed up for TimescaleDB service to create a PostgreSQL instance with vector capabilities using pgvector.

Timescale CSV import

Used this dataset from Kaggle with ~600 customer support tickets.

pgai Vectorizer / Open AI API

Created a vectorizer to create vector embeddings of users requests (email body column).

gpt-3.5-turbo

Server calls gpt-3.5-turbo completions API to compose suggested response to user based on their query and similar tickets found.

Source Code

Server App
Client Web App

Final Thoughts

Prize categories

Vectorizer Vibe😃

Image of AssemblyAI tool

Transforming Interviews into Publishable Stories with AssemblyAI

Insightview is a modern web application that streamlines the interview workflow for journalists. By leveraging AssemblyAI's LeMUR and Universal-2 technology, it transforms raw interview recordings into structured, actionable content, dramatically reducing the time from recording to publication.

Key Features:
🎥 Audio/video file upload with real-time preview
🗣️ Advanced transcription with speaker identification
⭐ Automatic highlight extraction of key moments
✍️ AI-powered article draft generation
📤 Export interview's subtitles in VTT format

Read full post

Top comments (0)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More

👋 Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay