● 커뮤니티 julien040 ⚡ 바로 사용

Anyquery

Name: Anyquery MCP Server
Author: julien040

Query 40+ apps (GitHub, Notion, Slack, ...) with SQL via MCP.

Anyquery is a SQL query engine that talks to 40+ SaaS apps (GitHub, Notion, Slack, Airtable, Linear) and local files (CSV, JSON, Parquet). Through MCP it exposes those tables to Claude, so an LLM can ask cross-source questions in plain SQL without writing per-API glue.

▶ 데모 보기 📦 설치 💡 사용 사례

왜 쓰나요

핵심 기능

40+ pre-built data sources covering GitHub, Notion, Linear, Airtable, Slack, calendar, Spotify
Local file query (CSV, Parquet, JSON, log files) via SQLite virtual tables
Single binary, single MCP endpoint — Claude sees one SQL schema across all sources
Pluggable connector architecture — write your own with a small Go/TS plugin
Compatible with the MySQL wire protocol for ad-hoc psql-style use

라이브 데모

실제 사용 모습

anyquery-mcp.replay ▶ 준비됨

0/0

설치

클라이언트 선택

~/Library/Application Support/Claude/claude_desktop_config.json · Windows: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "anyquery-mcp": {
      "command": "anyquery",
      "args": [
        "mcp"
      ]
    }
  }
}

Claude Desktop → Settings → Developer → Edit Config 열기. 저장 후 앱 재시작.

~/.cursor/mcp.json · .cursor/mcp.json

{
  "mcpServers": {
    "anyquery-mcp": {
      "command": "anyquery",
      "args": [
        "mcp"
      ]
    }
  }
}

Cursor는 Claude Desktop과 동일한 mcpServers 스키마 사용. 프로젝트 설정이 전역보다 우선.

VS Code → Cline → MCP Servers → Edit

{
  "mcpServers": {
    "anyquery-mcp": {
      "command": "anyquery",
      "args": [
        "mcp"
      ]
    }
  }
}

Cline 사이드바의 MCP Servers 아이콘 클릭 후 "Edit Configuration" 선택.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "anyquery-mcp": {
      "command": "anyquery",
      "args": [
        "mcp"
      ]
    }
  }
}

Claude Desktop과 같은 형식. Windsurf 재시작 후 적용.

~/.continue/config.json

{
  "mcpServers": [
    {
      "name": "anyquery-mcp",
      "command": "anyquery",
      "args": [
        "mcp"
      ]
    }
  ]
}

Continue는 맵이 아닌 서버 오브젝트 배열 사용.

~/.config/zed/settings.json

{
  "context_servers": {
    "anyquery-mcp": {
      "command": {
        "path": "anyquery",
        "args": [
          "mcp"
        ]
      }
    }
  }
}

context_servers에 추가. 저장 시 Zed가 핫 리로드.

claude mcp add anyquery-mcp -- anyquery mcp

한 줄 명령. claude mcp list로 확인, claude mcp remove로 제거.

사용 사례

실전 활용법: Anyquery

Generate a weekly status report joining GitHub PRs and Linear tickets

👤 Engineering leads ⏱ ~15 min intermediate

언제 쓸까: You want one summary across multiple SaaS tools without writing API code.

사전 조건

Server/skill installed and authenticated — See repo README

흐름

List the connected tables

Show me every table anyquery has, grouped by source app.✓ 복사됨

→ Tables grouped by github/linear/slack/...
Write the join

For PRs merged this week in org acme/, find the matching Linear ticket by branch name and tell me which tickets shipped.✓ 복사됨

→ A SQL JOIN between github_pulls and linear_issues with shipped tickets

결과: A one-shot status digest you can paste into Slack.

함정

Tables only have data for connected accounts — Tables only have data for connected accounts — run anyquery plugin install <name> and authenticate before querying.

함께 쓰기: github · linear · notion

조합

다른 MCP와 조합해 10배 효율

anyquery-mcp + github

Pair with github for complementary capabilities

Use this server together with github to complete a multi-step task.✓ 복사됨

anyquery-mcp + linear

Pair with linear for complementary capabilities

Use this server together with linear to complete a multi-step task.✓ 복사됨

도구

이 MCP가 노출하는 것

도구	입력	언제 호출	비용
list_tables	(none)	Discover which app/file tables are available before querying	free
describe_table	name: str	Inspect columns of a specific table	free
execute_query	sql: str	Run a SELECT across one or more sources	Underlying SaaS API quota

비용 및 제한

운영 비용

API 쿼터: See provider docs for rate limits
호출당 토큰: Varies by tool
금액: See repo README for pricing details
팁: Cache tool results and avoid repeated identical calls.

보안

권한, 시크릿, 파급범위

자격 증명 저장: Use environment variables; never commit secrets

데이터 외부 송신: Tool calls go to the provider's API as documented

문제 해결

자주 발생하는 오류와 해결

table 'github_pulls' does not exist

Install and authenticate the GitHub plugin: anyquery plugin install github && anyquery plugin login github

확인: Run list_tables and confirm github_pulls is present

rate limited by upstream API

Anyquery passes through the source's rate limit — add LIMIT and avoid SELECT * across millions of rows

확인: Try a small LIMIT 10 query

대안

Anyquery 다른 것과 비교

대안	언제 쓰나	단점/장점
MindsDB	You want federated ML/analytics, not just SQL access	Heavier — full DB platform vs single binary