LangChain SQL Agent

This project is a system that connects to a PostgreSQL database and runs AI-powered SQL queries. It uses LangChain and FAISS to convert database content into vector format and generate SQL queries based on natural language questions. This makes data retrieval from the database faster and more accurate. The project also features a user-friendly interface with Streamlit.

Environment Variables

OPENAI_API_KEY=

LANGCHAIN_API_KEY=

DB_USER=

DB_PASSWORD=

DB_HOST=

DB_PORT=

DB_NAME=

Run Locally

Clone the project

 git clone https://github.com/aysenurcftc/LangChainSQLAgent.git

Go to the project directory

  cd LangChainSQLAgent

Install dependencies

    pipenv install

Start the project

   streamlit run python main.py