Query anything with old-school cool SQL

From your Chrome tabs to your Notion database, passing through your GitHub stars, there is a SQL query for that. One query language, tens of APIs

Install Documentation

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

Typeform

CSV

Sheets

Pocket

Spotify

Airtable

Raindrop

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

Easy to build integrations for developers

A read-only plugin is only one function that gets called until no more data is available.
Moreover, Anyquery features a dev mode to help you build your plugin

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, Superset, etc.

We ❤️ open source

Anyquery is AGPL v3 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.