Spaces:
Sleeping
Sleeping
metadata
title: Chinook SQL Agent Demo
emoji: 🦜
colorFrom: green
colorTo: blue
sdk: docker
sdk_version: 3.11
app_file: app.py
pinned: false
Chinook SQL Agent Demo
Load whatever data dictionary you want into data folder! Right know it's just a simple sqlite database sample.
In modules folder we have two modules, one for most databases and other for sqlite.
The sqlite module is a simple one, it's just a wrapper for sqlite3 python module.
The other module is a more complex one and accepts most SQL databases connections using a DB_URL env variable.
Copy env variables and fill values (if you are just going to use sqlite, you can leave it with only the api key setted)
cp .env.example .env
Create virtual environment
python3 -m venv .venv
source .venv/bin/activate
Install dependencies
pip install -r requirements.txt
Run the app
chainlit run app.py