{"repo":"julien040/anyquery","free":true,"listed":false,"github":"https://github.com/julien040/anyquery","clone":"git clone https://github.com/julien040/anyquery.git","description":"One SQL interface for 60+ tools (e.g., GitHub, Notion, Airtable). Plug into any LLM through MCP.","language":"Go","stars":1756,"topics":["ai","analytics","api","business-intelligence","chatgpt","csv","data-visualization","database","github","go","json","llm","mcp","mysql","notion","parquet","salesforce","sql","sqlite"],"license":null,"category":"data_integration_tool","readme_excerpt":"# Anyquery\n\n<img src=\"https://anyquery.dev/images/logo-shadow.png\" alt=\"Anyquery logo\" width=\"96\"></img>\n\n![GitHub Downloads (all assets, all releases)](https://img.shields.io/github/downloads/julien040/anyquery/total)\n![GitHub commit activity](https://img.shields.io/github/commit-activity/m/julien040/anyquery)\n[![Documentation](https://img.shields.io/badge/documentation-blue)](https://anyquery.dev)\n[![GitHub issues](https://img.shields.io/github/issues/julien040/anyquery)](https://github.com/julien040/anyquery/issues)\n[![Dynamic JSON Badge](https://img.shields.io/badge/dynamic/json?url=https%3A%2F%2Fregistry.anyquery.dev%2Fv0%2Fregistry%2F&query=%24.plugins_count&label=Integrations%20count&cacheSeconds=3600)](https://anyquery.dev/integrations/)\n[![Dynamic JSON Badge](https://img.shields.io/badge/dynamic/json?url=https%3A%2F%2Fregistry.anyquery.dev%2Fv0%2Fquery%2F&query=%24.queries_count&style=flat&label=Queries%20from%20the%20hub&cacheSeconds=3600&link=https%3A%2F%2Fanyquery.dev%2Fqueries)](https://anyquery.dev/queries)\n[![Go Reference](https://pkg.go.dev/badge/github.com/julien040/anyquery@v0.1.3/namespace.svg)](https://pkg.go.dev/github.com/julien040/anyquery/namespace)\n[![Trust Score](https://archestra.ai/mcp-catalog/api/badge/quality/julien040/anyquery)](https://archestra.ai/mcp-catalog/julien040__anyquery)\n\n---\n\n<p align=\"center\">\n  <sub><i>Sponsored by</i></sub><br><br>\n  <a href=\"https://www.atlascloud.ai/?utm_source=github&utm_medium=link&utm_campaign=anyquery\">\n    <picture>\n      <source media=\"(prefers-color-scheme: dark)\" srcset=\"https://cdn.julienc.me/share/atlas-cloud-logo-white.svg\">\n      <img src=\"https://cdn.julienc.me/share/atlas-cloud-logo-black.svg\" alt=\"Atlas Cloud\" width=\"220\">\n    </picture>\n  </a>\n</p>\n\n<h3 align=\"center\">\n  <a href=\"https://www.atlascloud.ai/?utm_source=github&utm_medium=link&utm_campaign=anyquery\">One AI API for LLMs, image &amp; video generation — 300+ models</a>\n</h3>\n\n<p align=\"center\">\n  <sub>\n    Atlas Cloud is a full-modal AI inference platform: a single API and one account for chat completions,<br>\n    image generation, and video generation across 300+ curated models (DeepSeek, FLUX, Kling, Qwen…).<br>\n    With the <a href=\"https://anyquery.dev/integrations/atlascloud\">Anyquery plugin</a>, you can call all of them directly from SQL.\n  </sub>\n</p>\n\n---\n\nAnyquery is a SQL query engine that allows you to run SQL queries on pretty much anything. It supports querying [files](https://anyquery.dev/docs/usage/querying-files/), [databases](https://anyquery.dev/docs/database), and [apps](https://anyquery.dev/integrations) (e.g. Apple Notes, Notion, Chrome, Todoist, etc.). It's built on top of [SQLite](https://www.sqlite.org) and uses [plugins](https://anyquery.dev/integrations) to extend its functionality.\n\nIt can also connect to [LLMs](https://anyquery.dev/llm) (e.g. ChatGPT, Claude, Cursor, TypingMind, etc.) to allow them to access your data.\n\nFinally, it can act as a [MySQL server](https://anyquery.dev/docs/usage/mysql-server/), allowing you to run SQL queries from your favorite MySQL-compatible client (e.g. [TablePlus](https://anyquery.dev/connection-guide/tableplus/), [Metabase](https://anyquery.dev/connection-guide/metabase/), etc.).\n\n\n\n![Anyquery header](https://anyquery.dev/images/release-header.png)\n\n\n\n## Usage\n\n### Connecting LLM\n\nLLMs can connect to Anyquery using the [Model Context Protocol (MCP)](https://anyquery.dev/docs/reference/commands/anyquery_mcp). This protocol provides context for LLMs that support it. You can start the MCP server with the following command:\n\n```bash\n# To be started by the LLM client\nanyquery mcp --stdio\n# To connect using an HTTP and SSE tunnel\nanyquery mcp --host 127.0.0.1 --port 8070\n```\n\nYou can also connect to clients that supports function calling (e.g. ChatGPT, TypingMind). Refer to each [connection guide](https://anyquery.dev/integrations#llm) in the documentation for more information.\n\n```bash\n# Copy the ID returned by the command, and paste it in the LLM client (e.g. ChatGPT, TypingMind)\nanyquery gpt\n```\n\n![5ire example](https://anyquery.dev/images/docs/llm/5ire-final.png)\n\n### Running SQL queries\n\nThe [documentation](https://anyquery.dev/docs/usage/running-queries) provides detailed instructions on how to run queries with Anyquery.\nBut let's see a quick example. Type `anyquery` in your terminal to open the shell mode. Then, run the following query:\n\n![Anyquery SQL examples](https://anyquery.dev/images/anyquery_examples.sql.png)\n\nYou can also launch the MySQL server with `anyquery server` and connect to it with your favorite MySQL-compatible client.\n\n```bash\nanyquery server &\nmysql -u root -h 127.0.0.1 -P 8070\n```\n\n## Installation\n\nThe [documentation](https://anyquery.dev/docs/#installation) provides detailed instructions on how to install Anyquery on your system. You can install anyquery from Homebrew, APT, YUM/DNF, Scoop, Winget and Chocolatey. You can also download the binary from the [releases page](https://github.com/julien040/anyquery/releases).\n\n### Quick install (macOS & Linux)\n\nThe fastest way to get started. This downloads the right binary for your platform, verifies its checksum, and adds it to your `PATH` — no `sudo` required:\n\n```bash\ncurl -fsSL https://anyquery.dev/install.sh | sh\n```\n\nTo pin a version or install elsewhere, set `ANYQUERY_VERSION` (e.g. `0.4.5`) or `ANYQUERY_INSTALL_DIR`. To update later, re-run the same command. On Windows, use Scoop, Winget, or Chocolatey (below).\n\n### Homebrew\n\n```zsh\nbrew install anyquery\n```\n<!-- \n### Snap\n\n```bash\nsudo snap install anyquery\n``` -->\n### ARCH LINUX (AUR)\n\n```bash\n# Install using an AUR helper like yay\nyay -S anyquery-git\n\n# paru\nparu -S anyquery-git\n```\n\n### APT\n\n```bash\necho \"deb [trusted=yes] https://apt.julienc.me/ /\" | sudo tee /etc/apt/sources.list.d/anyquery.list\nsudo apt update\nsudo apt install anyquery\n```\n\n### YUM/DNF\n\n```bash\necho \"[anyquery]\nname=Anyquery\nbaseurl=https://yum.julienc.me/\nenabled=1\ngpgcheck=0\" | sudo tee /etc/yum.repos.d/anyquery.repo\nsudo dnf install anyquery\n```\n\n### Scoop\n\n```powershell\nscoop bucket add anyquery https://github.com/julien040/anyquery-scoop\nscoop install anyquery\n```\n\n### Winget\n\n```powershell\nwinget install JulienCagniart.anyquery\n```\n\n### Chocolatey\n\n```powershell\nchoco install anyquery\n```\n\n### Go install\n\nRequires Go 1.26+ (some dependencies don't support older versions).\n\n```bash\nCGO_ENABLED=1 go install -tags \"vtable fts5 sqlite_json sqlite_math_functions\" github.com/julien040/anyquery@main\n```\n\nAnyquery relies on cgo (through go-sqlite3), so you need a C compiler (gcc, clang, or a mingw toolchain on Windows) available in your `PATH`.\n\n## Plugins\n\nAnyquery is plugin-based, and you can install plugins to extend its functionality. You can install plugins from the [official registry](https://anyquery.dev/integrations) or create your own. Anyquery can also [load any SQLite extension](https://anyquery.dev/docs/usage/plugins#using-sqlite-extensions).\n\n![Integrations](https://anyquery.dev/images/integrations_logo.png)\n\n## Sponsors\n\nAnyquery is an independent open-source project. These companies support its development:\n\n<a href=\"https://www.atlascloud.ai/?utm_source=github&utm_medium=link&utm_campaign=anyquery\">\n  <picture>\n    <source media=\"(prefers-color-scheme: dark)\" srcset=\"https://cdn.julienc.me/share/atlas-cloud-logo-white.svg\">\n    <img src=\"https://cdn.julienc.me/share/atlas-cloud-logo-black.svg\" alt=\"Atlas Cloud\" width=\"220\">\n  </picture>\n</a>\n\n### Want your logo here?\n\nAnyquery is built and maintained by one person. Sponsoring keeps it free and open-source, and puts your logo in this README and on [anyquery.dev](https://anyquery.dev/#sponsors).\n\n[Become a sponsor](https://github.com/sponsors/julien040/)\n\n## License\n\nAnyquery is licensed under the AGPLv3 license for the core engine. The RPC library is licensed under the MIT license so that anyone can reuse plugins in different projects.\n\nThe plugins are not subject to the AGPL license. Each plugins has its own license and the copyright is owned by the plugin author.\nSee the [LICENSE](https://github.com/julien040/anquery/blob/main/LICENSE.md) file for more information.\n\n## Contributing\n\nIf you want to contribute to Anyquery, please read the [contributing guidelines](https://anyquery.dev/docs/developers/project/contributing). I currently only accept minor contributions, but I'm open to any suggestions or feedback.\n\nYou can have a brief overview of the project in the [architecture](https://anyquery.dev/docs/developers/project/architecture/) documentation.\n","default_branch":"main","files":1332,"tree":[".github/FUNDING.yml",".gitignore",".goreleaser.yaml",".ignore",".vscode/settings.json","CODE_OF_CONDUCT.md","LICENSE.md","README.md","SECURITY.md","_examples/datasette/metadata.json","_examples/drizzle/.gitignore","_examples/drizzle/drizzle.config.js","_examples/drizzle/package-lock.json","_examples/drizzle/package.json","_examples/drizzle/print.ts","cmd/alias.go","cmd/connection.go","cmd/helper.go","cmd/llm.go","cmd/plugins.go","cmd/profiles.go","cmd/query.go","cmd/registry.go","cmd/root.go","cmd/run.go","cmd/server.go","cmd/tool.go","controller/alias.go","controller/config/database.go","controller/config/migrations.go","controller/config/model/db.go","controller/config/model/models.go","controller/config/model/query.sql.go","controller/config/query.sql","controller/config/registry/plugin.go","controller/config/registry/registry.go","controller/config/registry/registry_test.go","controller/config/registry/schema_plugin.json","controller/config/registry/schema_registry.json","controller/config/registry/structs.go","controller/config/schema.sql","controller/config/sqlc.yml","controller/connection.go","controller/controller.go","controller/dev.go","controller/helper.go","controller/input.go","controller/llm.go","controller/middleware.go","controller/middleware_test.go","controller/output.go","controller/output_test.go","controller/plugins.go","controller/profiles.go","controller/query.go","controller/registry.go","controller/run.go","controller/run_test.go","controller/sandbox.go","controller/sandbox_test.go","controller/server.go","controller/server_test.go","controller/shell.go","controller/shell_test.go","controller/tool.go","controller/update_check.go","controller/update_check_test.go","go.mod","go.sum","main.go","makefile","module/cassandra.go","module/clickhouse.go","module/db_helper.go","module/db_helper_test.go","module/duckdb.go","module/fetch.go","module/fetch_test.go","module/helper.go","module/helper_test.go","module/localfile.go","module/localfile_test.go","module/module.go","module/module.go.example","module/module_test.go","module/mysql.go","module/postgres.go","module/read_csv.go","module/read_csv_sniff.go","module/read_csv_sniff_test.go","module/read_csv_test.go","module/read_file.go","module/read_file_test.go","module/read_html.go","module/read_html_test.go","module/read_json.go","module/read_json_test.go","module/read_jsonl.go","module/read_jsonl_test.go","module/read_log.go","module/read_parquet.go","module/read_parquet_test.go","module/read_toml.go","module/read_toml_test.go","module/read_yaml.go","module/read_yaml_test.go","module/restrictions.go","module/restrictions_test.go","module/source.go","module/source_rewrite.go","module/source_test.go","module/stdin_sandbox_test.go","module/template.grok","namespace/collations.go","namespace/connections.go","namespace/crypto_function.go","namespace/date_functions.go","namespace/dev_manifest.json","namespace/dev_mode_sandbox_test.go","namespace/developer.go","namespace/developer_test.go","namespace/helper.go","namespace/json_functions.go","namespace/mysql.go","namespace/mysql_handler.go","namespace/mysql_handler_test.go","namespace/mysql_information_schema.go","namespace/mysql_rewriter.go","namespace/mysql_rewriter_test.go","namespace/mysql_test.go","namespace/namespace.go","namespace/namespace_test.go","namespace/other_functions.go","namespace/sandbox_findings_test.go","namespace/sandbox_followup_test.go","namespace/sandbox_mysql_test.go","namespace/sandbox_test.go","namespace/strings_functions.go","namespace/url_functions.go","orbstack_go_win.sh","other/duckdb/LICENSE.md","other/duckdb/README.md","other/duckdb/query.go","other/integrations/.gitignore","other/llm/chatgpt-instructions-id.txt","other/llm/chatgpt-instructions.txt","other/llm/lobechat.json","other/llm/openapi-actions.json","other/llm/openapi-actions.yaml","other/llm/openapi.yaml","other/llm/openwebui.json","other/llm/openwebui.py","other/llm/typingmind.json","other/llm/typingmind_function.js","other/prql/prql.go","other/prql/types.go","other/sqlparser/README.md","other/sqlparser/analyzer.go","other/sqlparser/analyzer_test.go","other/sqlparser/ast.go","other/sqlparser/ast_clone.go","other/sqlparser/ast_copy_on_rewrite.go","other/sqlparser/ast_copy_on_rewrite_test.go","other/sqlparser/ast_equals.go","other/sqlparser/ast_format.go","other/sqlparser/ast_format_fast.go","other/sqlparser/ast_funcs.go","other/sqlparser/ast_funcs_test.go","other/sqlparser/ast_rewrite.go","other/sqlparser/ast_rewriting.go","other/sqlparser/ast_visit.go","other/sqlparser/bind_var_needs.go","other/sqlparser/cached_size.go","other/sqlparser/comments.go","other/sqlparser/comments_test.go","other/sqlparser/compile.sh","other/sqlparser/constants.go","other/sqlparser/cow.go","other/sqlparser/encodable.go","other/sqlparser/encodable_test.go","other/sqlparser/generate.go","other/sqlparser/goyacc/goyacc.go","other/sqlparser/impossible_query.go","other/sqlparser/keywords.go","other/sqlparser/keywords_test.go","other/sqlparser/like_filter.go","other/sqlparser/like_filter_test.go","other/sqlparser/literal.go","other/sqlparser/normalizer.go","other/sqlparser/parse_table.go","other/sqlparser/parse_table_test.go","other/sqlparser/parsed_query.go","other/sqlparser/parsed_query_test.go","other/sqlparser/parser.go","other/sqlparser/parser_test.go","other/sqlparser/parsing_test.go","other/sqlparser/precedence.go","other/sqlparser/precedence_test.go","other/sqlparser/predicate_rewriting.go","other/sqlparser/predicate_rewriting_test.go","other/sqlparser/random_expr.go","other/sqlparser/redact_query.go","other/sqlparser/redact_query_test.go","other/sqlparser/reserved_vars.go","other/sqlparser/rewriter_api.go","other/sqlparser/rewriter_test.go","other/sqlparser/sql.go","other/sqlparser/sql.y","other/sqlparser/testdata/mysql_keywords.txt","other/sqlparser/token.go","other/sqlparser/token_test.go","other/sqlparser/tracked_buffer.go","other/sqlparser/tracked_buffer_test.go","other/sqlparser/truncate_query.go","other/sqlparser/truncate_query_test.go","other/sqlparser/utils.go","other/sqlparser/utils_test.go","other/sqlparser/version_test.go","other/sqlparser/walker_test.go","other/sqlparser/y.output","other/websocket_tunnel/client/client.go","other/websocket_tunnel/client/create.go","other/websocket_tunnel/server/Caddyfile","other/websocket_tunnel/server/controller.go","other/websocket_tunnel/server/database.go","other/websocket_tunnel/server/go.mod","other/websocket_tunnel/server/go.sum","other/websocket_tunnel/server/main.go","other/websocket_tunnel/server/makefile","other/websocket_tunnel/server/redirect_oauth.html","other/websocket_tunnel/server/schema.sql","other/websocket_tunnel/server/security_test.go","other/websocket_tunnel/server/server.go","other/websocket_tunnel/server/websocket.go","plugins/airtable/.gitignore","plugins/airtable/.goreleaser.yaml","plugins/airtable/Makefile","plugins/airtable/README.md","plugins/airtable/go.mod","plugins/airtable/go.sum","plugins/airtable/main.go","plugins/airtable/manifest.toml","plugins/airtable/marshal.go","plugins/airtable/table.go","plugins/airtable/types.go","plugins/airtable/unmarshal.go","plugins/asana/.gitignore","plugins/asana/.goreleaser.yaml","plugins/asana/Makefile","plugins/asana/README.md","plugins/asana/asana_client.go","plugins/asana/go.mod","plugins/asana/go.sum","plugins/asana/goals.go","plugins/asana/main.go","plugins/asana/manifest.toml","plugins/asana/projects.go","plugins/asana/tasks.go","plugins/asana/workspaces.go","plugins/atlascloud/.gitignore","plugins/atlascloud/.goreleaser.yaml","plugins/atlascloud/Makefile","plugins/atlascloud/README.md","plugins/atlascloud/client.go","plugins/atlascloud/client_test.go","plugins/atlascloud/go.mod","plugins/atlascloud/go.sum","plugins/atlascloud/image.go","plugins/atlascloud/jobstore.go","plugins/atlascloud/jobstore_test.go","plugins/atlascloud/llm.go","plugins/atlascloud/main.go","plugins/atlascloud/manifest.toml","plugins/atlascloud/memo.go","plugins/atlascloud/models.go","plugins/atlascloud/predictions.go","plugins/atlascloud/video_jobs.go","plugins/brave/.gitignore","plugins/brave/.goreleaser.yaml","plugins/brave/Makefile","plugins/brave/README.md","plugins/brave/go.mod","plugins/brave/go.sum","plugins/brave/main.go","plugins/brave/manifest.toml","plugins/brave/scripts/deleteTab.js","plugins/brave/scripts/listTabs.js","plugins/brave/scripts/newTab.applescript","plugins/brave/scripts/setURL.js","plugins/brave/tabs.go","plugins/calendar/.gitignore","plugins/calendar/.goreleaser.yaml","plugins/calendar/Makefile","plugins/calendar/README.md","plugins/calendar/go.mod","plugins/calendar/go.sum","plugins/calendar/icalendar.go","plugins/calendar/main.go","plugins/calendar/manifest.toml","plugins/carddav/.gitignore","plugins/carddav/.goreleaser.yaml","plugins/carddav/Makefile","plugins/carddav/README.md","plugins/carddav/address_book.go","plugins/carddav/address_book_test.go","plugins/carddav/carddav.go","plugins/carddav/carddav_test.go","plugins/carddav/contacts.go","plugins/carddav/contacts_test.go","plugins/carddav/go.mod","plugins/carddav/go.sum","plugins/carddav/main.go","plugins/carddav/manifest.toml","plugins/carddav/test.sh","plugins/chrome/.gitignore","plugins/chrome/.goreleaser.yaml","plugins/chrome/Makefile","plugins/chrome/README.md","plugins/chrome/downloads.go","plugins/chrome/go.mod","plugins/chrome/go.sum","plugins/chrome/history.go","plugins/chrome/main.go","plugins/chrome/manifest.toml","plugins/chrome/scripts/deleteTab.js","plugins/chrome/scripts/listTabs.js","plugins/chrome/scripts/newTab.applescript","plugins/chrome/scripts/setURL.js","plugins/chrome/tabs.go","plugins/click_up/.gitignore","plugins/click_up/.goreleaser.yaml","plugins/click_up/Makefile","plugins/click_up/README.md","plugins/click_up/docs.go","plugins/click_up/docs_pages.go","plugins/click_up/folders.go","plugins/click_up/go.mod","plugins/click_up/go.sum","plugins/click_up/lists.go","plugins/click_up/main.go","plugins/click_up/manifest.toml","plugins/click_up/tasks.go","plugins/click_up/types.go","plugins/click_up/whoami.go","plugins/coda/.gitignore","plugins/coda/.goreleaser.yaml","plugins/coda/Makefile","plugins/coda/README.md","plugins/coda/coda.go","plugins/coda/go.mod","plugins/coda/go.sum","plugins/coda/main.go","plugins/coda/manifest.toml","plugins/coda/types.go","plugins/discord/.gitignore","plugins/discord/.goreleaser.yaml","plugins/discord/Makefile","plugins/discord/README.md","plugins/discord/bans.go","plugins/discord/channels.go","plugins/discord/go.mod","plugins/discord/go.sum","plugins/discord/guilds.go","plugins/discord/invites.go","plugins/discord/main.go","plugins/discord/manifest.toml","plugins/discord/members.go","plugins/discord/messages.go","plugins/discord/roles.go","plugins/discord/utils.go","plugins/docker/.gitignore","plugins/docker/.goreleaser.yaml","plugins/docker/Makefile","plugins/docker/README.md","plugins/docker/container.go","plugins/docker/containers.go","plugins/docker/go.mod","plugins/docker/go.sum","plugins/docker/images.go","plugins/docker/main.go","plugins/docker/manifest.toml","plugins/docker/networks.go","plugins/edge/.gitignore","plugins/edge/.goreleaser.yaml","plugins/edge/Makefile","plugins/edge/README.md","plugins/edge/downloads.go","plugins/edge/go.mod","plugins/edge/go.sum","plugins/edge/history.go","plugins/edge/main.go","plugins/edge/manifest.toml","plugins/edge/scripts/deleteTab.js","plugins/edge/scripts/listTabs.js","plugins/edge/scripts/newTab.applescript","plugins/edge/scripts/setURL.js","plugins/edge/tabs.go","plugins/file/.gitignore","plugins/file/.goreleaser.yaml","plugins/file/Makefile"],"storefront":"/r/julien040","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/julien040/anyquery/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}