# mohsin66/langchain_langgraph_rnd architecture

> Architecture diagram of the GitHub repository mohsin66/langchain_langgraph_rnd, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-30). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/mohsin66/langchain_langgraph_rnd
- Repository: https://github.com/mohsin66/langchain_langgraph_rnd

## Overview

This repository is a set of standalone LangChain and LangGraph prototypes for chat and natural-language-to-SQL, not one integrated application. The user-facing workflow is generally a command-line question, followed by model invocation and printed text or SQL. SQL approaches include schema-in-prompt, schema retrieval, and SQL-agent/toolkit variants; separate chatbot examples provide general conversation. The README gives no further product description. Connections below reflect the sampled scripts; the simple SQL chain references a schema filename absent from the tree, so its input source is not mapped.

Main entry points: [`langgraph/gemini/langgraph_gemini_rag_sql.py`](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/gemini/langgraph_gemini_rag_sql.py) (Gemini RAG SQL), [`langgraph/groqapi/langgraph_groqapi_rag_sql.py`](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/groqapi/langgraph_groqapi_rag_sql.py) (Groq RAG SQL), [`database_express_schema.txt`](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/database_express_schema.txt) (Database Schema), [`langchain/gemini/langchain_gemini_sqltoolkit.py`](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langchain/gemini/langchain_gemini_sqltoolkit.py) (Gemini SQL Agent)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_sql_graphs["LangGraph SQL"]
  node_gemini_lightrag["Gemini LightRAG SQL"]
  node_gemini_rag["Gemini RAG SQL"]
  node_groq_rag["Groq RAG SQL"]
  node_groq_sql["Groq Schema SQL"]
end

subgraph group_sql_chain["LangChain SQL"]
  node_gemini_toolkit["Gemini SQL Agent"]
  node_groq_toolkit["Groq SQL Agent"]
  node_groq_chain["Groq SQL Chain"]
end

subgraph group_chatbots["Chatbots"]
  node_groq_chat["Groq Chatbot"]
  node_ollama_chat["Ollama Chatbot"]
end

subgraph group_data["Schema Data"]
  node_schema["Database Schema"]
end

node_user(("CLI User"))
node_groq_service{{"Groq Model"}}
node_gemini_service{{"Gemini Model"}}
node_ollama_service{{"Ollama Model"}}
node_vector_index[("FAISS Index")]
node_embeddings{{"HuggingFace Embeddings"}}
node_sql_toolkit["SQL Toolkit"]
node_placeholder_db[("SQLite Placeholder")]

node_user -->|"asks"| node_gemini_lightrag
node_gemini_lightrag -->|"prints SQL"| node_user
node_gemini_lightrag -->|"reads schema"| node_schema
node_gemini_lightrag -->|"invokes"| node_gemini_service
node_user -->|"asks"| node_gemini_rag
node_gemini_rag -->|"prints SQL"| node_user
node_gemini_rag -->|"reads schema"| node_schema
node_gemini_rag -->|"builds and searches"| node_vector_index
node_gemini_rag -->|"embeds chunks"| node_embeddings
node_gemini_rag -->|"invokes"| node_gemini_service
node_user -->|"asks"| node_groq_rag
node_groq_rag -->|"prints SQL"| node_user
node_groq_rag -->|"reads schema"| node_schema
node_groq_rag -->|"builds and searches"| node_vector_index
node_groq_rag -->|"embeds chunks"| node_embeddings
node_groq_rag -->|"invokes"| node_groq_service
node_user -->|"asks"| node_groq_sql
node_groq_sql -->|"prints SQL"| node_user
node_groq_sql -->|"invokes"| node_groq_service
node_groq_sql -.->|"reads schema"| node_schema
node_user -.->|"asks"| node_gemini_toolkit
node_gemini_toolkit -->|"invokes"| node_gemini_service
node_gemini_toolkit -->|"uses"| node_sql_toolkit
node_gemini_toolkit -->|"configures"| node_placeholder_db
node_gemini_toolkit -->|"reads schema"| node_schema
node_user -.->|"asks"| node_groq_toolkit
node_groq_toolkit -->|"invokes"| node_groq_service
node_groq_toolkit -->|"uses"| node_sql_toolkit
node_groq_toolkit -->|"configures"| node_placeholder_db
node_groq_toolkit -->|"reads schema"| node_schema
node_user -.->|"asks"| node_groq_chain
node_groq_chain -->|"invokes"| node_groq_service
node_user -->|"chats"| node_groq_chat
node_groq_chat -->|"invokes"| node_groq_service
node_groq_chat -->|"prints reply"| node_user
node_user -->|"chats"| node_ollama_chat
node_ollama_chat -->|"invokes"| node_ollama_service
node_ollama_chat -->|"prints reply"| node_user

