Building a Fully Local, Open Source Text2SQL Agent with Long Term Memory — No API Keys, No Cloud.

Building a Fully Local, Open Source Text2SQL Agent with Long Term Memory - No API Keys, No Cloud. A production grade text-to-SQL system with persistent memory that runs entirely on your own hardware using Ollama, PostgreSQL with pgvector and sentence-transformers. Two users, two preferences, one memory-powered agent. Each gets personalized SQL without repeating themselves Every Text2SQL tutorial I’ve seen relies on OpenAI/Claude for the LLM, Pinecone for vectors, and some managed cloud service to glue it all together.