Query anything with old-school cool SQL

Anyquery is a CLI tool to run SQL queries on any data source, no matter if it's a file, an API, logs, or a local app.
See the integrations for the full extent of what you can do.

Supports GNU/Linux, macOS and Windows


          

Each elapsed time corresponds to the real result of the first query after a warm-up query

GitHub

Notion

Logs

CSV

Sheets

Pocket

Spotify

Airtable

Raindrop

Hover over the icons to see the query examples

Full of features

and more to come

MySQL compatibility

Built-in MySQL server

so that you can connect Anyquery to Metabase, Drizzle or your favourite ORM

JSON, CSV, TSV, Parquet support

Import/export data from/to your favourite file format

It’s just SQLite

Supports the whole SQLite ecosystem e.g. Litestream, Datasette

Join support

Do SQL join between APIs, files, and SQLite tables

Supports alternative query language

You don’t like SQL. Fine, use PRQL. Used to Microsoft Kusto, all good use PQL

Write on APIs / DML support

Anyquery can query Notion, Google Sheets, and Airtable as if they were a database with INSERT/UPDATE/DELETE support.

Log querying

Using Grok, you can parse and query logs locally and remotely

Data visualization

Connect your favorite SaaS to BI tools using the MySQL compatibility

Query export

Export your query results to JSON, CSV, TSV, Markdown, HTML, etc.

An extensive list of integrations

that you will love using

See all integrations

Use cases

Migrate your data

Migrate your data between SaaS platforms with ease! Effortlessly transfer your Safari tabs to Pocket, your Hacker News comments into a Google Sheets spreadsheet, etc. The possibilities are limitless

Explore your data

Struggling to retrieve data from API endpoints? Anyquery does it for you. Simply craft your SQL query and we handle everything else. And thanks to the MySQL compatibility, you can use any MySQL client for data exploration such as Metabase, Redash, Tableau, etc.

We ❤️ open source

Anyquery is AGPL-3.0-or-later licensed

Getting started

Anyquery runs locally with a CLI that you can install with this command

brew install julien040/anyquery/anyquery
See other platforms

Trademarks are the property of their respective owners. All benchmarks are performed on a Macbook Air M1 16GB.