How PostgreSQL plan trees (PlannedStmt) are translated into MLIR RelAlg by PostgreSQLASTTranslator. Plan node coverage, expression translation dispatch, the TranslationContext, schema/type mapping. Use when adding plan node support, debugging "unsupported plan node type" errors, working on expression translation, or touching anything in src/pgx-lower/frontend/SQL/.
This listing is imported from SkillsMP metadata and should be treated as untrusted until upstream source review is completed.
Install skill "architecture-ast-translation" with this command: npx skills add zyros-dev/skillsmp-zyros-dev-zyros-dev-architecture-ast-translation
This source entry does not include full markdown content beyond metadata.
This detail page is rendered from real SKILL.md content. Trust labels are metadata-based hints, not a safety guarantee.
Related by shared tags or category signals.
End-to-end review-and-merge workflow for spec PRs in pgx-lower. Auto-invoke when the user says "merge spec NN", "review pending PRs", "merge ready PRs", or "review and merge". Spawns the spec-reviewer subagent for an independent review, handles rebase/conflict resolution, runs the merge, and updates the spec status board. The user only ever names the trigger — every other step is yours.
End-to-end playbook for implementing a feature or fix in pgx-lower. Auto-invoke when the user says "start spec NN", "implement spec NN", or asks for any code change that should end in a pull request. Covers spec claiming, worktree creation, TDD, build, static analysis, tests, benchmark, PR, and status-board upkeep. The user only ever says "start spec NN" — every other step is yours.
The LLVM JIT engine, optimization pipeline, ExecutionEngine lifecycle, MLIR→LLVM IR translation, and the per-query compile flow. Use when working on jit_execution_engine.cpp, LLVM passes, JIT compilation issues, ExecutionEngine ownership, function lookup, or symbol resolution.
The four MLIR dialects (RelAlg, DB, DSA, util) used by pgx-lower, their key types and ops, and the lowering pipeline (RelAlg → DB+DSA+Util → Standard → LLVM). Use when adding ops, debugging lowering passes, working on dialect types, touching anything in src/lingodb/mlir/, or wondering where a particular op lowers.