AnyqueryQuery anything (JSON, GitHub, Notion,Airtable,etc.) with SQL

Anyquery - Use SQL for Everything

Introduction

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.

Key Features

• Built-in MySQL Server: Connect Anyquery to Metabase, Drizzle, or your favorite ORM.
• File Format Support: Import/export data from/to JSON, CSV, TSV, Parquet.
• SQLite Ecosystem: Supports the whole SQLite ecosystem, e.g., Litestream, Datasette.
• Join Support: Perform SQL joins between APIs, files, and SQLite tables.
• Alternative Query Languages: Use PRQL or PQL if you prefer over SQL.
• Developer-Friendly: Easy to build integrations with a read-only plugin function and a dev mode for plugin development.
• Extensive Integrations: Integrate with GitHub, Notion, Typeform, CSV, Sheets, Pocket, Spotify, Airtable, Raindrop, and more.

Use Cases

• Migrate Your Data: Effortlessly transfer data between SaaS platforms, such as moving Safari tabs to Pocket or Hacker News comments into Google Sheets.
• Explore Your Data: Retrieve data from API endpoints with ease. Use MySQL clients like Metabase, Redash, Superset for data exploration.

Pricing

Anyquery is open-source and licensed under AGPL v3. It runs locally with a CLI that you can install using the following command:

echo "deb [trusted=yes] https://apt.julienc.me/ /" | sudo tee /etc/apt/sources.list.d/anyquery.list
sudo apt update
sudo apt install anyquery

Teams

Anyquery is designed to support teams of all sizes, providing robust data querying capabilities and seamless integrations to enhance productivity and data management.