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
Spotify
Airtable
Raindrop
Hover over the icons to see the query examples
and more to come
so that you can connect Anyquery to Metabase, Drizzle or your favourite ORM
Import/export data from/to your favourite file format
Supports the whole SQLite ecosystem e.g. Litestream, Datasette
Do SQL join between APIs, files, and SQLite tables
You don’t like SQL. Fine, use PRQL. Used to Microsoft Kusto, all good use PQL
Anyquery can query Notion, Google Sheets, and Airtable as if they were a database with INSERT/UPDATE/DELETE support.
Using Grok, you can parse and query logs locally and remotely
Connect your favorite SaaS to BI tools using the MySQL compatibility
Export your query results to JSON, CSV, TSV, Markdown, HTML, etc.
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
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.
Reuse SQL queries from the community to query anything, even without
SQL knowledge.
Answer data questions in seconds
Anyquery is AGPL-3.0-or-later licensed
Anyquery runs locally with a CLI that you can install with this command
brew install julien040/anyquery/anyquery
Trademarks are the property of their respective owners. All benchmarks are performed on a MacBook Air M1 16GB.