1---2name: "pixeltable"3description: "Build or operate applications with pixeltable/pixeltable, the Python multimodal database and `pxt` catalog CLI. Use for tables/views, computed columns and indexes, media ingestion/query workflows, schema reconciliation, local daemon/configuration, or Pixeltable Cloud/service operations. Distinguish its multimodal data model from ontology catalogs and Markdown knowledge graphs."4allowed-tools: Bash Read Grep Glob5metadata:6 version: 1.0.07 source: https://skillmd.com/skills/akillness/pixeltable8 upstream: https://github.com/pixeltable/pixeltable9 upstream_commit: ade3972b3ff88981bbac2e715638cccd1dee020510---1112# Pixeltable1314## Instructions15161. **Confirm Pixeltable is the target.** This is a multimodal database with Python APIs and a `pxt` CLI, not a knowledge-graph/ontology catalog. Pin repository-level claims to `references/source.json`, then inspect the project's installed version and checkout.172. **Classify the task:** local catalog/table/query, media or computed-column workflow, schema reconciliation, local daemon/config, or hosted Cloud/database/service operation. Read `references/upstream.md` for exact entry points and documented limits.183. **Start with inspection.** Prefer `pxt --help`, per-command help, `pxt health`, `pxt status`, `pxt ls`, `pxt describe`, `pxt columns`, and `pxt config` when authorized and available. `pxt` starts a local daemon on first catalog command in the pinned docs; do not start one without user approval.194. **Treat mutation and remote access as distinct.** Catalog operations include destructive `drop`, `drop-dir`, recompute, schema update/prune; cloud commands can manage databases, services, organizations, keys, and secrets. Use dry-run where supported, inspect target and impact, and get separate approval before apply.205. **Handle credentials safely.** Pixeltable can resolve environment/config/login settings; provider keys belong in secrets/configuration, not chat. Never print secret values. Hosted Cloud login, credentials, database operations, media upload, and provider calls need separate approval.216. **Respect project/config semantics.** `pxt init` writes project configuration and can amend `pyproject.toml`; it refuses some nested-root cases. Verify the selected working directory and existing project root before suggesting it.227. **Verify outcomes at the right layer.** A local config or CLI success does not prove Cloud deployment, remote persistence, correct computation, or media availability. The source preflight checks only selected hashes and never runtime behavior.2324## Examples2526- "Inspect a Pixeltable table and find why a computed column failed." → Start with health/status, table schema, errors/history, and column definition; avoid recompute until its scope is approved.27- "Initialize Pixeltable in this repo." → Inspect cwd and existing root/pyproject first; explain that `pxt init` writes config and ask before the mutation.28- "Create an ontology for a data catalog." → Route to ontology/catalog design; Pixeltable is not the catalog-modeling substitute.2930## Best practices3132- Use read-only catalog inspection before schema or data mutation; prefer `--dry-run` on supported mutations.33- Keep local database, hosted database URI, project configuration, environment variables, and Cloud login precedence explicit.34- Avoid embedding secrets or private media in diagnostic output; scope media destinations and external provider usage.35- Separate daemon health, local catalog state, hosted service state, and application endpoint health in reports.3637## References3839- [Pinned operations and configuration](references/upstream.md)40- [Pinned evidence and license](references/source.json)41- [Evaluation scenarios](evals/evals.json)42- [Offline source preflight](scripts/preflight.py)