DataQuery.inAI
Hosted on dataquery.in · Powered by DuckDB & Pyodide

The All-in-One Hosted
Data Build & Analytics Playground

Bring a file or an app feed, transform it in Python, DuckDB SQL, or DAX, press Automate, and get live visual dashboards plus an AI-written executive report.

dataquery.in/playground — sales_q3.csv (DuckDB-WASM 0.10)
DuckDB Online
// SQL Columnar Query
SELECT 
  region,
  SUM(revenue) AS total_rev,
  ROUND(SUM(profit)/SUM(revenue)*100, 1) AS margin_pct
FROM sales
GROUP BY 1
ORDER BY total_rev DESC;
Ctrl+Enter to RunCtrl+Shift+Enter Automate
Output Matrix (4 rows)
North America: $66,200 (56.5%)
Europe: $59,500 (61.7%)
Asia Pacific: $59,400 (61.8%)
Latin America: $7,700 (42.9%)
Compiled in 18.4ms · Zero Server Latency

Instant Ingestion from 20+ Data Sources & Formats

CSV & Excel Google Drive MySQL & PostgreSQL MongoDB Atlas Shopify Store Webhook REST API

Three Analytical Engines. One Playground.

Switch effortlessly between code and formula semantics. Each environment supports both full Manual control and one-click Automate pipelines.

Python (Pandas & NumPy)

Full-featured in-browser Pyodide runtime. Execute dataframe aggregations, clean null values, compute rolling averages, and calculate Z-score anomaly outliers.

Manual: Monaco editor with auto-complete
Automate: Auto RFM, cohorts & forecast

DuckDB Columnar SQL

Fast analytical SQL engine running compiled WebAssembly. Filter millions of rows in milliseconds using window functions, CTEs, and QUALIFY deduplication.

Manual: High-speed relational queries
Automate: Auto-profile & metric synthesis

Power BI-Style (DAX)

Visual axis builder with DAX-style measures (CALCULATE, SUM, FILTER, DIVIDE, TOTALYTD) right inside your web browser.

Manual: Interactive field axis builder
Automate: Instant DAX measures generation
Workflow

How DataQuery Works

From raw unorganized spreadsheets to an executive presentation in four steps.

1

Connect

Drag-and-drop CSV, XLSX, or connect a live feed (Google Sheets, MySQL, REST API) with automatic type inference.

2

Clean

Audit missing values, eliminate duplicate keys, and inspect automated quality health scores up to 100%.

3

Analyse

Write queries or click Automate. Slice and dice with 90+ built-in functions, moving averages, and DAX measures.

4

Report

Pin charts to customizable dashboards and download AI-written executive reports with action recommendations.

Live Sandbox Ready

Want to see it in action right now?

We pre-seeded a 15-transaction global sales and margin dataset (sales_q3.csv) with regional margins, order dates, and churn risk scores.

Tailored for Every Modern Analyst

Select your domain to see tailored workflows and pre-built templates.

E-Commerce & Retail Brand Analytics

Analyze Average Order Value (AOV), SKU-level gross profit margin percentages, and repeat buyer cycle frequencies directly from Shopify or Amazon order exports.

Preset: Sales Summary · Function: Margin % = DIVIDE(Profit, Revenue)
Open Source

100% Free & Community Driven

Zero subscription fees. Zero artificial dataset paywalls. Zero proprietary vendor lock-in. Powered by local DuckDB-WASM and Pyodide.

Community Edition
$0 / forever free
All Capabilities Unlocked
Unlimited DuckDB SQL queries
In-browser Python (pandas & numpy)
Full Power BI DAX analytical measures
8 one-click Automate recipes
Unlimited interactive visual dashboards
Zero-telemetry client-side privacy

Frequently Asked Questions

Everything you need to know about our technology, pricing, and execution runtime.

DataQuery is an all-in-one hosted data build tool and visual playground. Ingest raw spreadsheets or database feeds, transform them in Python, SQL, or DAX, trigger automated recipes, and generate executive AI reports in seconds.