+-----------+ HTTP Request +---------------------+ SQL Query
+-----------------+
| User (UI/ |-------------------->| Your Application |------------------->|
PostgreSQL |
| CLI) | | (Python, [Link],etc)|<-------------------|
(Context Store) |
+-----------+ HTTP Response | - Fetches context |<--- SQL Result
+-----------------+
(LLM output) | - Formats prompt |
| - Calls local LLM |
| - Stores new context|
+---------------------+
| ^
| | LLM Request (prompt with context)
Local API Call| | LLM Response
v |
+---------------------+
| Locally Running LLM |
| (Ollama, LM Studio, |
| [Link], etc.) |
+---------------------+