Skip to content

This repository aims to query an SQL database, containing Real State information, using natural language in order to obtain the results. This will be done using LLM to create the queries and pass them to the database

Notifications You must be signed in to change notification settings

JinsuaFeito-dev/REAL_STATE_QA

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

REAL_STATE_QA - Real State Question&Answer

Table of Contents
  1. About the Project
  2. Getting Started
  3. Contributing
  4. Acknowledgements

About the Library


This repository aims to query an SQL database, containing Real State information, using natural language in order to obtain the results. This will be done using LLM to create the queries and pass them to the database

Getting Started


In order to be able to run the application, you will need to download llama model and save it into models/model. For example, for a 8gb VRAM gpu, you can download llama3 model from here. After you have download the model, configured the config files at config, the model config file at models/cfg and the model prompt template at templates/ you can launch the app using the script launch_app.py

Installation


In order to make use of the library, one should just follow the next steps:

  1. Clone the project and install it using:
   git clone <repo-url>
  1. Install the repository:
  pip install -e .
  1. For using llama-cpp-python library using GPU follow the instructions at llama-cpp-python

  2. Rename the config template for the SQL database at config from mysql-template.yaml to mysql.yaml and configure your database.

  3. The llm model is configured using the file at models/cfg.

  4. Web APP Login users can be set in the file located at config/login.yaml

Back to top

Coding


When coding, just try to follow the PEP8 style and PEP257 numpy/sphinx notation for docstrings. Any code optimisations are greatly appreciated.

Back to top

Tests


Back to top

Contributing


Any contributions are greatly appreciated. If you have suggestions that would make the project any better, don't hesitate to contribute. Here is a reminder of the steps:

  1. Clone the repository:
  git clone <repo-url>
  1. Create your branch:
  git checkout -b branchname
  1. Implement and test your features.
  2. Add changes:
  git add <files-to-add>
  1. Commit your changes:
  git commit -m "<feature-description>"
  1. Push to the branch:
  git push origin branchname
  1. Request a merge when you are ready.

Back to top

Acknowledgements


Enjoy the content! 😄

Back to top

About

This repository aims to query an SQL database, containing Real State information, using natural language in order to obtain the results. This will be done using LLM to create the queries and pass them to the database

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages