The Challenge
A marketing manager wants to know which campaigns drove the most signups last quarter. The data exists in the warehouse, but the schema is unfamiliar and the table names are cryptic. The usual route is a ticket to the data team and a wait of days.
- Business users can’t tell which tables and fields hold the data they need
- Writing SQL against an unfamiliar schema leads to wrong joins and misleading numbers
- Data teams are buried in repetitive ad hoc requests that slow down decisions
The Autohive Solution
The Metabase integration gives your Autohive agent structured access to your Metabase instance, whether you use Metabase Cloud or a self-hosted deployment. The agent does the schema research first, then writes and runs the query.
Schema Discovery Before Querying
The agent lists your connected databases, pulls the relevant tables with get_database_schema, and uses get_table to check field types and foreign key relationships before it writes a single line of SQL.
Read-Only SQL Execution
Once the agent understands the data model, it drafts a query and runs it directly in Metabase. Results come back as rows you can read, summarise or pass on to the next step in your workflow.
Built-In Query Safety
Every query is parsed before it is sent. Write operations, multi-statement queries and side-effect functions are blocked, so asking a question can never change your data.
Benefits
- Answers in minutes - Skip the ticket queue and get results while the question is still fresh
- More accurate queries - Field types and foreign keys are checked first, which reduces bad joins
- Less load on the data team - Routine questions are handled without an analyst’s time
- Safe by design - Read-only enforcement protects your production data
How It Works
- Ask in plain language - Describe the business question, such as “Which campaigns drove the most signups last quarter?”
- Explore the schema - The agent lists databases, finds the relevant tables and checks fields and foreign keys
- Run the query - The agent drafts the SQL, runs it in Metabase and returns the rows with a short explanation
Learn More
See everything the Metabase integration can do on the Autohive marketplace listing.
Getting Started
- Sign up at app.autohive.com
- Connect your integration from the marketplace
- Configure your automation
- Deploy your agents


