anyquery
If you are the rightful owner of anyquery and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcpreview.com.
Anyquery is a versatile SQL query engine that allows users to run SQL queries on various data sources, including files, databases, and applications, with support for LLMs and MySQL server functionality.
Anyquery is a powerful SQL query engine designed to execute SQL queries across a wide range of data sources, such as files, databases, and applications like Apple Notes, Notion, and Chrome. Built on SQLite, it extends its capabilities through plugins, enabling integration with numerous platforms. Anyquery also supports connections to Large Language Models (LLMs) like ChatGPT and Claude, allowing these models to access and query data. Additionally, it can function as a MySQL server, facilitating SQL queries from MySQL-compatible clients such as TablePlus and Metabase. The tool is highly extensible, with a plugin-based architecture that allows users to enhance its functionality further. Anyquery is available for installation via various package managers, including Homebrew, APT, YUM/DNF, Scoop, Winget, and Chocolatey.
Features
- Multi-source Querying: Execute SQL queries on files, databases, and applications.
- LLM Integration: Connects with LLMs like ChatGPT for data access and querying.
- MySQL Server Functionality: Acts as a MySQL server for MySQL-compatible clients.
- Plugin-based Architecture: Extend functionality with plugins and SQLite extensions.
- Cross-platform Installation: Available on multiple package managers for easy installation.
Usage with Different Platforms
Connecting LLM
# To be started by the LLM client
anyquery mcp --stdio
# To connect using an HTTP and SSE tunnel
anyquery mcp --host 127.0.0.1 --port 8070
Running SQL queries
anyquery server &
mysql -u root -h 127.0.0.1 -P 8070
Related MCP Servers
View all databases servers →gateway
by centralmind
CentralMind Gateway is a tool designed to expose databases to AI agents via MCP or OpenAPI protocols, providing secure, LLM-optimized APIs.
supabase-mcp
by supabase-community
Connect your Supabase projects to AI assistants using the Model Context Protocol (MCP) server.
mindsdb
by mindsdb
MindsDB is an open-source server that enables seamless interaction with large-scale federated data using the Model Context Protocol (MCP).
azure-mcp
by Azure
The Azure MCP Server implements the MCP specification to create a seamless connection between AI agents and Azure services.
genai-toolbox
by googleapis
MCP Toolbox for Databases is an open source MCP server for databases, designed to simplify and secure the development of database tools.
prisma
by prisma
Prisma is a next-generation ORM for Node.js and TypeScript, providing tools for data modeling, migrations, and querying databases.
mcp-notion-server
by suekou
MCP Server for the Notion API, enabling LLM to interact with Notion workspaces. Additionally, it employs Markdown conversion to reduce context size when communicating with LLMs, optimizing token usage and making interactions more efficient.