PyQueryHub agents read your schema, write the SQL and Python, build the charts and assemble shareable dashboards. You review, tweak and ship. Free to start, no credit card.
SELECT c.region, SUM(o.amount) AS revenue FROM orders o JOIN customers c ON c.id = o.customer_id WHERE o.created_at >= '2026-07-01' GROUP BY c.region ORDER BY revenue DESC;
Connects to the data you already have
How it works
Plug in PostgreSQL, MySQL, BigQuery, Redshift, Azure SQL, Google Sheets or a CSV/Excel file. Credentials are encrypted at rest.
Describe what you need in plain language. Agents explore the schema, write the queries and pick the right charts.
Fine-tune with drag and drop, then share, schedule, alert or embed the live report anywhere.
AI agents
Not a chatbot bolted on top. Each agent works directly inside the editor, sees your real results and leaves you with code you can read and edit.
Turns questions into correct, schema-aware SQL with the right joins and filters, runs it, and fixes its own errors.
SELECT c.name, SUM(o.amount) AS ltv, COUNT(*) AS orders FROM customers c JOIN orders o ON o.customer_id = c.id WHERE o.created_at >= DATE_TRUNC('year', NOW()) GROUP BY c.name ORDER BY ltv DESC LIMIT 5;
Picks the right visualization for the data and configures axes, aggregations, pivots and colors for you.
Writes Python with your query results already loaded as DataFrames, for statistics, forecasting and custom plots.
import pandas as pd from statsmodels.tsa.holtwinters import ExponentialSmoothing df = datasets["monthly_orders"] model = ExponentialSmoothing(df.orders, trend="add").fit() forecast = model.forecast(3) # next quarter plot(df.orders, forecast)
Plans and builds a complete report end to end: queries, charts, notebook cells and layout, from a single prompt.
Arranges KPIs and charts into a clean, responsive layout ready to share with your team or customers.
Every chart shows the query behind it. Check anything, change anything.
Everything in one place
Stop copying CSVs between a SQL client, a notebook and a dashboard tool. PyQueryHub does all three, with AI in every step.
Query in SQL, continue in Python with the results already loaded. One report, one source of truth.
Mask sensitive columns at the connection level so neither people nor AI see raw personal data.
Run reports on a schedule and get notified on Slack, email or webhooks when a metric crosses a threshold.

Token-based API to embed live, interactive reports in your product or internal tools.
<!-- live, token-scoped report --> <iframe src="https://pyqueryhub.com/api/reports/1042/view/{token}" width="100%" height="640"></iframe>
Workspaces, collections and role-based access keep the right reports in the right hands.
Every run and every edit is saved. Compare versions and roll back in a click.
Slice millions of rows with interactive pivots, filters and drill-down on any chart.
Why PyQueryHub
|
|
Traditional BI | Notebook tools | AI chat tools | |
|---|---|---|---|---|
| AI agents build full reports end to end | ||||
| Connects live to your database | ||||
| SQL and Python in the same report | ||||
| Dashboards, schedules and alerts | ||||
| Embedding API | ||||
| Generous free plan, no credit card | ||||
| Productive on day one, no training |
Security
Queries run against your database on demand. We store only what is needed to render your reports.
Connection secrets are encrypted at rest and never shown back in the UI.
Reach private databases securely without opening them to the internet.
Hide or obfuscate PII columns for every user and every agent.
Granular permissions per workspace, collection and report.
See it in action
Pricing
Get powerful AI agents and full analytics on a genuinely generous free plan, including a generous AI allowance. No credit card, no trial clock. Upgrade only when your team grows.
Perfect for solo analysts and small projects.
Ideal for small teams and collaborative analytics.
Billed yearly, min 5 users
Full platform access for large-scale operations.
FAQ
Yes. The Free plan has no time limit and no credit card. It includes unlimited database connections, AI agents with a monthly allowance, Python notebooks and reports. Upgrade only when your team grows.
PostgreSQL, MySQL, Google BigQuery, Amazon Redshift, Azure SQL, Google Sheets, and CSV or Excel uploads. Private databases can be reached through SSH tunnels.
No. Agents write the SQL and Python for you. If you do know them, every query and notebook cell stays fully editable, so you are never locked into what the AI produced.
No. Your data is only used to answer your requests. You can also mask sensitive columns so they never reach the AI at all.
PyQueryHub agents connect live to your database, run and verify the queries, and produce real dashboards you can schedule, share, alert on and embed. Not a one-off answer in a chat window.
Yes. Generate a report token and embed the live report in your product or internal tools with a single iframe.
Connect a database and let the agents build your first dashboard in minutes.