click node_gemini_lightrag "https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/gemini/langgraph_gemini_lightrag_sql.py"
click node_gemini_rag "https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/gemini/langgraph_gemini_rag_sql.py"
click node_groq_rag "https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/groqapi/langgraph_groqapi_rag_sql.py"
click node_groq_sql "https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/groqapi/langgraph_groqapi_sql.py"
click node_gemini_toolkit "https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langchain/gemini/langchain_gemini_sqltoolkit.py"
click node_groq_toolkit "https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langchain/groqapi/langchain_groqapi_sqltoolkit.py"
click node_groq_chain "https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langchain/groqapi/langchain_groqapi_sql.py"
click node_groq_chat "https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/groqapi/langgraph_groqapi_chatbot.py"
click node_ollama_chat "https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/ollama/langgraph_ollama_chatbot.py"
click node_schema "https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/database_express_schema.txt"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_gemini_lightrag,node_gemini_rag,node_groq_rag,node_groq_sql,node_user toneBlue
class node_gemini_toolkit,node_groq_toolkit,node_groq_chain,node_vector_index,node_placeholder_db toneAmber
class node_groq_chat,node_ollama_chat toneMint
class node_schema toneRose
class node_groq_service,node_gemini_service,node_ollama_service,node_embeddings,node_sql_toolkit toneIndigo
```

## Components

### LangGraph SQL

- [Gemini LightRAG SQL](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/gemini/langgraph_gemini_lightrag_sql.py): `langgraph/gemini/langgraph_gemini_lightrag_sql.py`
- [Gemini RAG SQL](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/gemini/langgraph_gemini_rag_sql.py): `langgraph/gemini/langgraph_gemini_rag_sql.py`
- [Groq RAG SQL](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/groqapi/langgraph_groqapi_rag_sql.py): `langgraph/groqapi/langgraph_groqapi_rag_sql.py`
- [Groq Schema SQL](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/groqapi/langgraph_groqapi_sql.py): `langgraph/groqapi/langgraph_groqapi_sql.py`

### LangChain SQL

- [Gemini SQL Agent](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langchain/gemini/langchain_gemini_sqltoolkit.py): `langchain/gemini/langchain_gemini_sqltoolkit.py`
- [Groq SQL Agent](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langchain/groqapi/langchain_groqapi_sqltoolkit.py): `langchain/groqapi/langchain_groqapi_sqltoolkit.py`
- [Groq SQL Chain](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langchain/groqapi/langchain_groqapi_sql.py): `langchain/groqapi/langchain_groqapi_sql.py`

### Chatbots

- [Groq Chatbot](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/groqapi/langgraph_groqapi_chatbot.py): `langgraph/groqapi/langgraph_groqapi_chatbot.py`
- [Ollama Chatbot](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/langgraph/ollama/langgraph_ollama_chatbot.py): `langgraph/ollama/langgraph_ollama_chatbot.py`

### Schema Data

- [Database Schema](https://github.com/mohsin66/langchain_langgraph_rnd/blob/main/database_express_schema.txt): `database_express_schema.txt`

### Other components

- **CLI User**
- **Groq Model**
- **Gemini Model**
- **Ollama Model**
- **FAISS Index**
- **HuggingFace Embeddings**
- **SQL Toolkit**
- **SQLite Placeholder**

## Connections

- CLI User → Gemini LightRAG SQL: asks (evidence: `langgraph/gemini/langgraph_gemini_lightrag_sql.py`)
- Gemini LightRAG SQL → CLI User: prints SQL (evidence: `langgraph/gemini/langgraph_gemini_lightrag_sql.py`)
- Gemini LightRAG SQL → Database Schema: reads schema (evidence: `langgraph/gemini/langgraph_gemini_lightrag_sql.py`)
- Gemini LightRAG SQL → Gemini Model: invokes (evidence: `langgraph/gemini/langgraph_gemini_lightrag_sql.py`)
- CLI User → Gemini RAG SQL: asks (evidence: `langgraph/gemini/langgraph_gemini_rag_sql.py`)
- Gemini RAG SQL → CLI User: prints SQL (evidence: `langgraph/gemini/langgraph_gemini_rag_sql.py`)
- Gemini RAG SQL → Database Schema: reads schema (evidence: `langgraph/gemini/langgraph_gemini_rag_sql.py`)
- Gemini RAG SQL → FAISS Index: builds and searches (evidence: `langgraph/gemini/langgraph_gemini_rag_sql.py`)
- Gemini RAG SQL → HuggingFace Embeddings: embeds chunks (evidence: `langgraph/gemini/langgraph_gemini_rag_sql.py`)
- Gemini RAG SQL → Gemini Model: invokes (evidence: `langgraph/gemini/langgraph_gemini_rag_sql.py`)
- CLI User → Groq RAG SQL: asks (evidence: `langgraph/groqapi/langgraph_groqapi_rag_sql.py`)
- Groq RAG SQL → CLI User: prints SQL (evidence: `langgraph/groqapi/langgraph_groqapi_rag_sql.py`)
- Groq RAG SQL → Database Schema: reads schema (evidence: `langgraph/groqapi/langgraph_groqapi_rag_sql.py`)
- Groq RAG SQL → FAISS Index: builds and searches (evidence: `langgraph/groqapi/langgraph_groqapi_rag_sql.py`)
- Groq RAG SQL → HuggingFace Embeddings: embeds chunks (evidence: `langgraph/groqapi/langgraph_groqapi_rag_sql.py`)
- Groq RAG SQL → Groq Model: invokes (evidence: `langgraph/groqapi/langgraph_groqapi_rag_sql.py`)
- CLI User → Groq Schema SQL: asks (evidence: `langgraph/groqapi/langgraph_groqapi_sql.py`)
- Groq Schema SQL → CLI User: prints SQL (evidence: `langgraph/groqapi/langgraph_groqapi_sql.py`)
- Groq Schema SQL → Groq Model: invokes (evidence: `langgraph/groqapi/langgraph_groqapi_sql.py`)
- Groq Schema SQL → Database Schema: reads schema
- CLI User → Gemini SQL Agent: asks
- Gemini SQL Agent → Gemini Model: invokes (evidence: `langchain/gemini/langchain_gemini_sqltoolkit.py`)
- Gemini SQL Agent → SQL Toolkit: uses (evidence: `langchain/gemini/langchain_gemini_sqltoolkit.py`)
- Gemini SQL Agent → SQLite Placeholder: configures (evidence: `langchain/gemini/langchain_gemini_sqltoolkit.py`)
- Gemini SQL Agent → Database Schema: reads schema (evidence: `langchain/gemini/langchain_gemini_sqltoolkit.py`)
- CLI User → Groq SQL Agent: asks
- Groq SQL Agent → Groq Model: invokes (evidence: `langchain/groqapi/langchain_groqapi_sqltoolkit.py`)
- Groq SQL Agent → SQL Toolkit: uses (evidence: `langchain/groqapi/langchain_groqapi_sqltoolkit.py`)
- Groq SQL Agent → SQLite Placeholder: configures (evidence: `langchain/groqapi/langchain_groqapi_sqltoolkit.py`)
- Groq SQL Agent → Database Schema: reads schema (evidence: `langchain/groqapi/langchain_groqapi_sqltoolkit.py`)
- CLI User → Groq SQL Chain: asks
- Groq SQL Chain → Groq Model: invokes (evidence: `langchain/groqapi/langchain_groqapi_sql.py`)
- CLI User → Groq Chatbot: chats (evidence: `langgraph/groqapi/langgraph_groqapi_chatbot.py`)
- Groq Chatbot → Groq Model: invokes (evidence: `langgraph/groqapi/langgraph_groqapi_chatbot.py`)
- Groq Chatbot → CLI User: prints reply (evidence: `langgraph/groqapi/langgraph_groqapi_chatbot.py`)
- CLI User → Ollama Chatbot: chats (evidence: `langgraph/ollama/langgraph_ollama_chatbot.py`)
- Ollama Chatbot → Ollama Model: invokes (evidence: `langgraph/ollama/langgraph_ollama_chatbot.py`)
- Ollama Chatbot → CLI User: prints reply (evidence: `langgraph/ollama/langgraph_ollama_chatbot.py`)