pplyz

python + prompt + analyze

Add LLM-generated columns to a CSV with one command.

Requirements

• uv (Recommended)
• At least one LiteLLM-compatible API key (OpenAI, Gemini, Anthropic, etc.), or a local Ollama server (no API key needed)

uv is the easiest way to run the CLI.

Usage

Install

uv tool install pplyz

Example

pplyz test.csv \
  --input title,abstract \
  --output "relevant:bool,summary:str" \
  --model openai/gpt-4o-mini

This command sends the title and abstract columns to the LLM, adds relevant and summary columns to test.csv, and uses the openai/gpt-4o-mini model.

[!note] The CLI prompts you for a task description before processing unless --prompt or --prompt-file is provided. Output is written back to the input CSV file (overwrite).

Command arguments

Use -h or --help to list arguments.

pplyz -h

Configuration

1. Create the user config once:

mkdir -p ~/.config/pplyz
$EDITOR ~/.config/pplyz/config.toml

On Windows, use %APPDATA%\\pplyz\\config.toml.

2. Add only the providers you actually use:

[env]
OPENAI_API_KEY = "sk-..."
GROQ_API_KEY = "gsk-..."

[pplyz]
default_model = "openai/gpt-4o-mini"
default_input = "title,abstract"
default_output = "relevant:bool,summary:str"

Settings priority

pplyz loads settings in this order (earlier wins):

1. Existing environment variables
2. pplyz.local.toml in the project root (optional)
3. User config: ~/.config/pplyz/config.toml (or %APPDATA%\\pplyz\\config.toml on Windows; if XDG_CONFIG_HOME is set, it uses that)

To keep configs elsewhere, set PPLYZ_CONFIG_DIR=/path/to/dir and place config.toml there.

[env] table (API keys)

Set these inside the [env] table of your config.toml (or export them as environment variables):

[pplyz] table (Default settings)

Local models with Ollama

pplyz can run entirely offline against a local Ollama server — no API key required.

# 1. Start Ollama and pull a model
ollama serve            # usually already running
ollama pull llama3.1

# 2. Run pplyz against it (use the ollama_chat/ prefix)
pplyz test.csv \
  --input title,abstract \
  --output "relevant:bool,summary:str" \
  --model ollama_chat/llama3.1

Notes:

• Use the ollama_chat/ prefix (chat API); it handles system prompts better than ollama/.
• The default endpoint is http://localhost:11434. Override it with --api-base, the OLLAMA_API_BASE / PPLYZ_API_BASE env var, or default_api_base in config.toml.
• JSON output is enforced via Ollama's JSON mode. Local models follow schemas less reliably than hosted ones — prefer bool fields for decisions and test with --preview.
• --api-base also works for other OpenAI-compatible local servers (LM Studio, vLLM, …).

Supported models

For the latest list of supported models, see the LiteLLM provider docs: https://docs.litellm.ai/docs/providers