skills.rest
matejformanek
matejformanekCOMMUNITY
Explore all skills by this author →
GitHub

build-and-run

Automate PostgreSQL source builds, installation, and cluster lifecycle management.

Updated Jun 1, 2026
Search Tags:#debugging#postgresql#meson#database-internals#backend-hacking#c-development
One-click install
npx skills add https://github.com/matejformanek/postgres-claude --skill build-and-run
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: build-and-run
Source: https://github.com/matejformanek/postgres-claude/tree/main/.claude/skills/build-and-run
Command: npx skills add https://github.com/matejformanek/postgres-claude --skill build-and-run

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill removes the friction of managing a PostgreSQL development environment, automating the complex lifecycle of building, testing, and debugging the database engine from source.

Core Features & Use Cases

  • Lifecycle Management: Automates meson-based builds, installation, initdb, and cluster lifecycle (start/stop/restart) for the dev clone.
  • Debug & Sanitizer Profiles: Provides specialized workflows for debug builds (cassert) and memory-safety analysis (ASan/UBSan).
  • Developer Productivity: Simplifies the edit-rebuild-retest loop by providing slash-command wrappers for common tasks like attaching debuggers or running regression suites.

Quick Start

Use the build-and-run skill to initialize a fresh PostgreSQL development cluster and start the server for backend hacking.

Frequently Asked Questions about build-and-run

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate the PostgreSQL build and development cycle from source?▼

Automate the PostgreSQL development cycle by using meson-based build configuration to handle compilation, installation, and cluster lifecycle management, streamlining the edit-rebuild-retest loop for backend hacking.

Can I integrate AddressSanitizer when debugging PostgreSQL backend processes?▼

Yes, you can integrate AddressSanitizer and UBSan for memory-safety analysis by configuring specialized debug profiles, enabling detailed detection of memory leaks and undefined behavior during PostgreSQL backend process debugging.

What tools do I need to configure a PostgreSQL meson build environment?▼

You need a local PostgreSQL source tree and standard build toolchains including meson, ninja, and lldb or gdb to configure the build environment and attach debuggers to backend processes.

How does meson-based build configuration handle initdb and cluster lifecycle?▼

Meson-based build configuration automates the full cluster lifecycle by managing installation, executing initdb for fresh cluster initialization, and providing start, stop, and restart controls for the PostgreSQL dev clone.

Is there a way to simplify running PostgreSQL regression suites during development?▼

You can simplify running PostgreSQL regression suites by using provided slash-command wrappers that automate common development tasks, reducing friction in the edit-rebuild-retest loop.

What is the best way to manage a debug build with cassert for PostgreSQL internals?▼

The best way to manage a PostgreSQL debug build with cassert is using specialized debug profiles that automate the build configuration, ensuring assertion checks are enabled for backend hacking and internal testing.

Related Skills

Explore More Software Engineering Skills→
VMAFxVMAFx
3

build-vmaf

Build libvmaf with Meson and Ninja across cpu, cuda, sycl, and hip backends.

Official
Advanced
Marshall-HallenbeckMarshall-Hallenbeck
5

fix-tests

Diagnose and repair failing test suites across multiple language ecosystems.

Community
Advanced
tabgabtabgab

opp-repl-sanitizer-tests

Run sanitizer-instrumented builds to detect memory errors and undefined behavior in opp_repl simulations.

Community
Advanced
lenadlmlenadlm

install-tailscale

Installs Tailscale on Ubuntu/Debian via manual GPG key and apt source configuration.

Community
Intermediate