25 Commits (main)

Author	SHA1	Message	Date
Jon Luo	8a35811556	Don't instruct LLM to use the LIMIT clause, which is incompatible with SQL Server (#1242) ... The current prompt specifically instructs the LLM to use the `LIMIT` clause. This will cause issues with MS SQL Server, which uses `SELECT TOP` instead of `LIMIT`. The generated SQL will use `LIMIT`; the instruction to "always limit... using the LIMIT clause" seems to override the "create a syntactically correct mssql query to run" portion. Reported here: https://github.com/hwchase17/langchain/issues/1103#issuecomment-1441144224 I don't have access to a SQL Server instance to test, but removing that part of the prompt in OpenAI Playground results in the correct `SELECT TOP` syntax, whereas keeping it in results in the `LIMIT` clause, even when instructing it to generate syntactically correct mssql. It's also still correctly using `LIMIT` in my MariaDB database. I think in this case we can assume that the model will select the appropriate method based on the dialect specified. In general, it would be nice to be able to test a suite of SQL dialects for things like dialect-specific syntax and other issues we've run into in the past, but I'm not quite sure how to best approach that yet.	1 year ago
Harrison Chase	ec727bf166	Align table info (#999) (#1034) ... Currently the chain is getting the column names and types on the one side and the example rows on the other. It is easier for the llm to read the table information if the column name and examples are shown together so that it can easily understand to which columns do the examples refer to. For an instantiation of this, please refer to the changes in the `sqlite.ipynb` notebook. Also changed `eval` for `ast.literal_eval` when interpreting the results from the sample row query since it is a better practice. --------- Co-authored-by: Francisco Ingham <> --------- Co-authored-by: Francisco Ingham <fpingham@gmail.com>	1 year ago
Zach Schillaci	4c79100b15	Correct prompt typo + update example for SQLDatabaseChain (#868) ... See https://github.com/hwchase17/langchain/issues/821	1 year ago
Harrison Chase	364b771743	sql return direct (#864)	1 year ago
Zach Schillaci	b4eb043b81	Minor fix to SQLDatabaseChain doc (#826)	1 year ago
Harrison Chase	94ae126747	return sql intermediate steps (#792)	1 year ago
Francisco Ingham	213c2e33e5	Sql prompt improvement (#787) ... Co-authored-by: Francisco Ingham <>	1 year ago
Samantha Whitmore	be7de427ca	Serialize all the chains! (#761) ... Co-authored-by: Harrison Chase <hw.chase.17@gmail.com>	1 year ago
Harrison Chase	cbc146720b	verbose flag (#683)	1 year ago
Harrison Chase	6be5f4e4c4	Harrison/sql db chain (#641) ... Co-authored-by: Bruno Bornsztein <bruno.bornsztein@gmail.com>	1 year ago
Harrison Chase	3d43906572	Harrison/new api chain (#623) ... Co-authored-by: Francisco Ingham <fpingham@gmail.com> Co-authored-by: lesscomfortable <pancho_ingham@hotmail.com>	1 year ago
Harrison Chase	1c71fadfdc	more complex sql chain (#619) ... add a more complex sql chain that first subsets the necessary tables	1 year ago
Harrison Chase	9f9afbb6a8	add custom prompt for LLMMathChain and SQLDatabase chain (#605)	1 year ago
Harrison Chase	9e04c34e20	Add BaseCallbackHandler and CallbackManager (#478) ... Co-authored-by: Ankush Gola <9536492+agola11@users.noreply.github.com>	1 year ago
Harrison Chase	3474f39e21	Harrison/improve cache (#368) ... make it so everything goes through generate, which removes the need for two types of caches	1 year ago
Harrison Chase	9481a23314	stop using chained input except in agent (#249)	2 years ago
Xupeng (Tony) Tong	bb4bf9d6d0	chore: minor clean up / formatting (#233) ... to get familiarize with the project	2 years ago
Harrison Chase	c02eb199b6	add few shot example (#148)	2 years ago
Harrison Chase	9f223e6ccc	Harrison/fix lint (#138)	2 years ago
Delip Rao	76cecf8165	A fix for Jupyter environment variable issue (#135) ... - fixes the Jupyter environment variable issues mentioned in issue #134 - fixes format/lint issues in some unrelated files (from make format/lint) 	2 years ago
Harrison Chase	f23b3ceb49	consolidate run functions (#126) ... consolidating logic for when a chain is able to run with single input text, single output text open to feedback on naming, logic, usefulness	2 years ago
Samantha Whitmore	a5b61d59e1	Refactor prompts into module, add example generation utils (#64)	2 years ago
Harrison Chase	f772934108	improve logging (#66)	2 years ago
Harrison Chase	4cc18d6c2a	Harrison/pretty print (#57) ... make stuff look nice	2 years ago
Harrison Chase	af81e9ca9c	add sql database (#35)	2 years ago