You can access the SQL Query 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

$echo '{
<  "query": "SELECT '\''test data'\'' as `test column`"
<}' |
<apify call useful-tools/sql-query --silent --output-dataset

SQL Query API through CLI

The Apify CLI is the official tool that allows you to use SQL Query locally, providing convenience functions and automatic retries on errors.

Install the Apify CLI

$npm i -g apify-cli
$apify login

Other API clients include:

SQL Query API in Python

SQL Query API in JavaScript

SQL Query OpenAPI definition

SQL Query API

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

PGVector Integration

apify/pgvector-integration

This integration transfers data from Apify Actors to a Postgres SQL database (with PGVector extension).

Apify

4.6

Microsoft SQL Server Insert

petr_cermak/MSSQL-insert

This actor takes a crawler execution and inserts its results into a remote MSSQL database.

Petr Cermak

Backup MySQL Database - Google drive Integration

worldunboxer/backup-mysql-database

Effortlessly back up your MySQL database with our Apify actor. It securely connects to your database, generates full SQL backups, and stores them on Google Drive, FTP servers, or Apify Key-Value Store. Ensure data safety with seamless storage and sharing options tailored to your needs.

Umesh Patidar

5.0

Diff Datasets

pocesar/diff-datasets

Take one dataset on Apify platform, compare it to another, and output the missing ones. This can also be used to output only changed items, using a compound key

Paulo Cesar

Scrape Emails And Social Media Links With Just a Query

lead.gen.labs/scrape-emails-and-social-media-links-with-just-a-query

Get Emails And Social Media Links With Just a Query !!!!! The actor will take a query and some parameter as input and scrape contact details with just a query. ACTOR IS FREE FOR LIMITED TIME.

LeadGen Labs

144

Apify TV (BETA)

jupri/apify-tv

Scrape and download video from all over internet

cat

Apify Scraper

dz_omar/apify-scraper

Extract actor data from the Apify Store, including pricing, stats, and user info. Supports multiple queries, filters, and crash-safe state persistence. 🧑‍💻 Open-source and ideal for research, analysis, and discovering tools.

Abdlhakim hefaia

5.0

Query RSS Feeds

xiaopanai/Apify-RSS-Search

Run keyword queries on custom list of RSS feeds to find the contents that you want. Uses fuzzy logic to match the query to the contents and also applies a recency adjustment (higher penalty for older entries).

Xiaopan AI

114

Tracking Events

shareze001/tracking-events

Retrieve tracking information (including date, address, description, etc.), ETA date, and delivery status. Currently supports tracking for UPS, Passport, DHL.