Anyquery

Anyquery is a command-line interface tool that enables developers to run SQL queries across diverse data sources. Instead of dealing with multiple APIs and file formats separately, you can use standard SQL syntax to query data from GitHub, Notion, Google Sheets, Airtable, CSV files, logs, and various other sources. The tool acts as a unified SQL interface for all your data needs.

What makes Anyquery stand out is its built-in MySQL server compatibility, allowing you to connect popular business intelligence tools like Metabase, Tableau, or your favorite ORM directly to Anyquery. It supports the full SQLite ecosystem and offers extensive format support including JSON, CSV, TSV, and Parquet files. The tool also enables joins between different data sources and even supports write operations on APIs with full DML (INSERT/UPDATE/DELETE) capabilities.

Anyquery is particularly useful for developers and data analysts who need to work with data from multiple sources without switching between different tools or learning various API specifications. It excels at data migration tasks, such as moving Safari tabs to Pocket or transferring Hacker News comments to Google Sheets. The tool runs locally and is open source under AGPL-3.0 license, making it accessible for both personal and professional use cases.