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
- Tags
- sql
- mcp
- query-engine
- sqlite
- mysql
- data-integration
- ai
- go
- analytics
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 Chat2DB, Dbx and Goose. SaaS products in the same category include DBCode, Valentina Studio and Querious.
- Is Anyquery actively maintained?
- Yes. The most recent commit to Anyquery was on 23 September 2026, and the latest release is 0.5.0, published on 5 August 2026. The project has 1.8k stars on GitHub.
Open-source alternatives to Anyquery
See all
Chat2DB
Database Tools
Chat2DB is a free, cross-platform, local-first database client and SQL workspace for devel
OSSvs DataGrip★ 28k
Dbx
Database Tools
25 MB lightweight cross-platform database client for 100+ databases, including MySQL, Post
Apache-2.0vs DataGrip★ 24k
Goose
Database Tools
A database migration tool. Supports SQL migrations and Go functions.
OSS★ 12k
Outerbase Studio
Database Tools
A lightweight Database GUI in your browser. It supports connecting to Postgres, MySQL, and
AGPL-3.0vs TablePlus★ 6k
DB Browser for SQLite
Database Tools
Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Dat
OSSvs TablePlus★ 25k
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
DBCode
Database Tools
VS Code extension for browsing and querying databases
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
SQLPro Studio
Database Tools
Database client for macOS, iOS and Windows supporting Postgres, MySQL, SQL Server and Oracle
SaaSSQLyog
Database Tools
MySQL and MariaDB GUI client for Windows with schema and data sync tools
SaaS
TablePlus
Database Tools
Native database client for PostgreSQL, MySQL, SQLite, Redis and more
SaaS

