Database Talk with PandasAI

Introduction

Database Talk is an innovative project integrating PandasAI with SQL databases to facilitate database interactions via conversational AI. This project allows users to execute SQL queries through natural language prompts, enhancing accessibility and efficiency in database management.

Features

• Natural language processing for SQL query execution.
• Support for multiple database schemas.
• User-friendly for non-technical users.

Getting Started

Follow these instructions to set up and run a Database-Talk project on your local machine.

Prerequisites

• Python 3.8 or newer
• SQLite database setup
• PandasAI library
• PandasAI API key (obtain yours at PandasAI API Keys)

Installation

To set up the Database Talk environment, follow these steps:

1. Clone the repository:

   git clone https://github.com/kushalpatel0265/Database-Talk.git
   

2. Install the required Python libraries:

   pip install pandasai
   

Usage

1. Start the project by running the main script:

   python main.py
   

2. Upload your database file and integrate in the code.
3. Integrate API key of Pandas AI.

Example Commands

• "Show all records from the customer table."
• "List all invoices for a specific customer."
• "Give the artist name who create highest number of albums"

Contributing

Contributions to this project are welcome! Please fork the repository and submit a pull request with your features or corrections.

License

Distributed under the MIT License. See LICENSE for more information.

Contact

• Gmail: kushalpatel0265@gmail.com
• Project Link: https://github.com/kushalpatel0265/Database-Talk