{"id":"e41caa42-dfc9-4687-ac73-5b012f577849","slug":"querora","kind":"mcp","name":"querora","summary":"Local-first conversational BI for macOS — ask your data in plain language, powered by your own CLI agents (Claude Code, Codex, pi). Tauri + Rust, Apache-2.0.","owner":"8ugustdev","repoUrl":"https://github.com/8ugustdev/querora","license":"Apache-2.0","licenseTier":"permissive","trust":"community","stars":1,"match":null,"fewStars":true,"format":"mcp","createdAt":"2026-08-16T02:48:50.000Z","addedAt":"2026-10-21T09:32:00.486Z","logoUrl":"https://avatars.githubusercontent.com/u/316536313?u=2e84a58b50ebe41dbe2d383167ef9951e88e777b&v=4","linkOnly":false,"collection":null,"skillPath":null,"categories":["databases","data-analytics","developer-tools"],"tags":["bi","claude-code","duckdb","llm-agents","mysql","postgres","rust","sqlite"],"runtime":"binary","local":true,"cloudCapable":false,"cloudCapability":"unknown","cloudReadyOnPlatform":false,"needsApiKey":false,"reviewed":false,"syncedAt":"2026-10-22T10:05:11.187Z","sample":false,"url":"https://conduits.dev/tools/querora","language":"Rust","transports":["stdio"],"install":{},"requirements":{"env":[],"upstreamMayCharge":false},"tools":null,"readme":"# Querora\n\nLocal-first conversational BI for macOS. Ask questions in natural language; the\nAI reasoning is done by **the CLI agent you already pay for** — Claude Code,\nCodex CLI, or pi — driven headlessly. Querora never requires an API key.\n\n```\nask → agent plans → validated IR → compiled SQL → chart + trust panel\n```\n\n- **BYO-agent, not BYO-key** — $0 marginal AI cost, zero AI onboarding\n- **No Cube, no server, no Docker** — single Tauri binary + SQLite + Keychain\n- **Human-reviewable semantic layer** — no blind text-to-SQL; the agent emits\n  IR, never SQL, and credentials never cross the agent boundary\n- **Dual mode** — Querora's MCP server is also usable from your own terminal\n  agent sessions\n\n## Dev quickstart\n\nRequirements: Rust 1.97+, Node 20+, pnpm 10, Xcode CLT (macOS).\n\n```sh\npnpm install\npnpm hooks:install        # optional: fmt + clippy pre-commit hook\npnpm tauri dev            # opens the app window\npnpm check                # typecheck + tests + frontend build\ncargo fmt --all && cargo clippy --workspace --all-targets -- -D warnings && cargo test --workspace\n```\n\n## Layout\n\n```\napps/desktop     Tauri v2 app (React/TS frontend + Rust shell)\napps/sidecar-pi  pi SDK sidecar (agent driver + BYOK provider host)\ncrates/contracts serde IR contracts — single source of truth (TS exports via ts-rs)\ncrates/core      storage · keyring · toolapi · connectors · compiler · semantic · agents\ncrates/mcp       querora-mcp — MCP stdio shim bridging Claude Code / Codex to the toolapi socket\n```\n\n## Security stance\n\n- Credentials live in the macOS Keychain, never in SQLite, never in agent context\n- Agents receive tool access + semantic context only; they emit IR, never SQL\n- The tool API is a token-authed unix socket at `~/.querora/run/querora.sock`\n\n## Roadmap\n\n**Now (v0.1 — beta)**\n- [x] Chat → validated IR → compiled SQL → chart, end-to-end, via your CLI agent\n- [x] BI primitives: metric arithmetic (margin %), period-over-period comparison, semi-join filters without fan-out\n- [x] Sources: SQLite, DuckDB (Parquet/CSV), PostgreSQL, MySQL — read-only guarded\n- [x] Semantic layer: heuristic drafts, FTS5 search, optional AI enrichment, immutable publish; Magento-style EAV schemas detected and unfolded\n- [x] Dual mode: Querora's MCP server in your own terminal agents (claude/codex)\n- [x] Trust panel: IR → SQL → params → row counts, CSV export\n- [ ] Notarized signed DMG (pending Apple signing secrets; unsigned beta builds available)\n- [ ] In-app consent flow for Codex unsandboxed mode (current codex requirement)\n\n**Next (v0.x)**\n- [ ] Semantic editor UI: hand-edit metrics/aliases/relationships, version history + diff\n- [ ] Dashboard views (saved answers, grid layout) — Pro candidate\n- [ ] More connectors: BigQuery, Snowflake, SQL Server\n- [ ] SSH tunnels for remote sources — Pro candidate\n- [ ] Windows/Linux builds (architecture keeps the seam; not yet wired)\n\n**Later (v1)**\n- [ ] BYOK mode: bring your own API key (pi custom-provider sidecar) — \"agent or key, your choice\"\n- [ ] Scheduled reports + alerts — Pro\n- [ ] Embedded-semantic search upgrades (vector search when catalog sizes demand)\n- [ ] Homebrew cask submission (recipe already in-repo)\n\nPro policy (locked): the Pro tier NEVER gates agent access, tool\nexecution, or query volume — it sells value-adds only (dashboards,\nscheduling, exports, tunnels).\n\n## License\n\n[Apache-2.0](LICENSE). See [NOTICE](NOTICE) for bundled third-party\ncomponents.\n"}