A primitive NL to SQL chat feature

Davidorenlane commented 6 months ago

Here's a feature that allows you to query the in memory DB (core_main_table) by asking questions in plain English.

There are still lots of bugs, but basic queries work OK! (for example "How many messages have I sent to Alex Danilowicz?").

Notes:

Currently does not account for messages in group chat vs. not in a group chat, so numbers are misleading.
Be sure to use the exact spelling of your contacts' name as it appears in the address book.
Requires an OpenAI API Key and internet access
Errors (including but not limited to internet connectivity, malformed SQL queries generated by LLM, etc.) are not all handled gracefully (some are OK, like invalid API key)

vercel[bot] commented 6 months ago

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
leftonread-web	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Mar 12, 2024 4:58am

Davidorenlane commented 6 months ago

Also, this is of course not production ready! Just fun to play around with!

Left-on-Read / leftonread