Metadata-Version: 2.4
Name: piper-cli
Version: 0.0.4
Summary: Piper is a coding agent for data teams.
License-Expression: BUSL-1.1
Keywords: data-engineering,ai,cli,sql,pipelines
Author: data-engineer-ai
Author-email: jay@data-engineer.ai
Requires-Python: >=3.12,<3.15
Classifier: Development Status :: 4 - Beta
Classifier: Environment :: Console
Classifier: Intended Audience :: Developers
Classifier: Topic :: Database
Classifier: Programming Language :: Python :: 3.12
Classifier: Programming Language :: Python :: 3.13
Classifier: Programming Language :: Python :: 3.14
Requires-Dist: clickhouse-driver (>=0.2.10,<0.3.0)
Requires-Dist: clickhouse-sqlalchemy (>=0.3.2,<0.4.0)
Requires-Dist: coolname (>=2.2.0,<3.0.0)
Requires-Dist: databricks-sql-connector (>=4.1.2,<5.0.0)
Requires-Dist: databricks-sqlalchemy (>=2.0.8,<3.0.0)
Requires-Dist: duckdb-engine (>=0.17.0,<0.18.0)
Requires-Dist: google-cloud-bigquery (>=3.40.0,<4.0.0)
Requires-Dist: google-cloud-bigquery-storage (>=2.36.0,<3.0.0)
Requires-Dist: grpcio (>=1.78.0,<2.0.0)
Requires-Dist: httpx (>=0.28.1,<1.0.0)
Requires-Dist: jinja2 (>=3.1.6,<4.0.0)
Requires-Dist: langchain (>=1.2.7,<2.0.0)
Requires-Dist: langchain-anthropic (>=1.3.0,<2.0.0)
Requires-Dist: langchain-core (>=1.0.0,<2.0.0)
Requires-Dist: langchain-google-genai (>=4.1.2,<5.0.0)
Requires-Dist: langchain-mcp-adapters (>=0.2.1,<0.3.0)
Requires-Dist: langchain-openai (>=0.3.28,<0.4.0)
Requires-Dist: matplotlib (>=3.10.8,<4.0.0)
Requires-Dist: pandas (>=2.3.3,<3.0.0)
Requires-Dist: prompt-toolkit (>=3.0.52,<4.0.0)
Requires-Dist: psycopg2-binary (>=2.9.11,<3.0.0)
Requires-Dist: python-dotenv (>=1.2.1,<2.0.0)
Requires-Dist: pyyaml (>=6.0.3,<7.0.0)
Requires-Dist: seaborn (>=0.13.2,<0.14.0)
Requires-Dist: snowflake-connector-python (>=3.17.3,<4.0.0)
Requires-Dist: snowflake-sqlalchemy (>=1.7.6,<2.0.0)
Requires-Dist: sqlalchemy-bigquery (>=1.16.0,<2.0.0)
Requires-Dist: sqlalchemy[asyncio] (>=2.0.43,<3.0.0)
Requires-Dist: sqlglot (>=27.4.1,<28.0.0)
Project-URL: Documentation, https://docs.data-engineer.ai
Project-URL: Homepage, https://data-engineer.ai
Project-URL: Repository, https://github.com/data-engineer-ai/piper-cli
Description-Content-Type: text/markdown

# Piper CLI

Coding agents for data engineers - write code, manage databases, connect to Airflow and more.

## Install

**Requirements:** macOS or Linux, Python 3.12, [ripgrep](https://github.com/BurntSushi/ripgrep):

```bash
brew install ripgrep          # macOS
sudo apt install ripgrep      # Ubuntu / Debian
```

You need a **Solo plan** subscription at [data-engineer.ai](https://data-engineer.ai).

```bash
pip install piper-cli
```

## Setup

Set at least one LLM API key:

```bash
export ANTHROPIC_API_KEY="sk-ant-..."
export OPENAI_API_KEY="sk-proj-..."
export GEMINI_API_KEY="...
```

Then run:

```bash
piper
```

## Configuration

Piper stores config in `~/.piper/`:

```
~/.piper/
├── charts/               # Generated charts and visualizations
├── mcp/
│   └── servers.json      # MCP server configurations
├── plans/                # Saved execution plans
├── projects/             # Project-specific context
├── skills/               # User-defined reusable skills
├── .env                  # Environment variables (API keys, credentials)
├── chats.db              # Conversation history (SQLite)
├── config.json           # User preferences (model)
├── credentials.json      # Auth credentials (managed by CLI)
└── databases.yaml        # Database connections (Jinja2 templated)
```

## Commands

`/help` `/model` `/database` `/mcp` `/chats` `/subagents` `/tokens` `/upgrade` `/clear` `/logout` `/exit`

## Links

[Docs](https://docs.data-engineer.ai) · [Pricing](https://data-engineer.ai/pricing) · [data-engineer.ai](https://data-engineer.ai)

