ZenQuery

A fully local desktop app to get instant answers from your data files — CSV, JSON, Excel, Parquet — using plain English. Simply select your files and start asking questions. That's it!!

Daily Usage Highlights

Thousands of people ask tens of thousands of questions daily, saving over 1,000 hours every day.

Active Users 1,000+ asking questions
Questions Asked 20,000+ daily total
File Sizes 1 KB – 1+ GB varied
Speed & Cost < 3 sec & 1/50 ¢ per answer

Saving 60 minutes and a lot of frustrations daily for everyone.

Real-time demo of performing QA in plain English on a massive 2.9GB payments dataset containing over 7 million transactions data.

Video preview
Thousands of your questions answered in less than a dollar •|• Handles files with tens of millions of rows in seconds •|• Mix and match files of different types in same question •|•️ Full data privacy

Why ZenQuery?

Unlike traditional tools, ZenQuery combines speed, cost-effectiveness, power, and simplicity in one elegant solution.

🚀

Excel & Similar Tools Cannot Handle Large files

Excel and other spreadsheets grind to a halt once you hit about 100 k rows, often freezing your computer. ZenQuery races through tens of millions of rows with no slowdown, so you can work at full speed.

💰

AI Chat Tools Get Super Expensive Super Quickly

ChatGPT-style bots can rack up hundreds of dollars just to answer a few hundred questions on a 1 MB file. Anything bigger quickly hits their context limits. ZenQuery handles real-world data without sky-high bills or hard stops.

🔒

Cloud Based Tools Do Not Offer Privacy

Uploading sensitive files to the cloud can put privacy at risk. ZenQuery runs locally, keeping your data secure and compliant while still delivering powerful queries.

⚙️

Running SQL Manually (and Setting Up Database and Tables) Is Just Too Painful

Forget spinning up databases, designing schemas, loading data, and writing SQL for every question. With ZenQuery you simply drop in your files and ask — no setup, no syntax headaches, just answers.

Sample Questions You Can Start Asking Immediately

📊 E-commerce

  • •

    What are the top 10 best-selling products this month?

  • •

    Which products have high views but low conversions?

  • •

    Show me revenue by product category

📧 Marketing

  • •

    Show me email campaigns with the highest open rates

  • •

    Which channels drove the most traffic last quarter?

  • •

    Compare conversion rates by campaign

💼 Sales

  • •

    List all leads converted by each rep this month

  • •

    Who are our top 20 customers by revenue in 2024?

  • •

    Show me sales trends by region

💼 Human Resources

  • •

    Find the top 5 highest-paid employees and their roles

  • •

    List all employees hired after January 1, 2020

  • •

    Show average salary by performance rating

💼 Logistics

  • •

    Find the average delivery time and average delay per route.

  • •

    Get the total number of orders fulfilled per SKU

  • •

    Find average pick and pack time per warehouse zone

💼 Debugging Data Files

  • •

    Find rows with missing or null values in any column

  • •

    Detect duplicate rows based on key columns

  • •

    Check timestamp column for outliers or gaps

💼 Healthcare

  • •

    Find patients with most hospital visits in past 6 months

  • •

    Average treatment cost per department

  • •

    Detect missing discharge summaries or vital signs

💼 Finance / Banking

  • •

    Find transactions over $10,000 without justification notes

  • •

    Compare loan default rates across customer segments

  • •

    Find accounts with inconsistent balances over time

Extremely Cost-Effective

Ask thousands of questions for under a dollar

(Example for a single CSV with 10 numerical columns)

Model Quality Questions Per Dollar Use For
openai/gpt-4.1-mini Close to Best,

Recommended ⭐

 4,500 Daily usage for simple to complex questions
openai/gpt-4o Best 300 Very complex and detailed questions
google/gemini-2.0-flash Very Good 18,000 Extremely heavy usage up to moderately complex questions
deepseek/deepseek-chat-v3 Very Good 6,500 Heavy usage up to moderately complex questions
openai/gpt-4o-mini Good 12,000 Very heavy usage up to low-moderately complex questions

