Smart Query integrates a database and a LLM, and provides a set of APIs to interact with them.

Must be run inside ./server directory. On Python 3.9.16 or higher.

source ./activate.sh

Activate would setup & activate a Python venv, install requirements and set PYTHONPATH environment variable.

venv must be active before running the server.

uvicorn --app-dir ./src app:app --reload

Server would start running on http://127.0.0.1:8000.

deactivate

pip freeze > requirements.txt

Must be run after adding a new pip dependency.

After activating the server, run the following to test Hive connection. It would quickly check if all the activation steps went fine.

cd sample_dbs/model_store/test/
python test_hive_connection.py

Install Python 3.9.16 - https://computingforgeeks.com/install-latest-python-on-centos-linux/

alias python=/usr/local/bin/python3.9
alias pip=/usr/local/bin/pip3.9
yum install cyrus-sasl-devel

Must be run inside ./ui directory.

npm start

UI would be started in dev mode on port 3000, and you can now view it in the browser at http://localhost:3000.

Smart Query comes with a set of sample databases that includes both schema and data for various dialects to try out the features.

1. Model Store - Hive, MySQL