anyquery  by julien040

SQL query engine for diverse data sources, accessible to LLMs

Created 1 year ago
1,327 stars

Top 30.2% 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

1 month ago

Responsiveness

1 day

Pull Requests (30d)
0
Issues (30d)
3
Star History
66 stars in the last 30 days

Explore Similar Projects

Feedback? Help us improve.