START

Ask Question

PHASE 1: Context Analysis

Get Previous Questions from Redis

Any Previous Questions?

Commit: Is this a follow up?

Follow up?

Commit: Rewrite with Context

Use Reformulated Question

Use Original Question

PHASE 2: Question Preparation

Save to Redis

Create Embeddings

PHASE 3: Cache Check

Search Index in Cache

Found Similar Questions?

PHASE 4: Dataset Search

Search Both Datasets

Public SQL

Multi SQL

Compare Scores

Select Best Result

PHASE 5: Answer Refinement

Check User Feedback

Feedback Available?

Commit: Refine with Feedback

Cache in Redis

Use Dataset Answer

Check Answer Quality

Good Enough?

Commit: Generate New Answer

Cache in Redis

Final Answer Ready

Use Cached Answer

PHASE 6: Delivery

Save to MongoDB

Return Answer to User

User Gives Feedback?

Store in MongoDB

END