Expand prompts.py to work with SQL schema input

biocypher / biochatter

Backend library for conversational AI in biomedicine

http://biochatter.org/

MIT License

64 stars 22 forks source link

Expand prompts.py to work with SQL schema input #75

Open emmaver opened 10 months ago

emmaver commented 10 months ago

Allow to create a prompt engine from a relational database schema definition file, so that SQL queries can be generated with accurate information about the database that one wants to query

emmaver commented 10 months ago

What needs to be worked on before this can be merged:

[ ] fine tune system messages informing the LLM about the database
- improve relationship extraction from the schema definition: make use of foreign keys (?)
- implement trying to match the column names of tables that need to be joined to hint that to the LLM
- ...
[ ] create some tests