SQLBlitz

SQL Query CSV & Parquet Files

Only for Mac

$14.99

Mac

New: Excel support and column statistics. Query .xlsx files with SQL, then press Command-I to see nulls, distinct counts and top values for any column. SQLBlitz lets you query CSV, Excel, Parquet and JSON files with SQL. Directly, instantly, no setup required. No database to configure. No import process. No waiting. Just open your file and start writing SQL. It's the tool that should have existed years ago. QUERY FILES DIRECTLY WITH SQL Other tools make you import data into a database first. SQLBlitz opens your files and lets you query them immediately. CSV, Excel, Parquet or JSON: open it and SELECT. EXCEL FILES ARE JUST TABLES Open .xlsx workbooks and query them like any other table. Join a spreadsheet with a CSV or Parquet file, filter and group it with SQL, and export the result to CSV. UNDERSTAND YOUR DATA INSTANTLY Press ⌘I to profile any column. See nulls, distinct values and the most common values, plus min, max, mean, median and standard deviation for numbers and length ranges for text. Move between columns with the arrow keys and switch tables from the dropdown. HANDLES FILES THAT CRASH OTHER APPS Built on DuckDB's analytical engine. Load a 500MB CSV with 2 million rows in 1.2 seconds. Get query results in 20 milliseconds. Open files that make Numbers and Excel give up. NATIVE MAC APP Not Electron. Not Java. A real macOS app that's fast, light, and feels like it belongs on your Mac. POWERFUL QUERY EDITOR - Syntax highlighting with dozens of themes - Tabbed query windows that persist across sessions, each with its own results - Run queries with ⌘+Enter: your selection, or the statement under the cursor - Save queries as .sql files - Query history with one-click recall - Click column names in the schema browser to insert them SMART DATA MANAGEMENT - Data sources persist across sessions, so you reload only what you need - Import several files at once - Name tables on import - Unload files to free memory - Live memory usage display FAST RESULTS - Paginated results handle millions of rows - Copy all to clipboard - Export to CSV 100% PRIVATE All processing happens locally. No data collection. No telemetry. No network access. Your data stays on your Mac. Stop importing. Start querying.

  • This app hasn’t received enough ratings or reviews to display an overview.

NEW: EXCEL SUPPORT Open .xlsx workbooks and query them with SQL. Join them with your CSV, Parquet and JSON files and export the results. NEW: COLUMN STATISTICS Press ⌘I to profile any column: nulls, distinct values, min, max, mean, median and top values. Move between columns with the arrow keys and switch tables from the dropdown. NEWER QUERY ENGINE Upgraded to DuckDB 1.5 for the latest SQL features and engine improvements. IMPROVEMENTS AND FIXES - Each query tab now keeps its own results and page - CREATE, INSERT and other non-SELECT statements now run - Table and column names with spaces or special characters now work - Selecting several files in the file picker now loads all of them - Saved data sources no longer go missing between launches - Error messages now show exactly what went wrong in your SQL - Fixed a rare crash on launch - Many smaller fixes to paging, ⌘/ commenting and the schema panel

The developer, RJ Simpson, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .

  • Data Not Collected

    The developer does not collect any data from this app.

    Privacy practices may vary, for example, based on the features you use or your age. Learn More

    The developer has not yet indicated which accessibility features this app supports. Learn More

    Seller
    RJ Simpson
    Size
    20.3 MB
    Category
    Developer Tools
    Compatibility
    Requires macOS 14.0 or later.
    • Mac
      Requires macOS 14.0 or later.
    Languages
    English
    Age Rating
    4+
    Copyright
    © 2026 West River Data Systems LLC