anyquery  by julien040

SQL query engine for diverse data sources, accessible to LLMs

created 1 year ago
1,130 stars

Top 34.6% on sourcepulse

GitHubView on GitHub
Project Summary

Anyquery is a versatile SQL query engine designed to query diverse data sources, including files, databases, and applications like Notion and Apple Notes. It targets developers and power users seeking a unified interface for data access, leveraging LLMs and a MySQL-compatible server for enhanced functionality.

How It Works

Anyquery builds upon SQLite, utilizing a plugin architecture to integrate with various data sources and applications. It exposes data through SQL, enabling familiar querying methods. For LLM integration, it supports the Model Context Protocol (MCP) and function calling, allowing AI models to interact with and query user data. It can also function as a MySQL server, facilitating connections from standard SQL clients.

Quick Start & Requirements

  • Install via package managers (Homebrew, APT, YUM/DNF, Scoop, Winget, Chocolatey) or download binaries.
  • Example install: brew install anyquery
  • No specific hardware or OS requirements mentioned beyond standard system compatibility.
  • Documentation: https://github.com/julien040/anyquery

Highlighted Details

  • Queries over 40 data sources, including cloud services and local applications.
  • Connects LLMs (ChatGPT, Claude) via MCP and function calling for data access.
  • Acts as a MySQL server for compatibility with existing SQL clients.
  • Plugin-based architecture allows for extensibility and custom data source integration.

Maintenance & Community

  • Project appears to be primarily maintained by a single contributor (julien040).
  • Contribution guidelines are available, with an openness to suggestions and feedback.
  • No explicit community channels (Discord, Slack) or roadmap links are provided in the README.

Licensing & Compatibility

  • Core engine is AGPLv3 licensed.
  • RPC library is MIT licensed.
  • Plugins have their own licenses, with copyright held by plugin authors.
  • AGPLv3 may impose copyleft restrictions on derivative works, potentially impacting commercial or closed-source integration.

Limitations & Caveats

The AGPLv3 license for the core engine may require derived works to be open-sourced, which could be a concern for commercial or closed-source applications. The project's reliance on a single primary maintainer could indicate a higher bus factor.

Health Check
Last commit

2 weeks ago

Responsiveness

1 day

Pull Requests (30d)
0
Issues (30d)
2
Star History
351 stars in the last 90 days

Explore Similar Projects

Starred by Chip Huyen Chip Huyen(Author of AI Engineering, Designing Machine Learning Systems) and Travis Fischer Travis Fischer(Founder of Agentic).

teable by teableio

0.3%
19k
No-code Postgres alternative for database applications
created 2 years ago
updated 19 hours ago
Starred by Chip Huyen Chip Huyen(Author of AI Engineering, Designing Machine Learning Systems), Elie Bursztein Elie Bursztein(Cybersecurity Lead at Google DeepMind), and
7 more.

mindsdb by mindsdb

0.5%
35k
AI query engine for federated data sources
created 7 years ago
updated 1 day ago
Feedback? Help us improve.