Customer Support Tickets and grievance
Setting up the customer care database
- Ensure Docker Desktop is installed
- Now lets start the postgres container with sample schema in it
- Run the container
docker run --name customer-care-db \
-e POSTGRES_USER=myuser \
-e POSTGRES_PASSWORD=mypassword \
-e POSTGRES_DB=mydb \
-p 5432:5432 \
-d postgres:16
- Windows
docker run --name customer-care-db `
-e POSTGRES_USER=myuser `
-e POSTGRES_PASSWORD=mypassword `
-e POSTGRES_DB=customerdb `
-p 5432:5432 `
-d postgres:16
-
To access this db we need db clients like pgadmin etc or we can use a visual studio extension
Postgres -
To make it simple to create a container bring everything up and remove all of this we will be using docker compose
-
Refer Here for the changes
Steps to be executed by you
- Ensure git is installed and docker desktop is installed.
- Now clone the project
git clone https://github.com/GenAIDevelopment/agenticai.git
cd apr26/projects/customer_care_agent
uv sync
docker compose up -d
- Now wait for some time and navigate to
http://localhost:5050- username: admin@admin.com
- password: admin
-
Setting up SQLDatabase Toolkit with llm and postgres db and invoking a query in natural language using langgraph
-
Refer Here this changeset and execute
uv run sample.py
