# julien040/anyquery

One SQL interface for 60+ tools (e.g., GitHub, Notion, Airtable). Plug into any LLM through MCP.

Repository: https://github.com/julien040/anyquery
Canonical: https://ross.abutalabs.com/products/anyquery
Homepage: https://anyquery.dev
Language: Go
License: NOASSERTION
License Family: other
Topics: api, business-intelligence, csv, data-visualization, database, json, mysql, parquet, sql, sqlite, analytics, go, github, notion, salesforce, ai, chatgpt, llm, mcp
Last push: 2026-08-16T07:37:47+00:00

## Health v2 (maintenance only)
Score: 86/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 98, release rhythm 84, longevity 62
- inputs: {"age_days": 879, "days_push": 17, "days_rel": 28, "gap_med": 44.0, "n_releases_24m": 13}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1768, forks 132 (observed 2026-08-28T04:05:33.642292+00:00)

## What it is
Anyquery is a SQL query engine built on SQLite that turns 60+ tools, APIs, and file formats (GitHub, Notion, Airtable, CSV, Parquet, etc.) into queryable tables from a single binary. It also acts as an MCP server and MySQL server, letting LLMs and BI tools query your data with plain SQL or natural language.

## Use cases
- query github issues with sql
- query notion database from sql
- connect claude to my data via mcp
- join csv and api data in one query
- connect metabase or tableau to my apps
- query parquet files from the command line
- let chatgpt access my spotify history
- export sql query results to csv or json

## When to choose
- you want one SQL dialect across many SaaS apps, local apps, and files
- you want to give LLMs (Claude, ChatGPT, Cursor) SQL access to your data via MCP
- you want BI tools like Metabase or Tableau to query app data without ETL
- you prefer a local-first tool where API tokens never leave your machine

## When to avoid
- you need high-performance analytics over massive datasets
- you need a fully hosted/cloud solution rather than a local binary
- you rely on unsupported database features like Notion rollup properties
- your data source has no existing plugin and you can't write Go

## Facets
- artifact type: cli-tool
- maturity: active
- function: database, mcp, plugin-system, data-visualization, cli, search-engine
- domain: databases, developer-tools, data-science, analytics, large-language-models
- platform: windows, cli, go, cross-platform
- tags: sql-query-engine, sqlite, mysql-wire-protocol, mcp-server, bi-tools, federated-query, notion, github, airtable, parquet, csv, local-first, agpl, sql, automation, macos, linux

## Member repositories
- julien040/anyquery (main) score 86

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:33.642292+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:26:22.519223+00:00, confidence not recorded.
  - readme: https://github.com/julien040/anyquery (fetched 2026-08-28T04:05:33.642292+00:00, sha 90b8ff9ad7c2)
  - homepage: https://anyquery.dev (fetched 2026-08-29T11:04:43.850370+00:00, sha 1777c2d69d28)
  - site_page: https://anyquery.dev/docs (fetched 2026-08-29T11:04:43.861521+00:00, sha 84f776a9794f)
  - site_page: https://anyquery.dev/docs/usage/running-queries (fetched 2026-08-29T11:04:43.863275+00:00, sha 59882e42d1ae)
  - site_page: https://anyquery.dev/docs/usage/connecting-llms (fetched 2026-08-29T11:04:43.865289+00:00, sha dfe055dea614)
  - site_page: https://anyquery.dev/docs/usage/plugins (fetched 2026-08-29T11:04:43.867098+00:00, sha bb22c00b5b48)
  - site_page: https://anyquery.dev/docs/usage/exporting-results (fetched 2026-08-29T11:04:43.869265+00:00, sha 424bd8e07d1d)
  - site_page: https://anyquery.dev/docs/developers/plugins/create-plugin (fetched 2026-08-29T11:04:43.871027+00:00, sha 0179b7e6fc78)
  - site_page: https://anyquery.dev/integrations (fetched 2026-08-29T11:04:43.859512+00:00, sha 9d1aa578a56e)
  - site_page: https://anyquery.dev/integrations/notion (fetched 2026-08-29T11:04:43.873140+00:00, sha 6ca43a8dc80e)
- Data as of 2026-08-30T08:39:29.467469+00:00.