Pricing

$3.00/month + usage

Try for free

Go to Apify Store

SQL on Files (JSON, CSV and more)

Try for free

Run SQL queries on CSV, JSON, and Parquet files using DuckDB. No database setup required. Upload files, provide URLs, or query Apify Datasets directly. Full SQL support: JOINs, aggregations, window functions. Export as JSON, CSV, or Parquet. Lightning-fast analytical queries.

Pricing

$3.00/month + usage

Rating

5.0

(1)

Developer

Web Harvester

Actor stats

Bookmarked

Total users

Monthly active users

6 days ago

Last modified

Categories

Automation

Developer tools

Integrations

You can access the SQL on Files (JSON, CSV and more) programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in Integrations settings in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1import { ApifyClient } from 'apify-client';
2
3// Initialize the ApifyClient with your Apify API token
4// Replace the '<YOUR_API_TOKEN>' with your token
5const client = new ApifyClient({
6    token: '<YOUR_API_TOKEN>',
7});
8
9// Prepare Actor input
10const input = {
11    "query": "SELECT * FROM data LIMIT 10",
12    "fileUrl": "https://raw.githubusercontent.com/datasciencedojo/datasets/master/titanic.csv"
13};
14
15// Run the Actor and wait for it to finish
16const run = await client.actor("web.harvester/sql-on-files-json-csv-and-more").call(input);
17
18// Fetch and print Actor results from the run's dataset (if any)
19console.log('Results from dataset');
20console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
21const { items } = await client.dataset(run.defaultDatasetId).listItems();
22items.forEach((item) => {
23    console.dir(item);
24});
25
26// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

SQL Query Runner for CSV, JSON & Parquet Files API in JavaScript

The Apify API client for JavaScript is the official library that allows you to use SQL on Files (JSON, CSV and more) API in JavaScript or TypeScript, providing convenience functions and automatic retries on errors.

Install the apify-client

$npm install apify-client

Other API clients include:

SQL on Files (JSON, CSV and more) API in Python

SQL on Files (JSON, CSV and more) API through CLI

SQL on Files (JSON, CSV and more) OpenAPI definition

SQL on Files (JSON, CSV and more) API

SQL Query

useful-tools/sql-query

Run SQL queries over Apify Platform (currently supports only Datasets).

Useful tools

Elite Database Sql Lite

thepattyroller/elite-database-sql-lite

SQL query generator and optimizer. Convert natural language to SQL queries, generate CRUD operations, and optimize existing queries. Perfect for developers and data analysts who need quick SQL assistance.

Logan Kiser

Dataset Query Engine

jiri.spilka/dataset-query-engine

Use natural language queries to retrieve results from an Apify dataset. This Actor provides a query engine that loads a dataset, executes SQL queries, and synthesizes results.

Jiří Spilka

4.6

Auto Insight AI

eager_cornet/sql-explainer

AutoInsight AI is your interactive AI-powered SQL tutor that helps you learn SQL the way professionals master it through guided practice, real examples, instant feedback, and visual execution results.

vikash kumar

SmartData Executor

professional_jostle/SmartData-executor

Run structured data processing on CSV or JSON files. Clean, filter, aggregate, and transform datasets using simple parameters. Designed for analysts, automation workflows, and ETL pipelines. Outputs results as Apify Datasets with execution metadata.

Am Af

Natural Language Dataset Query

apify/natural-language-dataset-query

Use natural language queries to retrieve results from an Apify dataset. This Actor provides a query engine that loads a dataset, executes SQL queries, and synthesizes results. It works as an MCP (Model Context Protocol) server or REST API in Actor standby mode.

Apify

Excel to CSV Converter

web.harvester/excel-to-csv

Convert Excel files (XLSX, XLS, ODS) to CSV format. Extract all sheets or specific ones. Configurable delimiter, date formatting, skip empty rows. Batch processing multiple files. Optional JSON output to Dataset. Handles large files efficiently. Perfect for ETL pipelines.

Web Harvester

5.0

Fast Dataset Cleaner & CSV Formatter

motivational_nickel/dataset-cleaner-and-formatter

Fast dataset cleaning for CSV and JSON files. Automatically removes duplicates, trims whitespace, fixes capitalization, and normalizes fields. Works with Apify datasets or uploaded files and prepares data for analytics, CRM imports, and automation pipelines.

Leoncio Jr Coronado

Zip Download Extraction Scraper

fresh_cliff/zip-download-extraction-scraper

Download and extract zip files automatically. Extract archives, process documents, analyze logs, backup files. Batch extract text, JSON, CSV content. Real-time data extraction API.

Brennan Crawford

JSON ↔ CSV Converter

web.harvester/json-csv-converter

Convert between JSON and CSV bidirectionally. Flatten nested objects to dot notation. Handle arrays with stringify, join, or first element. Custom delimiters (comma, semicolon, tab, pipe). Parse types automatically. Upload files, provide URLs, or load from Apify Datasets.

Web Harvester