Frequently Asked Questions

What file formats does ZenQuery support?

ZenQuery supports CSV, JSON, Excel/XLSX, Parquet, JSONL, and NDJSON files. You can mix and match different file types in a single session for comprehensive analysis.

How much does it cost to use ZenQuery?

ZenQuery is extremely cost-effective. With our recommended model (gpt-4.1-mini), you can ask around 4,500 questions for just $1. Costs depend on the number of files, not their sizes.

Is my data secure and private?

Yes, absolutely. By default, only the first 3 rows of your data are shared with the LLM for analysis. You can adjust this to zero in settings if needed. Your files never leave your computer.

What's the maximum file size ZenQuery can handle?

ZenQuery can easily handle files with millions of rows and multi-GB sizes. Unlike Excel which slows down with large files, ZenQuery processes massive datasets in under 5 seconds.

Do I need to know SQL or coding to use ZenQuery?

Not at all! ZenQuery is designed for non-technical users. Simply ask questions in plain English like "What are my top 10 customers by revenue?" and get instant answers. If you are a data analyst, use this to quickly get auto-generated sql queries.

Which LLM providers are supported?

ZenQuery works with any OpenAI-compatible service (almost all providers supported). We recommend OpenRouter for beginners, but you can also use OpenAI directly or other compatible providers.

Can I use multiple files in one analysis?

Yes! You can combine multiple files of different formats in a single session. ZenQuery will analyze them together, allowing for comprehensive cross-file insights.

What operating systems are supported?

Currently, ZenQuery is available for MacOS and Windows, with versions optimized for both ARM, M-Series and Intel processors. Linux version is being developed. Do drop us an email if you're interested :)

🎉 10,000 Downloads & Counting!

To celebrate: ZenQuery is 100% FREE until July 20, 2025

Start your trial now – then just email us at support@zenquery.app with the subject: Celebrating 10,000 downloads
We'll convert your trial into a lifetime license for FREE. No credit card needed!

Are you a student or researcher? Email us for lifetime free access — always. 🙂

Mac (M-Series Chips)

Optimized for M-series chips

Mac (Intel Chips)

For older Mac computers

Windows (Intel Chips)

Most Common Windows PCs

Windows (ARM Chips)

For Surface Pro X & other ARM PCs

(Linux version available on request)

Quick Setup Guide

1

Download & Install

Choose your Mac version and install

2

Get API Key

Sign up at OpenRouter or OpenAI

3

Add Your Files

Add files you want to analyze

4

Start Querying

Ask questions in plain English

Detailed Usage Guide •|• Detailed Video Guide

You can also pay directly from the app

Enterprise Solutions

All the enterprise-grade features you need to secure, monitor, and manage at scale.

🔑

SSO (Single Sign-On)

Integrate with your identity provider for seamless login.

👥

Role-Based Access Control (RBAC)

Define roles & permissions for granular access control.

📜

Audit Logs

Track and review all user actions and system events.

🔒

End-to-End Encryption

Data encrypted in transit and at rest for maximum privacy.

�

Sensitive Data Masking

Automatically redact or mask PII in your reports.

📴

Offline/Air-gapped Mode

Operate fully disconnected from the internet.

🏠

On-premise / Private-cloud

Deploy within your own infrastructure.

🗝️

Enterprise License Server

Offline activation & centralized license management.

⚙️

Custom Usage Rules

Define policies, quotas, and usage limits.

🚨

Automated Alerts

Get notified on thresholds, errors, or suspicious activity.

🗂️

Centralized User Management

Manage all users, groups, and permissions from one console.

📈

Usage Metrics & Monitoring

Real-time dashboard for usage analytics.

🖥️

License Management Portal

Self-service portal for license assignments and renewals.

🤝

Dedicated Account Manager

Personalized support and onboarding.

📊

Cross-organization Reporting

Generate consolidated reports across multiple teams.

For enterprise inquiries, reach us at support@zenquery.app .