anyquery

Active
GitHub Go NOASSERTION

Description

anyquery is an MCP server that exposes 40+ data sources (GitHub, Notion, Slack, and more) as SQL tables so LLMs can query structured data directly.

Key Features

  • Unified SQL interface - query 40+ data sources (GitHub, Notion, Slack, Hacker News, and more) with standard SQL
  • Native MCP server - built-in MCP server mode so Claude, Cursor, and other agents query data via the protocol
  • Embedded SQLite engine - zero-dependency local execution with privacy-first data handling
  • Custom data source plugins - Go and JS plugin APIs let you wrap any HTTP API as a SQL table
  • Multiple client protocols - stdio MCP, MySQL/PostgreSQL wire-compatible server, and HTTP API in one binary
  • Flexible deployment - single static binary deployable as a local CLI or a remote service

Use Cases

💡 Let Claude and other LLMs query GitHub issues, PRs, and repo stats using familiar SQL
💡 Expose Notion databases or Slack history as MCP resources for agent retrieval
💡 Aggregate data across SaaS tools via SQL joins for cross-platform reports
💡 Bootstrap a SQLite + MCP data layer for local-first agent prototypes
💡 Deploy anyquery remotely as a shared MCP data gateway for the whole team

Categories

Quick Start

# One-line install on macOS / Linux
curl -fsSL https://get.anyquery.dev/install | sh

# Launch the MCP server (default stdio mode)
# once running, GitHub / Notion / etc. data sources are exposed as SQL tables
anyquery mcp

# Query GitHub issues directly with SQL
anyquery -q "SELECT title, state FROM github_my_issues LIMIT 5"

# Configure Claude Desktop to use anyquery
# claude_desktop_config.json
{
  "mcpServers": {
    "anyquery": {
      "command": "anyquery",
      "args": ["mcp"]
    }
  }
}

Related Projects