Leverage OpenAI models to generate queries and visualizations for the Base blockchain using text.
Key Features:
- Query Generation: Uses OpenAI's GPT-3.5 to write SQL queries for analyzing Base blockchain data, sourced from Flipside Crypto. The core technology behind this tool is a fine-tuned OpenAI GPT-3.5 model create using Base queries from @adriaparcerisas, @AliTslm, @jackthepine, @der_piper, and @Biseda_binam on Flipside.
- Chart Creation: Transforms query results into insightful charts. The prompts are sent to OpenAI with some prompt engineering to generate code for plotly charts then rendered in the app.
Notes:
- Experimental Nature: This project tests the feasibility of creating a text-to-SQL model using open-sourced queries. Hence, the queries are not perfect.
- Rapid Development: The tool was developed in about 4 hours.
- Future Prospects: Ideally, the tool will combine query generation and visualization steps, which is definitely achievable.
See the code on GitHub.