About Anyquery
Anyquery is a SQL query engine built on top of SQLite that lets you run queries against almost any data source. Instead of writing separate scripts for each service, you use plugins to expose files, databases and applications such as Notion, GitHub, Airtable, Todoist or Chrome as tables you can select from, join and filter with ordinary SQL.
It can be used in several ways. A shell mode opens straight from the terminal, and an anyquery server command starts a MySQL-compatible server so tools like TablePlus or Metabase can connect to it. It also speaks the Model Context Protocol, which lets assistants such as ChatGPT, Claude or Cursor read your data, and clients that support function calling can connect too.
The tool is written in Go and distributed through common package managers including Homebrew, APT, YUM/DNF, Scoop, Winget and Chocolatey. It runs locally on your own machine, so queries and credentials stay under your control. It suits developers, analysts and anyone who wants one query layer across their scattered SaaS and file data.
Key features
- SQL queries over files, databases, and apps
- Plugin system for adding data sources
- MCP server for connecting AI assistants
- MySQL-compatible server mode
- Interactive shell from the terminal
- Packages for Homebrew, APT, Scoop, and more
Good fit for
- Joining data from several SaaS apps with SQL
- Giving an AI assistant access to your own data
- Querying CSV and JSON files without importing them
Anyquery: questions and answers
- What is Anyquery used for?
- Anyquery is a SQL query engine that lets you query files, databases and many apps from one interface, and exposes that data to AI assistants through MCP. It is a good fit for joining data from several SaaS apps with SQL, giving an AI assistant access to your own data, and querying CSV and JSON files without importing them.
- Is Anyquery open source?
- Yes. Anyquery is open source under a custom licence. Its source code is on GitHub at julien040/anyquery and is written mainly in Go.
- Is Anyquery free?
- Yes. Anyquery is open source, so the software itself is free to use under the terms of its own licence.
- What are some alternatives to Anyquery?
- Similar open-source tools in the Database Tools category include Dbx, Chat2DB and Goose. SaaS products in the same category include AI2sql, DBCode and ERDAuto.
- Is Anyquery actively maintained?
- Yes. The most recent commit to Anyquery was on 8 October 2026, and the latest release is 0.5.1, published on 8 October 2026. The project has 1.8k stars on GitHub, with 6 added in the last 30 days.
Open-source alternatives to Anyquery
See all
Dbx
Database Tools
25 MB lightweight cross-platform database client for 100+ databases, including MySQL, Post
Apache-2.0vs DataGrip★ 30k
Chat2DB
Database Tools
Chat2DB is a free, cross-platform, local-first database client and SQL workspace for devel
OSSvs DataGrip★ 28k
Goose
Database Tools
A database migration tool. Supports SQL migrations and Go functions.
OSS★ 12kAdminer
Database Tools
Database management in a single PHP file
OSSvs DataGrip★ 8k
Outerbase Studio
Database Tools
A lightweight Database GUI in your browser. It supports connecting to Postgres, MySQL, and
AGPL-3.0vs TablePlus★ 6k
Beekeeper Studio
Database Tools
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux
OSSvs DataGrip★ 24k
SaaS alternatives to Anyquery
See all
AI2sql
Database Tools
Turns plain-English requests into SQL for your schema, and fixes or explains existing queries
SaaS
DBCode
Database Tools
VS Code extension for browsing and querying databases
SaaS
ERDAuto
Database Tools
Describe a schema in plain English to generate ER diagrams, relational models and SQL exports
SaaS
Pluk
Database Tools
AI-native database client to query, explore and manage SQL and NoSQL databases in natural language
SaaSValentina Studio
Database Tools
Database administration and query tool with a free edition for several database engines
SaaS
Querious
Database Tools
MySQL and MariaDB database management app for macOS
SaaS

