PyQueryHub
BI That Builds Itself While You Focus on Insights.·pyqueryhub.com
PyQueryHub is a web-based AI analytics platform where AI agents interpret plain-English questions to write SQL queries, build charts and pivot tables, run Python notebook analysis, and assemble complete dashboards and reports. It connects to databases such as MySQL, PostgreSQL, BigQuery and Google Sheets, and supports scheduled automated monitoring with threshold alerts plus an embedding API for sharing live dashboards in other applications.
What it's for
Features 16
- Agent-built dashboards and reports
- AI agents that write SQL queries from plain-English prompts
- Automated report scheduling with cron-like automation
- Automatic chart and table generation
- Calculated fields and custom functions
- Context-aware Python notebooks using query results
- Drag-and-drop dashboard and report assembly
- Drill-down capability on charts
- Dynamic query parameters defined via YAML with Liquid templating
- Pivot tables and data grids
- Secure token-based embedding API for live dashboards
- SSH tunneling and SSL encryption for database connections
- Team collaboration with role-based access and collections
- Threshold alerts with notifications via email, Slack, or custom webhooks
- White-label report/dashboard embedding
- Workspace management with SSO integration and domain verification
At a glance
Integrations
Resources
Pricing
Free plan is $0/month with no credit card required. Team plan is $5.00/user/month billed yearly, minimum 5 users. Enterprise plan pricing is custom/quote-based.
Perfect for solo analysts and small projects.
1 User, single connection, 500 requests - 0.5GB/month
Billed yearly, minimum 5 users.
Minimum 5 users, 1M requests - 10GB/month
Custom Pricing; full platform access for large-scale operations.
Unlimited connections, requests & transfer