dbt-llm-agent leverages large language models to transform how data teams interact with dbt projects. It empowers users to explore and query their data models using plain English, auto-generate SQL based on high-level prompts, and retrieve model documentation instantly. The agent supports multiple LLM providers—OpenAI, Cohere, Vertex AI—and integrates seamlessly with dbt’s Python environment. It also offers AI-driven code reviews, suggesting optimizations for SQL transformations, and can generate model tests to validate data quality. By embedding an LLM as a virtual assistant within your dbt workflow, this tool reduces manual coding efforts, enhances documentation discoverability, and accelerates the development and maintenance of robust data pipelines.

Memor offers a memory subsystem for language model agents, allowing them to store embeddings of past events, user preferences, and contextual data in vector databases. It supports multiple backends such as FAISS, ElasticSearch, and in-memory stores. Using semantic similarity search, agents can retrieve relevant memories based on query embeddings and metadata filters. Memor’s customizable memory pipelines include chunking, indexing, and eviction policies, ensuring scalable, long-term context management. Integrate it within your agent’s workflow to enrich prompts with dynamic historical context and boost response relevance over multi-session interactions.