The GSC Warehouse lets you craft your own DuckDb SQL queries and save them to a client-specific library or as a template for use with other client databases. Using an API key of your own, you can use AI to help craft the queries.
AI Query Generator
The left-side panel can be used to connect to an AI, using your own API key (click the ‘+’ to add an account). Select the model you want to use. Then use the chat interface to ask for/refine the report you want.
When a SQL query is returned, it appear in the center with the results of the query below.
Each row with ‘[SQL]’ contains an SQL statement that the AI returned, and you can go back to a previous version by selecting the entry.
Query Editor
The center of the page contains a query editor with the current query. You can edit the query text and click the Run button to re-run it. Copy and download buttons are provided for the table.
You can also change the client database to use — if the query does not contain not client-specific parameters. This lets you test how the query would work as a template for multiple clients.
Query Library
Like the report library on the Explore page, you can save queries for a specific client or as a template for any client.