It takes all of 2 minutes to install MinusX, log in and ask your first question on Metabase. And it just works (!) - without you mentioning anything about your databases, table schemas or analysis. This is because in the background, MinusX tries to build the best possible context to answer your question. This context is used to inform the LLM of the structure and typical usage of your data.
Basic Mode LLM Context
Here are all the pieces of information sent to the LLM with requests
Current Database
Database SQL dialect
Relevant tables (see how to control this)
SQL query on the page (if there is any)
Top rows of the output (if a query was already run)
Error message (if there is any)
Metabase visualization and variable settings (if relevant)
The model also has access to the following information on demand (it needs to ask for it as a function call)
Table schema of particular tables
Previous SQL queries based on search query
Pro Tip: You can always ask MinusX what it can see!
Control Relevant Tables
You can select the tables MinusX can see, from the Context
tab (accessible via the Tables
quick action button. Read more here.
Top Basic Mode Use Cases
The Basic Mode
is really a best-effort mode to get started without much explicit setup. In Basic Mode
, here are a few use cases MinusX is incredibly good at.
Answering fact/dimension questions
Understanding tables schemas
Fixing any errors in queries
Using saved queries