Aeo Python

Use when building a terminal user interface in Python - a Textual multi-pane dashboard, an IDE-style interface, a REPL shell, or an interactive line editor with completions and validation using Python Prompt Toolkit. Covers widget composition, containers, CSS styling, messages, key bindings, themes, command history, TUI testing with the Textual Pilot API and snapshot tests, MCP server access and sub-agent delegation from a TUI, version requirements, and WSL2 layout quirks. For full-screen Python terminal apps; for argument parsing and command-line UX, use python-cli-engineering.

Use when building or hardening a production-grade Python CLI tool, admin utility, data processor, or developer tooling - with UV for package management, Ruff for linting, Pyright for strict typing, Typer for commands, and Rich for polished output. Covers fail-fast patterns and custom exception hierarchies, modular code organization and module size limits, pydantic-settings configuration from YAML and .env, Makefile tasks and pre-commit checks, Rich progress bars, strict type-checking patterns, pytest structure for CLI commands, professional UX conventions, and building and installing the distribution. For command-line tools; for full-screen terminal UIs, use agent-tui-expert.

Use when implementing a data pipeline, ETL or ELT flow, or warehouse architecture in Python - SQLAlchemy 2.0 patterns such as TypeDecorator, hybrid properties and events, Pydantic integration, API-to-database flows, custom field schema evolution, incremental sync from an external system, or multi-source integration. Covers Kimball star schemas, medallion layers, slowly changing dimension handling, the dim_, fact_, and stg_ naming conventions, orchestration with dbt, Airflow, or Dagster, and testing a pipeline. Aimed at dimensional modeling with Python and PostgreSQL, not at BI tool configuration.