leftonread icon indicating copy to clipboard operation
leftonread copied to clipboard

A primitive NL to SQL chat feature

Open Davidorenlane opened this issue 1 year ago • 2 comments

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

image

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)

Davidorenlane avatar Mar 11 '24 23:03 Davidorenlane

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

vercel[bot] avatar Mar 11 '24 23:03 vercel[bot]

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

Davidorenlane avatar Mar 11 '24 23:03 Davidorenlane