Just want to showcase a mini project that I made. I hope to get some good feedback and find more use-cases.
In this case I am using a sample open Speckle project that i found in the forum.
I connected the Speckle model with an SQL database and then used an SQLAgent to retrieve the data. In order for the Agent to perform better and be more accurate, users need to provide small descriptions for each parameter. While this step is optional, it is highly recommended for bespoke/codified parameters. Following this, the user and other team members can access the project and ask plain English questions about the model data. As a final step, users can utilize a series of agent tools. For example, I built an agent tool that creates a bar chart. I am planning to build more of these tools to perform additional actions.
The high-level idea is to make data accessible to all the stakeholders. Anyone, whether technical or non-technical, can simply ask plain English questions to retrieve the data and then use automated tools (agents) to analyze and perform tasks.
I used Supabase because I made use of SQLAgent. To use an SQLAgent you need to query a SQL database, plus you can pretrain with Q/A the model to specific questions. I picked Supabase because it has a very easy to use API, but you can use the same logic with any PostgreSQL database.
If you make use of the Speckle API you can easily fetch the JSON object and the flatten or store parts of the data in Supabase or Firebase. It really depents of your use case.
And that’s where us non-programmers come up short… Is a Speckle-Supabase connector on the drawing board for you guys at all so that folks like us could access it?
Also, I was wondering does Speckle extract the ‘whole’ Revit model DB as a JSON object?