AI Database Solution (AIDS)

AI Database Solution (AIDS) is an AI-driven platform designed to automate SQL database operations. The system interprets natural language inputs to generate and execute SQL queries, improving efficiency and reducing manual effort.

Current Goals

• Make UI for Useful
• Add Data Visualization
• Add Auth to manage User Roles

Features

• Natural Language Processing: Allows users to interact with the database using natural language.
• SQL Code Generation: Automatically generates SQL queries based on user input.
• Data Analysis: Analyzes data returned from SQL queries for better decision-making.
• Query Safety Assessment: Checks SQL queries for potential risks before execution.
• Command-Line and Web Interfaces: Available for interaction, providing flexibility for different environments.

Installation

1. Clone this repository:

   pip install pipenv
   git clone https://github.com/NotoriousArnav/aids.git
   cd aids

2. Install dependencies using Pipenv:

   pipenv install

3. Set up environment variables. Create a .env file in the root directory (copy or rename the '.env copy') and add the following:

   CLOUDFLARE_API_TOKEN="your_token_here"
   CLOUDFLARE_ACCOUNT_ID="your_account_id_here"
   GROQ_API_KEY="your_api_key_here"
   SQLALCHEMY_DB_URL="your_database_url_here"

   and maybe even these for Easier debugging

   LANGCHAIN_TRACING_V2="your_tracing_version_here"
   LANGCHAIN_ENDPOINT="your_endpoint_here"
   LANGCHAIN_API_KEY="your_api_key_here"
   LANGCHAIN_PROJECT="your_project_here"

Running the Application

• To run the application via GUI/Web:

  pipenv run server

• To run the application via CLI:

  pipenv run cli_agent

Project Structure

• agent_tools/: Contains the core logic for processing requests.
• langchain_groq/: Integration with the Groq AI language model.
• langgraph/: Handles the state and memory of the agent.
• server.py: The entry point for the web server.
• cli_agent.py: The entry point for the command-line interface.

Requirements

• Python 3.8 or higher
• Pipenv for dependency management

Material

License

This project is licensed under the MIT License - see the LICENSE file for details.