Total Skills
9
Author Profile: zyros-dev
Skills published by zyros-dev with real stars/downloads and source-aware metadata.
Total Stars
0
Total Downloads
0
Skills Performance
Comparison chart based on real stars and downloads signals from source data.
merge
0
Stars
0
Downloads
0
devops
0
Stars
0
Downloads
0
architecture-ast-translation
0
Stars
0
Downloads
0
architecture-execution-path
0
Stars
0
Downloads
0
architecture-jit-compilation
0
Stars
0
Downloads
0
architecture-mlir-dialects
0
Stars
0
Downloads
0
architecture-overview
0
Stars
0
Downloads
0
architecture-runtime-ffi
0
Stars
0
Downloads
0
Published Skills
merge
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.
Repository SourceNeeds Review
devops
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.
Repository SourceNeeds Review
architecture-ast-translation
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/.
Repository SourceNeeds Review
architecture-execution-path
The full call chain from PostgreSQL ExecutorRun_hook through pgx-lower's dispatcher, query analyzer, MLIR runner, and JIT engine. Use when working on query dispatch, the executor hook, the fallback to PG's interpreter, per-query lifecycle, or any code in src/pgx-lower/execution/postgres/ or mlir_runner.cpp.
Repository SourceNeeds Review
architecture-jit-compilation
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.
Repository SourceNeeds Review
architecture-mlir-dialects
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.
Repository SourceNeeds Review
architecture-overview
High-level architecture map of pgx-lower. The shape of the codebase, what each top-level directory does, and how a query flows from PostgreSQL through MLIR to JITed native code. Use when orienting in this codebase, when asked broad architectural questions, or as the starting point before diving into a specific area.
Repository SourceNeeds Review
architecture-runtime-ffi
The C++ runtime called from JITed MLIR code. Hashtable, Vector, Sort, type conversions (date/numeric/string/varlena), tuple access globals, FFI symbols. Use when adding runtime functions, debugging JIT↔C boundaries, fixing memory leaks across the FFI, working on type conversions, or touching anything in src/pgx-lower/runtime/ or src/lingodb/runtime/.
Repository SourceNeeds Review
architecture-versions-and-history
Version pinning (LLVM 20, MLIR 20, Clang 20, PG 17.6, Ubuntu 24.04, Clang-only build), known compiler bugs, recurring fragile areas, and lessons mined from git history. Use when bumping versions, hitting compile failures that look version-related, debugging LLVM/MLIR API mismatches, when a fragile-area pattern (decimals, nulls, hash joins) looks familiar, or when planning a refactor in a known-debt area.
Repository SourceNeeds Review