search

defog-ai / sqlcoder

SoTA LLM for converting natural language questions to SQL queries
Apache License 2.0
3.41k stars 218 forks source link

Compatibility with RAG-based framework #96

Closed jis478 closed 3 months ago

jis478 commented 7 months ago

Hi, thanks for the excellent work. :)

I'm wondering if sqlcoder is compatible with similarity-based framework like langchain or vanna. For me, sqlcoder seems to refer to all the table information (inferred by inference.py) in the database but the above ones are basically RAG-frameworks so that they only retrieve and include relevant ones in the prompt. Does the each training example for sqlcoder only refer to specific relevant tables or to all the tables in the database?

MohamadOHijazi commented 6 months ago

You can use Ollama, and as you know Ollama is compatible with Vanna.ai However, to the best of my knowledge, Ollama doesn't contain the latest sqlcoder 8 billion based on LLM3

jis478 commented 6 months ago

@MohamadOHijazi My question was whether sql-coder is designed to work with relevant (retrieved) information, not about the compatibility with Ollama.

github-actions[bot] commented 5 months ago

This issue is stale because it has been open for 30 days with no activity.

chussboi96 commented 5 months ago

@MohamadOHijazi My question was whether sql-coder is designed to work with relevant (retrieved) information, not about the compatibility with Ollama.

im stuck in a similar situation

andyzhou1982 commented 4 months ago

specific relevant tables,you can find the information at ~/.defog/selected_tables.json

github-actions[bot] commented 3 months ago

This issue is stale because it has been open for 30 days with no activity.

github-actions[bot] commented 3 months ago

This issue was closed because it has been inactive for 14 days since being marked as stale.