Metadata-Version: 2.4
Name: optihouse
Version: 0.1.0
Summary: Read-only ClickHouse cost & performance optimizer — local demo CLI
Project-URL: Homepage, https://optihouse.io
Project-URL: Documentation, https://optihouse.io/docs
Author: OptiHouse
License: MIT
Keywords: clickhouse,cost,database,finops,optimization,sql
Classifier: Development Status :: 4 - Beta
Classifier: Environment :: Console
Classifier: Intended Audience :: Developers
Classifier: Programming Language :: Python :: 3
Classifier: Topic :: Database
Requires-Python: >=3.8
Requires-Dist: rich>=13.0
Provides-Extra: clickhouse
Requires-Dist: clickhouse-driver>=0.2.6; extra == 'clickhouse'
Description-Content-Type: text/markdown

# OptiHouse — local demo CLI

Read-only **ClickHouse** cost & performance optimizer you run **on your own
machine**. Point it at a cluster and it reads `system.*` tables in read-only
mode, estimates where storage and compute money is leaking, and shows you the
top opportunities — **without connecting your cluster to any service**. Your
credentials and data never leave your machine.

The full analysis (every finding, the exact $ figure, and ready-to-apply SQL
fixes) lives at **https://optihouse.io**.

## Install

```bash
pip install optihouse
```

To scan a real cluster, also install the driver:

```bash
pip install "optihouse[clickhouse]"
```

## Try it in 10 seconds (no cluster needed)

```bash
optihouse scan --demo
```

Runs against a bundled synthetic cluster so you can see exactly what the tool
produces before pointing it at anything real.

## Scan your own cluster (read-only)

```bash
optihouse scan --host clickhouse.internal --user readonly --password '***'
# TLS:
optihouse scan --host ch.example.com --port 9440 --secure --user readonly --password '***'
```

Everything is `SELECT`-only against `system.*`. No writes, no agents, no data
rows read, nothing sent anywhere.

## What you get locally vs. on optihouse.io

| | Local demo CLI | optihouse.io (free account) |
|---|---|---|
| Cluster summary & opportunity count | ✅ | ✅ |
| Top 3 findings in full | ✅ | ✅ |
| Exact total $/month savings | masked | ✅ |
| Full ranked list of findings | top 3 only | ✅ all 40 advisors |
| Copy-paste ALTER/SELECT fixes | 🔒 | ✅ |
| Dashboard + before/after impact tracking | — | ✅ |

> Prefer a UI over the terminal? The same analysis runs in the browser at
> https://optihouse.io — connect a cluster (read-only) and see figures
> measured on your own data.

## Privacy

The CLI only issues read-only queries against ClickHouse system tables
(table sizes, part counts, column codecs, aggregated `query_log` patterns).
It does not read your data rows and does not transmit anything off the host.
