An application to chat with your database.
- Ask question in natural language and the underlying LLM model can answer anything from your database.
- It can write SQL query, connect to your database and run the query for you.
- Display visualizations/plots
- Langchain - LLM framework
- OpenAI - LLM model
- Streamlit - web app
- Postgres - database
Note: This app is tested in OpenAI+postgres, but can be adapted to other model/db with minimal changes.
Install poetry and dependencies:
pipx install poetry && poetry install
Populate .env
file with credentials and run the app:
streamlit run src/chat_sql/app.py
If you have any issue fixes or improvement changes. Fork this repo, make changes and submit pull request.