PostgreSQL Development Patterns

by ed3dai

PostgreSQL Development Patterns is a DevOps skill for Claude Code, published by ed3dai in ed3d-plugins.

248 stars32 forkson ed3dai/ed3d-pluginsAdded 2026/09/02Repository updated 2026/06/16

View source on GitHub Download repo ZIP

claudeclaude-codeclaude-code-pluginclaude-code-plugin-marketplaceskills

Install in seconds

Install PostgreSQL Development Patterns

Copy PostgreSQL Development Patterns into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.

terminal

npx degit https://github.com/ed3dai/ed3d-plugins/tree/main/plugins/ed3d-house-style/skills/howto-develop-with-postgres ~/.claude/skills/howto-develop-with-postgres

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/ed3dai/ed3d-plugins.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file: plugins/ed3d-house-style/skills/howto-develop-with-postgres/SKILL.md in ed3dai/ed3d-plugins
Installs to: ~/.claude/skills/howto-develop-with-postgres
Collection: One of 25 skills cataloged from this repository
Category: DevOps — 828 skills

What PostgreSQL Development Patterns does

PostgreSQL Development Patterns guides database access code, schema design, and transaction handling in PostgreSQL. It covers TX_ transaction naming, read-write separation, UUID and JSONB typing, and snake_case conventions to reduce corruption and type errors.

PostgreSQL Development Patterns is cataloged under DevOps on DirSkills. PostgreSQL Development Patterns comes from a repository tagged claude, claude-code, claude-code-plugin, claude-code-plugin-marketplace and skills.

Documentation

README

Excerpt

PostgreSQL Development Patterns

Overview

Enforce transaction safety, type safety, and naming conventions to prevent data corruption and runtime errors.

Core principles:

Transactions prevent partial updates (data corruption)
Type safety catches errors at compile time
Naming conventions ensure consistency
Read-write separation prevents accidental mutations

For TypeScript/Drizzle implementations: See typescript-drizzle.md for concrete patterns.

Transaction Management

TX_ Prefix Rule (STRICT ENFORCEMENT)

Methods that START transactions:

Prefix method name with TX_
Must NOT accept connection/executor parameter
Call connection.transaction() or db.transaction() internally

This is the opening of the README. Read the full README on GitHub.

Frequently asked about PostgreSQL Development Patterns

What else does ed3dai publish alongside PostgreSQL Development Patterns?
PostgreSQL Development Patterns is one of 25 skills that DirSkills catalogs from ed3dai/ed3d-plugins, the repository it ships in. Its siblings there include Asking Clarifying Questions, Brainstorming and Coding Effectively. Each one is a separate skill with its own page in this directory, installs the same way PostgreSQL Development Patterns does, and is maintained by ed3dai in that same repository. The rest of the collection is listed on the ed3dai/ed3d-plugins page.
How does PostgreSQL Development Patterns compare to other DevOps skills?
PostgreSQL Development Patterns ranks #738 by stars among the 828 DevOps skills in this catalog. The most-starred ones next to it are Backend Patterns, API Connector Builder and Migration. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of PostgreSQL Development Patterns against them. Open each page to compare what they document and how they install.