semvec/pypi-packages huggingface dataset:
naxa-autoviz-ai 0.2.0
A package for automated database schema analysis, query generation, and chart visualization using LLMs.
Requires Python: <4.0,>=3.9

# AutoViz AI

AutoViz AI is a Python package that automates the process of understanding a database, generating insightful analytical queries, and creating data visualizations. It leverages Large Language Models (LLMs) via AWS Bedrock to streamline data analysis workflows.

## Features

- **Schema Extraction**: Automatically inspects a PostgreSQL/PostGIS database and extracts its schema.
- **Query Generation**: Uses an LLM to generate meaningful analytical SQL queries based on the extracted schema.
- **Chart Generation**: Executes the generated queries and creates interactive HTML charts for visualization.
- **Caching**: Caches schema, queries, and charts to speed up repeated operations and reduce costs.
- **Configurable**: Easily configure database and AWS credentials via a `.env` file.

## Installation

This package is managed with Poetry.

1.  **Clone the repository:**
    ```bash
    git clone https://github.com/your-username/autoviz_ai.git
    cd autoviz_ai
    ```

2.  **Install dependencies using Poetry:**
    ```bash
    poetry install
    ```

## Configuration

The package requires a `.env` file for configuration. Create a file named `.env` in the root of your project:

```env
# Database settings
DB_USER=your_postgres_user
DB_PASSWORD=your_postgres_password
DB_HOST=localhost
DB_NAME=your_database
DB_PORT=5432

# AWS settings
AWS_ACCESS_KEY_ID=your_aws_access_key
AWS_SECRET_ACCESS_KEY=your_aws_secret_key
AWS_DEFAULT_REGION=us-east-1