What are the best open source frameworks for building a custom internal chatbot that connects directly to our internal Postgres database?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
What are the best open source frameworks for building a custom internal chatbot that connects directly to our internal Postgres database?
7 real searches · 1 real-search pass
open source frameworks natural language to SQL PostgreSQL chatbot LlamaIndex LangChain Haystack Vanna AI 2026 GitHubGoogle ↗
OBSERVEDOther / navigational
Vanna AI documentation PostgreSQL text to SQL open source frameworkGoogle ↗
OBSERVEDOther / navigational
LlamaIndex SQL query engine PostgreSQL documentationGoogle ↗
OBSERVEDInstruction
LangChain SQLDatabase toolkit PostgreSQL documentationGoogle ↗
OBSERVEDOther / navigational
WrenAI official documentation PostgreSQL semantic layer text to SQL GitHub licenseGoogle ↗
OBSERVEDOther / navigational
DB-GPT official GitHub PostgreSQL database agent open source licenseGoogle ↗
OBSERVEDOther / navigational
LlamaIndex SQL query engine SQLDatabase PostgreSQL official docsGoogle ↗
OBSERVEDOther / navigational
Badge and edge weight = share of passes that produced the query. Hover a query for its intent and routing format.
Query classes
Google's semantic query class for every sub-query: what kind of answer each search is after, simulated vs real.
ChatGPT real searches (7)
Classes come from the query-classifier (a local Laya model). 7 of 7 calls are low-confidence (under 50%) — hover a query in the table to see its confidence.
Searches and sources
ChatGPT7 real searches · gpt-6
open source frameworks natural language to SQL PostgreSQL chatbot LlamaIndex LangChain Haystack Vanna AI 2026 GitHub Google ↗
Vanna AI documentation PostgreSQL text to SQL open source framework Google ↗
LlamaIndex SQL query engine PostgreSQL documentation Google ↗
LangChain SQLDatabase toolkit PostgreSQL documentation Google ↗
WrenAI official documentation PostgreSQL semantic layer text to SQL GitHub license Google ↗
DB-GPT official GitHub PostgreSQL database agent open source license Google ↗
LlamaIndex SQL query engine SQLDatabase PostgreSQL official docs Google ↗
- GitHub repository · github.com
- Documentation · docs.llamaindex.ai
- GitHub repository · github.com
- Documentation · docs.langchain.com
- GitHub repository · github.com
- Documentation · docs.getwren.ai
- GitHub repository · github.com
- Documentation · docs.haystack.deepset.ai
- GitHub - vanna-ai/vanna: 🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using Agentic Retrieval 🔄. · github.com
- Databases · vanna.ai
- GitHub repository · github.com
- Documentation · docs.dbgpt.cn
- eosphoros-ai/db-gpt v0.8.2 — A data agent that writes SQL and code in natural language · github.devotd.net
- Wren AI OSS · docs.getwren.ai
- GitHub - idcdog/wrenai: GenBI (Generative BI) for AI agents, an open-source, governed text-to-SQL through an open context layer that turns natural-language questions into trusted dashboards, charts, and SQL across 20+ data sources, such as BigQuery, Snowflake, PostgreSQL, ClickHouse, Amazon Redshift, Databricks and more. · github.com
Semantic map
Every query placed by meaning (EmbeddingGemma 2, 256-d). Shaded regions are topics, nearby points are near-paraphrases, and a circle's size is how often the query came back.
Colour
SimulatedReal search
Hover a query to see its counterpart · zoom with Ctrl/⌘ + scroll, a pinch, double-click or +
Queries
7 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
open source frameworks natural language to SQL PostgreSQL chatbot LlamaIndex LangChain Haystack Vanna AI 2026 GitHub OBSERVED | Google ↗ AI Mode ↗ | — | Other / navigational | — | — | 1x of 1 | |
Vanna AI documentation PostgreSQL text to SQL open source framework OBSERVED | Google ↗ AI Mode ↗ | — | Other / navigational | — | — | 1x of 1 | |
LlamaIndex SQL query engine PostgreSQL documentation OBSERVED | Google ↗ AI Mode ↗ | — | Instruction | — | — | 1x of 1 | |
LangChain SQLDatabase toolkit PostgreSQL documentation OBSERVED | Google ↗ AI Mode ↗ | — | Other / navigational | — | — | 1x of 1 | |
WrenAI official documentation PostgreSQL semantic layer text to SQL GitHub license OBSERVED | Google ↗ AI Mode ↗ | — | Other / navigational | — | — | 1x of 1 | |
DB-GPT official GitHub PostgreSQL database agent open source license OBSERVED | Google ↗ AI Mode ↗ | — | Other / navigational | — | — | 1x of 1 | |
LlamaIndex SQL query engine SQLDatabase PostgreSQL official docs OBSERVED | Google ↗ AI Mode ↗ | — | Other / navigational | — | — | 1x of 1 |