Anyquery is a SQL query engine to run SQL queries on anything. It supports querying JSON, CSV, Parquet, Airtable, Google Sheets, Notion databases, Gmail and much more It uses SQLite under the hood and can act as a MySQL server so that you can connect BI tools.
Hello everybody, I'm Julien and I've built Anyquery.
I was looking for a project to keep me busy during the summer vacation so I built this.
SQL is the de-facto query language. But we only limit it to databases. I wanted to push further the query surface of SQL; Therefore, with Anyquery, you can query pretty-much anything : local and remote files (CSV, JSON, Parquet, HTML tables), SaaS (GitHub, Airtable, Notion, Google Sheets) and local apps (Google Chrome tabs, Apple Notes, Apple reminders).
I'm not sure if some integrations have practical use cases. Feel free to discuss a potential use case. If it's not possible yet, I'd be happy to try adding it to Anyquery.
I’m curious about the security features of this tool. With access to various types of data, ensuring robust security measures to protect sensitive information would be crucial.
I’m concerned about how well this tool handles large datasets. If it struggles with performance or speed when querying extensive data, it could limit its usefulness for more demanding tasks.
The support for querying JSON, CSV, Airtable, and more using SQL is unbelievably useful. It’s a versatile tool that covers all the bases.
Great work on this launch! The ability to query across so many platforms is a refreshing take on data management. Thanks for bringing this to us
It might be helpful to include some example queries for each integration to showcase the potential of the tool and guide new users
The capability to query multiple formats like CSV, Parquet, and even Gmail is impressive.
I’ve used other tools for querying APIs, but this one’s ability to handle SQL queries across so many different sources is a notable improvement
This tool is fantastic for anyone working with diverse data sources. The ability to use it with BI tools is a huge plus. Wishing you all the best with this product!
The idea of running SQL queries on so many different data sources is brilliant! This will go smoothly so many of my workflows.
Wow, this Anyquery tool looks super handy! Just checked it out briefly, but it's got some real potential. Great job on the launch, Julien!
Hey Julien, Anyquery sounds awesome and it's exactly what I need! Quick question, though: does it need any coding knowledge to set up? I’m not a coder, so just wondering if that might be an issue for me. Thanks and good luck with your project!
Great launch! Thanks for creating such a versatile tool for data exploration and integration.
This makes life so much easier, Awesome!
Congratulations on the launch!
Best of luck!
Your integration options are impressive. It's great to see support for everything from GitHub to Spotify in one place.
Fantastic for developers. The MySQL compatibility and ability to join across APIs and files is real plus.
Anyquery is such a cool tool! The ability to run SQL queries on different data sources like JSON, CSV, Google Sheets, and even Gmail opens up a world of possibilities. Julien’s idea of pushing SQL’s boundaries beyond just databases is brilliant—who hasn’t wished for a way to tap into data scattered across various apps?
I’m particularly excited about the integration with Airtable and Notion since many of us rely on these for project management and note-taking. Having the flexibility to query directly from these platforms while still using SQL is a huge win for data accessibility!
It would be awesome to see more built-in templates for common queries, especially for users who might not be SQL experts but want to get insights from their data. Also, considering potential use cases for connections to other platforms like Trello or Slack could enhance its reach even further. Can't wait to try this out and see how it evolves!
Hey Julien,
This is an exciting product! 🙂
I'm curious about how you handle the different authentication methods required for various SaaS integrations. Does the user need to set up separate authentication for each service, or is there a unified approach?
I'm also wondering about the performance implications when querying across multiple diverse data sources.
How does Anyquery optimize queries that might involve joining data from, say, a local CSV file with data from Airtable?
The ability to query Chrome tabs is interesting. Are there plans to extend this functionality to other browsers?
Lastly, given the wide range of data sources, how do you approach data type consistency and schema inference across these varied formats?
Congrats on the launch! It's always exciting to see new approaches to data querying and integration.
Julien C