SQL Query Chatbot
This chat application is built with Svelte on the frontend and Flask as the API backend.
It utilizes Ollama and Llama3 for AI responses. This is an initial prototype. A Retrieval-Augmented Generation (RAG) backend with data retrieved from social media, documents, and other sources is being created (In Construction). Additionally, a SQL AI agent is being developed that can query databases and return analytics based on SQL Question and Answer AI Chaining.
Summary of the Chinook Database
The Chinook database is a sample database representing a digital media store. It includes tables for artists, albums, media tracks, invoices, and customers, among others. This makes it an excellent resource for practicing SQL queries and learning database management. The schema includes relationships between these tables, such as artists to albums and invoices to customers.
For more detailed information...