metabase-query

name	metabase_query
description	Query Metabase for IAE employment data (project)

Metabase Query Skill

Query the Metabase instances for IAE (Insertion par l'Activite Economique) employment data.

Documentation

Before querying, read the relevant documentation:

• knowledge/metabase/ - Tables, schemas, data dictionary
• knowledge/stats/dashboards/ - Dashboard cards with IDs and SQL
• knowledge/stats/cards/ - Cards grouped by topic

Usage

All queries are automatically logged. Use lib.query:

from lib.query import execute_metabase_query, CallerType

# Execute a SQL query
result = execute_metabase_query(
    instance='stats',        # or 'datalake', 'dora'
    caller=CallerType.AGENT,
    sql="SELECT COUNT(*) FROM candidatures WHERE etat = 'Candidature acceptee'",
    database_id=2,
)

if result.success:
    print(result.data)  # {"columns": [...], "rows": [...], "row_count": N}
else:
    print(f"Error: {result.error}")

# Execute a saved card/question
result = execute_metabase_query(
    instance='stats',
    caller=CallerType.AGENT,
    card_id=7073,
)

Advanced: Direct API access

For more control (searching cards, getting metadata), use get_metabase():

from lib.query import get_metabase

api = get_metabase(instance='stats')

# Execute SQL
result = api.execute_sql("SELECT 1")
print(result.to_markdown())

# Execute a saved card
result = api.execute_card(7073)
print(result.to_dicts())

# Get card SQL to understand/modify it
sql = api.get_card_sql(7073)

# Search for cards
cards = api.search_cards("candidatures")
for card in cards:
    print(f"{card['id']}: {card['name']}")

Card metadata is also documented in:

• knowledge/stats/dashboards/ - Dashboard cards with IDs and SQL
• knowledge/stats/cards/ - Cards grouped by topic

Available Methods

Core query methods:

• execute_sql(sql) - Run raw SQL query
• execute_card(card_id) - Run a saved question

Discovery methods:

• get_card(card_id) - Get card metadata
• get_card_sql(card_id) - Get SQL for any card (native or compiled)
• search_cards(query) - Search cards by name/description
• list_cards(collection_id) - List cards in a collection
• list_models() - List all model-type cards (datasets)
• get_dashboard(dashboard_id) - Get dashboard metadata
• list_dashboards(collection_id) - List dashboards in a collection

Instances

Instance	URL	Database ID	Purpose
stats	stats.inclusion.beta.gouv.fr	2	IAE employment statistics
datalake	datalake.inclusion.beta.gouv.fr	2	Cross-product analytics
dora	metabase.dora.inclusion.gouv.fr	2	Dora services directory (structures, services, orientations)
data_inclusion	metabase.data.inclusion.gouv.fr	—	Modèles Metabase uniquement via list_metabase_models(instance="data_inclusion", ...)