Bilbo

What is Bilbo?

Bilbo is an AI-powered assistant designed specifically for Metabase, enabling users to interact with their data using natural language. Instead of writing complex SQL queries or navigating intricate dashboards, you can simply ask questions in plain English and receive instant, accurate answers. Bilbo understands the context of your data model, including tables, fields, and relationships, allowing it to generate precise queries that respect your business logic.

Key features include natural language querying, where you can ask questions like "What were our top-selling products last month?" or "Show me the average revenue per customer by region." Bilbo translates these into Metabase queries, executes them, and presents the results as charts, tables, or summaries. It also supports follow-up questions, enabling iterative exploration without starting from scratch.

Benefits include significant time savings for analysts and business users who may not be proficient in SQL. It democratizes data access, allowing non-technical team members to get insights independently. For power users, Bilbo can accelerate ad-hoc analysis and reduce the burden of repetitive queries.

Use cases range from sales and marketing analytics to operations and finance. For example, a marketing manager can ask "How did our campaign perform in Q3?" and get a breakdown of metrics. A product manager can inquire "Which features have the highest usage?" to prioritize development. Bilbo also handles complex aggregations, filters, and joins, making it suitable for detailed analysis.

Technical details: Bilbo integrates seamlessly with Metabase via a plugin or API. It leverages large language models (LLMs) to interpret natural language, combined with a schema-aware module that maps user questions to the correct database fields. It supports multiple databases supported by Metabase, including PostgreSQL, MySQL, BigQuery, and Snowflake. The assistant maintains session context for conversational queries and can handle ambiguous terms by asking clarifying questions. Security is ensured through Metabase's existing permissions; Bilbo only accesses data the user is authorized to view. Pricing is subscription-based, with tiers based on query volume and number of users. Bilbo is ideal for teams looking to enhance their Metabase experience with AI-driven data exploration.

Use Cases