About This Project

This project is designed to help users generate and analyze SQL queries using AI-driven tools. The system integrates Google Cloud's BigQuery for efficient data retrieval and leverages Google Gemini to generate SQL queries and perform data analysis.

Project Overview: SQL Query Generation and Data Analysis

Features

SQL Query Generation:

Users can input questions related to data, and Gemini will generate the appropriate SQL queries to fetch relevant information from Google Cloud's BigQuery.

Data Display:

The results of the SQL queries are displayed in a dynamic table format, enabling users to easily explore and interact with the retrieved data.

Post Selection and Analysis:

After retrieving the data, users can select specific posts or data points by providing the post ID. The project will fetch additional content from the associated URLs and generate an in-depth analysis using AI.

AI-Powered Insights:

By leveraging Gemini's capabilities, the system not only generates SQL queries but also provides insights and analysis on the data, enabling deeper understanding and informed decision-making.

Workflow

  1. User inputs a query, and Gemini generates the corresponding SQL query.
  2. Data from BigQuery is fetched and displayed in a table.
  3. User selects a post by ID, and the data from the post's URL is analyzed using Gemini.

This project combines advanced AI technology with cloud-based data processing, providing a seamless tool for both generating SQL queries and analyzing the data. The overall goal is to simplify data querying and analysis for users, making complex tasks more accessible and efficient.

Project information

How to Use

Steps of how to Use This APP

Here, I have mentioned steps of how to use this app. and below this I've put some screenshots of example.

Step 1.   Query Input

Upon landing on the project, you will see an interface with options to interact with the Hacker News dataset. Locate the query input field. This is where you can type natural language queries related to the Hacker News dataset.

Step 2.   Get Data

Type your query into the input field. The system uses the Gemini API to interpret your natural language query and convert it into SQL. The system executes the SQL query against the Google Cloud BigQuery database containing the Hacker News dataset. Results from the query are retrieved and displayed on the interface. These results typically include relevant posts, comments, or other data based on your query.

Step 3.   Analyze data based on post id

Depending on the query and data retrieved, you can interact further. For example, viewing specific details of a post or exporting data. if that post has url and post id available.