Ask Produl

Ask questions about your analytics data in plain English. Produl translates them to safe, read-only SQL and suggests the best chart type.

Business+

How it works

Open the Ask Produl panel from the overview dashboard(to query across all your sites at once) or from any individual site dashboard (to query that site's data). Type a question in plain English. Produl AI generates a safe SQL query, an explanation in plain language, and a chart suggestion (line | bar | pie | number | table). The query is executed and the results are rendered in the suggested chart type.

When used from the overview, queries run across all of your sites automatically — no need to switch between them to get a combined view. Typical questions take under two seconds end-to-end. The generated SQL and explanation are always shown so you can verify exactly what data was queried.

Example question & response

// Question
"Which pages had the highest bounce rate last week?"

// Response
{
  "sql": "SELECT path, COUNT(*) FILTER (WHERE is_bounce) * 100.0 / COUNT(*) AS bounce_rate, COUNT(*) AS sessions FROM pageviews WHERE site_id = $1 AND created_at >= now() - interval '7 days' GROUP BY path ORDER BY bounce_rate DESC LIMIT 10",
  "explanation": "Pages ranked by bounce rate over the last 7 days, showing the percentage of sessions that viewed only that page.",
  "chart": "table",
  "data": [
    { "path": "/blog/old-post", "bounce_rate": 82.4, "sessions": 310 },
    { "path": "/404", "bounce_rate": 79.1, "sessions": 87 }
  ]
}

Safety & limits

Ask Produl is strictly read-only. Produl enforces this at multiple levels:

• SELECT only — the generated SQL is validated to contain only SELECT statements. Semicolons are stripped and any mutation keyword (INSERT, UPDATE, DELETE, DROP, etc.) causes the request to be rejected before execution.
• Scoped to your data — in site mode, the site ID is injected as a bound parameter. In overview mode, only your own site IDs are passed — the query cannot access data belonging to other users.
• No raw PII — IP addresses, user agents, and other identifiers are never returned in results.