Odoo is excellent at storing your business data. Getting it out — into a dashboard, an automation or an agent — has always been the awkward part. We released a module that removes that friction: BI Query API.
Write a SQL query once inside Odoo, get a token-secured URL back, and call it from anything that speaks HTTP and JSON. No Python, no controller, no middleware, and no Odoo session to manage.
The headline: dynamic query parameters
Instead of one query per report variation, you declare parameters — a date range, a customer, a list of IDs — reference them in your SQL as %(name)s, and let the calling tool send the values with each request. One query, endless reports.
SQL-injection-safe by design
Parameter values are never concatenated into your SQL: they are type-checked and passed to PostgreSQL separately, so a value can never alter the query itself. Text, integer, decimal, boolean, date, datetime and lists are supported, with required flags and default values — and a wrong type returns a clear HTTP 400 naming the parameter instead of a confusing database error.
Built for the tools you already run
- n8n and automation — one HTTP Request node pulls live Odoo data into your workflow; Make, Zapier and any webhook-based tool work the same way.
- AI agents and LLMs — give ChatGPT, Claude or an n8n AI agent a safe, read-focused tool where your SQL decides what the agent may see.
- BI dashboards — Power BI, Metabase, Grafana, Looker Studio and Apache Superset consume the JSON output directly.
- Sheets, scripts and ETL — Google Sheets, Excel Power Query, Python or curl.
Every stored query carries its own cryptographically secure Bearer token.