plasticlist.org with Spice

This repository contains a Spice application for plasticlist.org, enabling super-fast SQL queries, vector searches, and LLM-based chat interactions over the dataset.

Prerequisites

1. Install the Spice CLI if you haven't already. Refer to the Getting Started guide.
2. A valid OpenAI API Key.

Getting Started

1. Clone this repository and navigate to the project directory:

2. Set up your .env.local file:

3. Run Spice. Ensure the working directory is plasticlist:

   This will set up the datasets and the configured LLM model for queries and searches.

How to Use

SQL Query with spice sql

Use the spice sql command to run SQL queries against the datasets. For example, to query the samples dataset:

This retrieves up to 10 records where the category is "plastic."

Search with spice search

Perform vector-based searches using the spice search command. Example:

This finds results related to ocean pollution prevention from the dataset.

LLM Chat with spice chat

Engage with the dataset through an LLM using the spice chat command. Example:

The LLM will generate a response based on the dataset and the GPT model configured in the spicepod.yml file.

Additional Notes

• Modify the spicepod.yml file to add new datasets or models.
• For detailed documentation on each command, refer to the Spice CLI documentation.

License

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