SQL Query Chatbot
This is a simple chat using Svelte on the front end and Flask as an API AI agent on the backend. It utilizes Ollama and Llama3 for AI responses. This is an initial prototype. A Retrieval-Augmented Generation (RAG) backend with data retrieved from my 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, please refer to the SQLite Tutorial.
