Aita

AI Powered Data Agent, a comprehensive solution for data analysis, engineering, and visualization.

Tech Stack

Our platform leverages a combination of cutting-edge technologies and frameworks:

• Langchain: Facilitates the seamless integration of language models into application workflows, significantly enhancing AI interaction capabilities.
• Reflex: An open-source framework for quickly building beautiful, interactive web applications in pure Python
• Apache Arrow: A cross-language development platform for in-memory data that specifies a standardized language-independent columnar memory format for flat and hierarchical data, organized for efficient analytic operations on modern hardware like CPUs and GPUs.
• Jupyter Ai Magics: A JupyterLab extension that provides a set of magics for working with AI models.

Installation

Simply install the package using pip:

pip install aita

Or with extra dependencies:

pip install aita[snowflake]

Example

Below is an example of using SqlAgent to connect to a PostgreSQL database and ask a question. You can read more details in the documentation.

from aita.agent.sql import SqlAgent
from aita.datasource.postgresql import PostgreSqlDataSource

# Connect to a PostgreSQL database
datasource = PostgreSqlDataSource("postgresql://user:password@localhost:5432/dbname")

# Create a SQL agent
sql_agent = SqlAgent("gpt-3.5-turbo").add_datasource(datasource)

# ask question to the agent
sql_agent.stream("What is the total number of orders?")

Supported Models

Model provider are supported by jupyter ai magics. Ensure the corresponding environment variables are set before using the Aita agent.

Supported Data Sources

• Snowflake
• Sqlite
• BigQuery
• Postgres
• MySQL
• Redshift
• DynamoDB
• File (CSV, Excel, Parquet, etc.)

Supported Engines

• Apache Spark
• Apache Flink
• Presto
• Ray.io: A distributed computing framework that efficiently scales AI tasks and data processing across clusters, improving performance and resource utilization.

🛡 License

This project is licensed under the terms of the Apache Software License 2.0 license. See LICENSE for more details.