# Sidequery

> Sidequery is a SQL analytics notebook for Mac that connects to AI coding agents (Claude Code, Gemini CLI) via ACP. Run DuckDB queries on local CSV/Parquet/JSON files, join against Postgres/MySQL/BigQuery/Snowflake, and visualize results with charts. Your data stays local by default.

## Who is Sidequery for?

- Data analysts who want AI assistance writing SQL queries
- Developers using Claude Code or Gemini CLI who need to query databases or analyze files
- Anyone doing analytics on CSV, Parquet, or JSON files without uploading to the cloud
- Teams needing federated joins across multiple databases and local files

## Key Capabilities

- **AI Agent Integration (BYOA)**: Works with Claude Code and Gemini CLI via ACP (Agent Communication Protocol). Use your existing AI subscription to write queries, build charts, and explore data.
- **Local-first Analytics**: Analyze millions of rows from CSV, Parquet, JSON files directly on your MacBook using DuckDB. No data leaves your machine unless you choose.
- **Federated Joins**: Query across Postgres, MySQL, Snowflake, BigQuery, and local files in a single SQL statement. Join a CSV against a production database table.
- **SQL Notebooks**: Organize queries and charts. Reference prior queries as tables (like one big CTE). Edit in your favorite text editor or IDE.
- **Beautiful Charts**: Transform query results into visualizations via code, UI, or AI agents.

## File Format

Sidequery uses `.sqlnb` - a plain SQL-based notebook format for dashboards and charts. Works with any text editor and degrades gracefully to standard SQL.

## Platform Support

- macOS Sequoia+: Native desktop app (primary)
- Windows/Linux: VS Code extension (coming soon)
- Browser: Coming soon

## Pricing

Free for desktop use. Team features coming soon.

## Docs

- [Homepage](https://sidequery.dev/): Product overview and waitlist
- [Blog](https://sidequery.dev/blog): Product updates on SQL notebooks and AI workflows
- [Open Source](https://sidequery.dev/oss): Sidemantic (semantic layer) and DuckDB extensions

## Optional

- [Alternatives](https://sidequery.dev/alternatives): Comparison with Jupyter, Hex, and BI tools
- [Sidequery Lite](https://lite.sidequery.dev): Legacy browser version