pg-feature-brainstorm

Plan PostgreSQL backend features by analyzing usage surfaces and existing subsystems.

Updated Jun 1, 2026
One-click install
npx skills add https://github.com/matejformanek/postgres-claude --skill pg-feature-brainstorm
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: pg-feature-brainstorm
Source: https://github.com/matejformanek/postgres-claude/tree/main/.claude/skills/pg-feature-brainstorm
Command: npx skills add https://github.com/matejformanek/postgres-claude --skill pg-feature-brainstorm

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill prevents premature implementation by providing a structured, two-phase planning framework for PostgreSQL backend features, ensuring the design space is fully explored before committing to specific code changes.

Core Features & Use Cases

  • Design Space Exploration: Frames fuzzy feature ideas into concrete usage surfaces and candidate approaches.
  • Existing Mechanism Survey: Prioritizes reusing established PostgreSQL subsystems over inventing new ones to reduce maintenance overhead.
  • Use Case: When you have a rough idea for a new SQL keyword or backend hook, this skill helps you identify the relevant subsystems, check for prior art in CommitFest, and define the necessary decision points before writing a single line of implementation code.

Quick Start

Invoke the pg-feature-brainstorm skill to explore the design space for adding a new server-side variable feature to the PostgreSQL backend.

Frequently Asked Questions about pg-feature-brainstorm

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

FAQPage Schema
How do I explore the design space for a new PostgreSQL backend feature?

To explore the design space for a PostgreSQL backend feature, you need a structured framework that frames fuzzy ideas into concrete usage surfaces and identifies candidate approaches before implementation. This prevents premature coding by mapping out decision points.

What is the best way to plan PostgreSQL database engine enhancements before writing code?

Planning PostgreSQL database engine enhancements requires a two-phase approach: surveying existing internal mechanisms to prioritize reusing established subsystems, then cross-referencing CommitFest entries and git logs for prior art to ensure evidence-based design.

How does cross-referencing CommitFest entries help scope PostgreSQL backend hooks?

Cross-referencing CommitFest entries helps scope PostgreSQL backend hooks by providing evidence-based design context, allowing you to check for prior art and established subsystems before committing to specific code changes for core modifications.

Can I use feature planning techniques to add a new SQL keyword to the PostgreSQL backend?

Yes, feature planning techniques apply directly to adding a new SQL keyword to the PostgreSQL backend. They help identify the relevant subsystems and define necessary decision points during early-stage planning without writing implementation code.

Why should I survey established PostgreSQL subsystems when modifying database internals?

Surveying established PostgreSQL subsystems when modifying database internals reduces maintenance overhead by prioritizing the reuse of existing mechanisms over inventing new ones. This ensures your backend hook or core modification integrates cleanly.

What are the limitations of early-stage planning for PostgreSQL core modifications?

Early-stage planning for PostgreSQL core modifications focuses strictly on design space exploration and scoping; it does not generate implementation code. You must separately handle the actual development of database engine enhancements and hooks.