Show HN: Anyquery – A SQL query engine for anything (CSV, GitHub, Airtable,etc.)
Anyquery is a command-line tool for executing SQL queries across various data sources, supporting multiple operating systems and formats, with features for data integration and open-source licensing under AGPL v3.
Read original article
Anyquery is a command-line interface (CLI) tool designed to execute SQL queries across various data sources, including files, APIs, logs, and local applications. It supports multiple operating systems, including GNU/Linux, macOS, and Windows. The tool features a built-in MySQL server, allowing connections to popular data exploration tools like Metabase and Drizzle. Anyquery supports various data formats such as JSON, CSV, TSV, and Parquet, enabling users to import and export data seamlessly. It also allows SQL joins between different data sources, including APIs and files. For users who prefer alternatives to SQL, Anyquery supports PRQL and PQL query languages. The tool can treat platforms like Notion, Google Sheets, and Airtable as databases, providing full CRUD (Create, Read, Update, Delete) capabilities. Anyquery is open-source and licensed under AGPL v3, emphasizing its community-driven development. Users can easily install Anyquery using a simple command and explore its extensive integration capabilities for data migration and exploration.
- Anyquery is a CLI tool for running SQL queries on various data sources.
- It supports multiple operating systems and data formats, including JSON and CSV.
- Users can perform SQL joins across different data sources and platforms.
- The tool allows treating Notion, Google Sheets, and Airtable as databases.
- Anyquery is open-source and licensed under AGPL v3.
Related
Open Source Python ETL
Amphi is an open-source Python ETL tool for data extraction, preparation, and cleaning. It offers a graphical interface, supports structured and unstructured data, promotes low-code development, and integrates generative AI. Available for public beta testing in JupyterLab.
Redis Alternative at Apache Software Foundation Now Supports RediSearch and SQL
A new query engine, KQIR, supports SQL and RediSearch queries for Apache Kvrocks, a Redis-compatible database. It aims to combine performance with transaction guarantees and complex query support, utilizing an intermediate language for consistency. Future plans include expanding field types and enhancing transaction guarantees.
Using Agents to Not Use Agents: How we built our Text-to-SQL Q & A system
Ask-a-Metric is a WhatsApp-based AI tool for SQL queries in the development sector, improving accuracy and efficiency through a pseudo-agent pipeline, achieving under 15 seconds response time and low costs.
Open Source Tools to Query OpenStreetMap
OpenStreetMap offers extensive geographical data, but its size complicates usage. Tools like Overpass Turbo, osm2pgsql, DuckDB, and QLever facilitate querying, each with unique advantages for data analysis.
Open source tools to query OpenStreetMap
OpenStreetMap offers extensive geographical data but is large and complex. Tools like Overpass Turbo, osm2pgsql, DuckDB, and QLever provide various querying options, each with unique advantages and limitations.
3 commentsRelated
Open Source Python ETL
Amphi is an open-source Python ETL tool for data extraction, preparation, and cleaning. It offers a graphical interface, supports structured and unstructured data, promotes low-code development, and integrates generative AI. Available for public beta testing in JupyterLab.
Redis Alternative at Apache Software Foundation Now Supports RediSearch and SQL
A new query engine, KQIR, supports SQL and RediSearch queries for Apache Kvrocks, a Redis-compatible database. It aims to combine performance with transaction guarantees and complex query support, utilizing an intermediate language for consistency. Future plans include expanding field types and enhancing transaction guarantees.
Using Agents to Not Use Agents: How we built our Text-to-SQL Q & A system
Ask-a-Metric is a WhatsApp-based AI tool for SQL queries in the development sector, improving accuracy and efficiency through a pseudo-agent pipeline, achieving under 15 seconds response time and low costs.
Open Source Tools to Query OpenStreetMap
OpenStreetMap offers extensive geographical data, but its size complicates usage. Tools like Overpass Turbo, osm2pgsql, DuckDB, and QLever facilitate querying, each with unique advantages for data analysis.
Open source tools to query OpenStreetMap
OpenStreetMap offers extensive geographical data but is large and complex. Tools like Overpass Turbo, osm2pgsql, DuckDB, and QLever provide various querying options, each with unique advantages and limitations.