Recipes - Anyquery

Feel free to click on any recipes in the sidebar to learn more about how to use Anyquery.

What is Anyquery?

Anyquery is a SQL query engine that allows you to query data from multiple sources (Airtable, Google Sheets, CSV, Shopify, etc.) using SQL.

You can use Anyquery to create a single source of truth for your data, create custom dashboards using third-party tools like Metabase, and extract your data from Saas platforms.

Other cool guides

How to filter an HTML table using SQL?

Learn to filter HTML tables using Anyquery's SQL query engine. This tutorial covers prerequisites, querying steps, and exporting results to JSON for easy data handling.

How to query Apache logs using SQL?

Learn to query Apache logs with SQL using Anyquery. This guide covers identifying log formats, using Grok patterns, filtering data, and exporting results.

How to transfer my GitHub stars to an Airtable table?

Learn to transfer starred GitHub repositories to an Airtable table using Anyquery. This tutorial covers prerequisites, plugin configuration, and the SQL query needed for data transfer.

Generate a CSV full of random data

Learn how to generate a CSV file full of random data using Anyquery.

How to list my completed reminders on macOS?

Learn how to list completed reminders on macOS using Anyquery. Install the Reminders plugin, run an SQL query, and export results in CSV or JSON formats.

Using a Google Sheets as a SQL database

Learn to use Google Sheets as a SQL database with Anyquery. Install plugins, authenticate with Google, configure settings, and perform SQL operations seamlessly.

anyquery

A love letter to SQL. Query anything — including the services you thought you'd never escape.

Guide

Install Running a query Connecting LLMs Install plugin JSON/CSV export Developers

Connection guide

ChatGPT Claude LibreChat Datasette TablePlus

Available for an internship