AIAny
Icon for item

Anyquery

Runs SQL queries against 40+ data sources — local files, databases, and apps like Notion, GitHub, and Google — through one SQLite-based engine. Doubles as an MCP server, so LLMs like Claude or ChatGPT can query that data directly via SQL.

Introduction

The hardest part of working with scattered data usually isn't the analysis — it's the dozen different APIs, auth flows, and export formats you cross before you can even start. Anyquery collapses that step: it speaks one language, SQL, to everything from a CSV on disk to your Notion workspace, and it does so by reusing SQLite's mature query planner rather than reinventing one.

What Sets It Apart
  • One SQL dialect over 40+ sources via a plugin registry, so joining a local Parquet file against a GitHub repo's issues is a single query, not a pipeline.
  • It exposes itself as a Model Context Protocol server, which means an LLM agent can read your Notion, Todoist, or files through structured SQL calls instead of brittle scraping — the data stays queryable, not just dumped into a prompt.
  • It also masquerades as a MySQL server, so existing BI tools and database clients connect to it with zero new drivers.
  • Built on SQLite, it inherits a proven engine and full SQL semantics (joins, aggregates, window functions) rather than a limited query subset.
Who It's For

Great fit if you live in SQL and want one tool to interrogate personal apps, local files, and APIs — or if you're wiring an LLM to private data and want it asking precise questions instead of guessing. Look elsewhere if your data already sits in one warehouse where native SQL is faster, or if you need heavy analytical workloads: this is an integration and exploration layer, not a high-throughput OLAP database. As a solo-maintained AGPLv3 project, the long tail of integrations also varies in depth.

Information

  • Websitegithub.com
  • OrganizationsJulien Cagniart
  • AuthorsJulien Dubois
  • Published date2024/08/06

Categories

More Items

GitHub
AI Client2025

Turns Chromium into a local-first AI browser with an embedded assistant that can summarise pages, extract structured data, automate web tasks, and run scheduled agents. Built as an open-source Chromium fork with 53+ built-in browser tools, 40+ app integrations, and support for BYO AI keys or fully local models (Ollama / LM Studio).

GitHub

Runs a self-hosted meeting bot and transcription API that joins Google Meet, Teams and Zoom and streams speaker-attributed transcripts in real time. Compiles meetings into a git-backed Markdown workspace and runs sandboxed agents on your infrastructure; Apache-2.0 and air-gap capable.

GitHub

Lets AI agents produce expressive, polished charts from compact, human-editable semantic specs; the compiler infers layout, scales, and labels and emits Vega-Lite, ECharts, or Chart.js outputs, with an MCP server for agent-driven chart creation and rendering.