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 query Nginx logs using SQL?

Learn to query Nginx logs using SQL with Anyquery. Understand `grok` patterns, filter and analyze data, and export results to formats like CSV. Full guide included.

How to get the files matching a specific pattern in a directory?

Learn how to use Anyquery to find files matching specific patterns in a directory. Install the `file` plugin, run `file_search` queries, and export results to CSV or JSON.

How to export emails from a Gmail account to a CSV file?

Learn to export Gmail emails to a CSV file using Anyquery with an IMAP plugin. Follow step-by-step instructions to configure, query, and export your data effortlessly.

How to export emails from a Gmail account to a SQLite database?

Learn how to export Gmail emails to a SQLite database using Anyquery. This guide covers prerequisites, setting up an IMAP profile, querying emails, and exporting data.

How to filter my docker containers list?

Learn how to filter your Docker containers list using Anyquery SQL engine. This tutorial covers filtering by status, name, image, size, and more advanced scenarios.

How to close my brave tabs matching a specific URL?

Learn how to close Brave Browser tabs matching a specific URL using Anyquery's SQL query engine. Follow simple steps to install the plugin and execute queries.

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

Seeking an internship