Agent Skills by Matej Formanek
Showing 58 vetted skills indexed across 1 GitHub repositories.
snapshot-management
Manage PostgreSQL MVCC snapshot stacks and tuple visibility logic.
parallel-query
Manage ParallelContext lifecycles and shared memory for PostgreSQL parallel queries.
collation-provider
Manage PostgreSQL collation provider dispatch and multibyte encoding conversion.
error-handling
Standardize PostgreSQL backend error reporting with ereport, elog, and PG_TRY/PG_CATCH blocks.
replication-overview
Map PostgreSQL replication source code for walsender, walreceiver, and reorderbuffer logic.
multixact
Analyze PostgreSQL MultiXact machinery to diagnose tuple-locking contention and SLRU exhaustion.
wire-protocol
Guide PostgreSQL wire protocol message framing and dispatch for backend development.
gucs-config
Implement and validate custom PostgreSQL GUC variables with hooks and memory rules.
process-lifecycle
Guide PostgreSQL multi-process lifecycle implementation with signal-safe coding standards.
node-infrastructure
Extend PostgreSQL tagged-union Node types with gen_node_support.pl.
pg-patch-review
Orchestrate multi-agent review pipelines for PostgreSQL patches with automated build and test cycles.
commit-message-style
Standardize git commit messages to PostgreSQL house style and trailer requirements.
buffer-manager
Manage PostgreSQL shared-buffer pin/unpin lifecycle and clock-sweep replacement.
coding-style
Enforce PostgreSQL C source code formatting and architectural conventions.
aio-readstream
Implement and debug PostgreSQL asynchronous I/O and read-stream subsystems.
pg-shadow-implement
Compare AI-generated PostgreSQL implementation plans against upstream patch ground truth.
type-cache
Analyze PostgreSQL backend type-info cache internals for invalidation and typmod registry issues.
backup-and-recovery
Manage PostgreSQL base backups, WAL archiving, and point-in-time recovery.
bgworker-and-extensions
Generate PostgreSQL background worker and extension hook templates with signal-safe standards.
resource-owners
Automate management and cleanup of reference-counted PostgreSQL resources via ResourceOwner infrastructure.
memory-keeping
Synchronize session progress and append audit logs to markdown state files.
logical-replication
Analyze and debug PostgreSQL logical replication subsystems including WAL decoding and apply workers.
parser-and-nodes
Modify PostgreSQL parser grammar, AST nodes, and tree walkers.
pg-feature-brainstorm
Plan PostgreSQL backend features by analyzing usage surfaces and existing subsystems.