| CARVIEW |
Navigation Menu
-
Notifications
You must be signed in to change notification settings - Fork 63
Releases: julien040/anyquery
0.4.2
1747051Compare
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
- 1747051 Merge pull request #49 (0.4.2 release)
- d4deaec Update navBar.astro: fix link (#39)
- d492cdb ✨ Add Clickhouse querying support
- 6bcc22c ✨ Add support for querying files in MCP #47
- 5635b45 ⬆️ Update dependencies to the latest patch
- 6a33ea1 ⬆️ Upgrade Astro and Tailwind
- 4e33c0d 🐛 Fix issue #40 (stream ID 1; INTERNAL_ERROR)
- e6f88e6 🐛 Fix issue #44 (Create table from csv/parquet file)
- abb689b 🐛 Fix parameters handling of read_* tables
- 56af840 🐛 Potential fix for #48: Airtable marshalling error
- 8ef2e68 📝 Add deprecation notice for the ChatGPT integration
- b21c9ee 📝 Change to brew install anyquery (#38)
- 09fe519 📝 Remove tunnel docs from mcp
- 251f13a 📝 Update README.md for LLMs
- c81f42f 📝 Update documentation for ClickHouse database
- 3129f13 🙈 Update gitignore for integration server
Assets 16
- sha256:4e85af0e50ee4d7cdadea1ec392cdfc468a1bec945f6490a0aeaa6090b5cdc2c31.6 MB
2025-06-10T11:48:09Z - sha256:39582952095dd6832238658640e4c001afe6d66c1afd2b62ed40303c47789a9330.4 MB
2025-06-10T11:48:27Z - sha256:d83d1f45b73cf88886c7f681fe1b9815949b32e7279f7132e0cd0faf41da5e2529.8 MB
2025-06-10T11:48:26Z - sha256:b07511057b932cb1fa1056a5a7d604554f4441b3cfdf2c8f23d912cc1be45c5931.6 MB
2025-06-10T11:48:09Z - sha256:fbd75214a99b2e718fa247c77c22c4a800164df024b105a4e7d4cae58d663b3829.2 MB
2025-06-10T11:48:09Z - sha256:882e7a10249f1e8a5cbb5da48e4df69c3cabd5fd441ce205ec3d8da8ac9378bd28.3 MB
2025-06-10T11:48:26Z - sha256:ccb172f52a0e22c8d9e25450bb56f68c4e05bd5bf9fbc667abeea329ea9ac86727.5 MB
2025-06-10T11:48:26Z - sha256:9e2561e82a26577133bec4b02dd9b5492f3bbd12eae2f54347466bd89d4895b829.3 MB
2025-06-10T11:48:26Z - sha256:aaa5ef4c79bb04d14e8f2dad0bfbd41e053cca9205c1d8955158d5f63bdf3ba526.1 MB
2025-06-10T11:48:09Z - sha256:b3f3f9ea552c02ee6bebcf5e3e9ff221228756dbf399915b2ee0c97cecde19b624.7 MB
2025-06-10T11:48:09Z -
2025-06-10T11:37:38Z -
2025-06-10T11:37:38Z - Loading
0.4.1
Compare
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
Assets 16
0.4.0
Compare
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
- ae75823 ✨ Add
mcpandgptcommands to connect Anyquery to LLMs - 7d23f48 ✨ Add history listing for Edge and Chrome plugins
- a1d26cd ✨ Update all plugins to the latest RPC library
- 244285c 🐛 Fix Notion plugin for issues #31, #26, and #29
- dcc656a 🐛 Remove reduce/reduce conflicts in the parser
- 658297e 👽️ Update Salesforce plugin to latest RPC version
- 48c8c09 💄 Fix image aspect ratio in /integrations
- d2a22ae 💄 Update website for LLMs
- 61b3d38 💬 Remove mention of AnyQuery (replaced by Anyquery)
- 5f1b09b 📝 Add MCP/function call to README.md
- 4de6f0d 🔒️ Add privacy policy for LLM feature
- bcae8f1 🚧 WIP Asana plugin
- 184928d 🧪 Remove failing tests for the sql parser
Assets 16
0.3.1
Compare
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
- abbb833 ✨ Add buffer flushing using functions
- 766bb11 ✨ Add colUsed field to more efficient database queries
- 527d410 ✨ Add partial updates to Notion plugin
- 93bcea9 ✨ Add support for except/intersect queries
- f7a1d9d ✨ Nicer plugin development UX.
- 5111faa ⬆️ Update Anyquery RPC version for notion
- a1a35a5 🐛 Ensure parser properly format query parameters
Assets 16
0.3.0
Compare
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
Database querying
Anyquery now supports database querying. You can join data between APIs, local files, apps, and now SQL databases.
At the moment, we support PostgreSQL-wire and MySQL-wire compatible databases.
Fixes
There are a lot of fixes that have been made. Feel free to open an issue if you find any new bugs.
Breaking changes
- To work with PRQL, PRQL now needs to be installed on your machine and available in the
PATH. - The Anyquery's SQL parser has changed, which means that there might be undiscovered issues.
- When you query from a remote file, the cache can now be invalidated.
- Anyquery cannot be installed with
snapcraftanymore due to confinement issues.
Commits
- 00b9fb3 ✅ Remove failing test for plugin loading
- 1311a60 ✅ Update weird failing test
- b322d10 ✨ Add ClickUp plugin
- 5d39397 ✨ Add Coda plugin
- 8e56cd0 ✨ Add PostgreSQL db querying
- 50524ef ✨ Add SQLite version to -v flag
- e263e2f ✨ Add Salesforce custom plugin
- c2247a7 ✨ Add Salesforce plugin
- 4bc37c9 ✨ Add hashing function for query constraint
- afed809 ✨ Add hubspot plugin
- 4abdd6e ✨ Add new SQL date functions
- 0e07a11 ✨ Add new type conversion for plugin configuration
- c632b6c ✨ Add search bar to website
- a8be1f1 ✨ Add stanchion plugin
- eb9dce5 ✨ Add support for MySQL-based databases
- 8937e50 ✨ Add support for additionnal types
- 1fc1da7 ✨ Modify the release header to include a SQL snippet
- 347bb68 ✨ Update website to document databases connections
- e2d412c ➖ Ditch pg_query parser for SQL query
- 2844256 ⬆️ Run go mod tidy
- ea4deec ⬆️ Run go mod tidy and update vitess lib
- bc9b932 ⬆️ Update SQLite to v3.47.0
- d1798da ⬆️ Upgrade dependencies to latest version
- e4797ba 🐛 Fix DESCRIBE table_name queries on composite PK
- 53861ec 🐛 Fix issue in goreleaser template Tabs instead of spaces...
- 3d0fb0e 🐛 Fix issue with argument type for Salesforce plugin
- 49f201d 🐛 Fix pull request query
- a6399aa 🐛 Fix weird cache invalidation bug for the query hub
- 1de3cec 🐛 Proper data validation for profile creation
- 9d01809 🐛 SQLparser quoting issue Ensure that if a single quote was encountered in a string literal, the formatter would return '' to escape it. Before, it would attempt to write ', which is MySQL specifix syntax.
- bbf350e 👷 Remove snapcraft publishing
- dc37f1f 💄 A few UI updates to the website
- 725af31 💄 Larger tables for terminal output
- 0be92c0 💄 Update header image
- 1ad6de1 📝 Add more docs for query hub
- 7a269a1 📝 Remove snapcraft tutorial while snap issues aren't fixed
- c84be1b 📝 Update README.md to talk about databases
- fab1995 📦️ Move snapcraft to classic confinement
- 10d0933 📦️ Update name format to a namespace based one (thanks @asg017)
- 925ecf7 🔍️ Update SEO desc
- 86e215a 🔥 Remove statical linking of PRQL
- f7b881a 🚑️ Add support for non public schema tables in PostgreSQL
- 0e866ef 🚸 Registry refreshes every two days now
Contributors
Assets 16
0.2.2
Compare
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
- f987aea ⚡️ Add cache TTL for the run cmd
- 2e14eaf ✨ Add a few github community queries
- 5e40695 ✨ Add new fields for hub queries
- c061c2c ✨ Add query hub to website
- b09e96a ✨ Update a couple of community queries
- 6aeb31c ✨ Update git plugin
- 6908c4e 🐛 Fix #4: Pretty table output was too wide for some terminals
- 13217dd 👷 Rename branch for winget repository
- a1b1390 💄 Add hovering effects to links
- 2f99872 📝 Update docs for anyquery run
- e3f71a1 🚑️ Fix critical issue with INSERT stmt
Assets 16
0.2.1
Compare
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
Assets 16
0.2.0
Compare
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
What's new?
Community repository
Go to https://anyquery.dev/queries to find a community repository of predefined queries. You don't have to touch SQL anymore. Answer questions easily from various sources.
JSON output
JSON output now correctly handles arrays and objects.
Log querying
Log querying is now faster and more powerful. Before, it often failed due to RegExp issues. They are now fixed!
Changelog
- 0942aee ✨ Add reproducible build for future plugins
- be94d5b ✨ Add support for community queries
- 893e3a5 ✨ Strengthen log querying capabilities
- 8f9fb97 ⬆️ Upgrade SQLite to 3.46.1
- c73835e 🐛 Fix issue #17
- b2b5daa 💄 Update plugins list cmd rendering
- 3b235b3 🗃️ Update query templates
- 673b9c5 🩹 Ensure the query splitter handle comments
Assets 16
0.1.3
Compare
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
- eb2a3a1 ✨ Add -v, --version flags
- a1859c6 ✨ Add Google Contacts plugin
- 88433e1 ✨ Add Nylas plugin
- 73aff63 ✨ Add new plugins from asg017
- 2c921ab ✨ Add plugin Google Tasks
- 88ff95f ✨ Add shopify plugin
- 4f6646e ✨ Add sqlean extensions
- aeaf765 ✨ Add table "github_stargazers_from_repository" to GitHub plugin
- 2507e3b ✨ Make the JSON output stream
- 4469f41 🐛 Fix NULL to empty array
- c0b5d53 🐛 Fix issue with OAuth 2.0 scopes in Google Contacts plugin
- 379cf22 🐛 Fix issue with PRQL build (#9)
- 34e4bf7 🐛 Fix rare map race condition
- 6166fef 💄 Add icons to integrations
- b8e18cc 💄 Add logo variant
- 74d092b 💄 Fix landing page from feedback
- 7f64e90 💄 Update website - Add a few changes to the landing - Hide test integrations - Update doc of Anyquery limitations
- c823aac 📝 Add examples to commands reference
- d060b52 📝 Update Google plugins documentation about OAuth
- 9a2daa4 📝 Update README.md
Assets 16
0.1.2
Compare
What is Anyquery?
Anyquery is a query engine that allows you to query anything over SQL.
Whether it's a local CSV, a Google Sheet, your Apple notes, or your GitHub stars, you can query it with Anyquery.
It's built on top of SQLite, and you can use alternative languages like PRQL and PQL to query your data.
Get started at anyquery.dev
Changelog
- ca8e135 ✏️ Fix 404 on footer
- dcaedac ✨ Add Docker plugin
- b5c8bb8 ✨ Add Todoist plugin
- 0e6ded0 ✨ Add Vercel plugin
- 05c4dea ✨ Add log querying
- 0b84b58 ✨ Update HN plugin: add list tables
- 84db1ad ⬆️ Update RPC dependency for plugins with DB
- 3443508 🐛 Enclose column name for CSV, HTML, and JSONL
- 88d3bdc 💄 Add Product Hunt badge
- 658ae54 💬 Fix typo in README.md
- 40b88b8 📝 Update doc