Metabase
Connect Metabase to ajan to query databases and access dashboards from your conversations
Overview
Metabase is an open-source business intelligence platform for querying databases and creating dashboards. Once connected, you can use ajan to run SQL queries, execute saved questions, browse dashboards, and search across your Metabase content directly from your conversations.
Prerequisites
- A running Metabase instance (cloud or self-hosted)
- Admin access to generate an API key
Setup
Generate an API key in Metabase
Follow Metabase's API key guide to create a key. API keys require Metabase v1.47 or later.
Get your Metabase instance URL
Your instance URL is the address you use to access Metabase, e.g. https://your-company.metabaseapp.com or https://metabase.your-domain.com.
Navigate to Integrations in ajan
Go to Integrations and find Metabase in the list.
Enter your credentials
Enter your instance URL and API key, then save.
Start using Metabase in ajan
Tag the integration with @ in any agent to start querying your data.
Common Use Cases
- SQL Queries — Run native SQL queries against any connected database in your Metabase instance
- Saved Questions — Execute saved questions and retrieve results in JSON or CSV format
- Dashboard Access — Browse and retrieve dashboards and their underlying question cards
- Content Search — Search across dashboards, questions, tables, and collections in one place
Troubleshooting
| Issue | Solution |
|---|---|
| Authentication failed | Verify the API key is correct and the instance URL has no trailing slash |
| Instance not reachable | Ensure your Metabase instance is publicly accessible or on the same network |
| Permission denied | Check that the API key's group has access to the databases or collections you're querying |
| API key not available | API keys require Metabase v1.47+. Check your version in Admin → Troubleshooting → Version |