Agent skill

Howto Develop With Postgres

by ed3dai in ed3dai/ed3d-plugins

A skill your agent uses when writing database access code, creating schemas, or managing transactions with PostgreSQL - enforces transaction safety with TX naming, read-write separation, type safety…

No licenceAuto-check passedDevelopment

Install Howto Develop With Postgres

skills CLI
$ npx skills add ed3dai/ed3d-plugins --skill howto-develop-with-postgres -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install ed3dai/ed3d-plugins howto-develop-with-postgres --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/ed3dai/ed3d-plugins.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/ed3d-house-style/skills/howto-develop-with-postgres .claude/skills/howto-develop-with-postgres && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
howto-develop-with-postgres
GitHub stars
250
Token cost
~1.8k tokens
SKILL.md length
703 words
Files
2
Skills in repo
34
Repo updated
First seen
Licence
None found

At a glance

A skill your agent uses when writing database access code, creating schemas, or managing transactions with PostgreSQL - enforces transaction safety with TX naming, read-write separation, type safety…

  • Works in 4 steps: Change schema in code → Generate migration file → Review migration SQL → …
  • Writing database access code
  • SKILL.md covers Overview, Transaction Management, Type Safety and Naming Conventions, plus 5 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Howto Develop With Postgres is an agent skill from ed3dai/ed3d-plugins. Use when writing database access code, creating schemas, or managing transactions with PostgreSQL - enforces transaction safety with TX naming, read-write separation, type safety for UUIDs/JSONB, and snakecase conventions to prevent data corruption and type errors

Its SKILL.md is about 1.8k tokens, which your agent loads only when the skill is triggered. The skill folder holds 1 other file (for example `typescript-drizzle.md`).

It sits in Development, covering Type safety. It works with PostgreSQL and TypeScript. The repository describes itself as: Ed's repo of Claude Code plugins, centered around a research-plan-implement workflow. Only a tiny bit cursed. If you're lucky.

When your agent uses it

  • Writing database access code
  • Creating schemas
  • Managing transactions with PostgreSQL - enforces transaction safety with TX naming
  • Read-write separation

Example prompts

  • “/howto-develop-with-postgres”

Workflow steps

4 steps, taken from the first numbered list in SKILL.md.

  1. Change schema in code
  2. Generate migration file
  3. Review migration SQL
  4. Apply migration to database

What it can do on your machine

Read from SKILL.md and the folder at commit 0c90f4b. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are typescript).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Howto Develop With Postgres loads about 1.8k tokens when it runs. Until then it costs about 74 tokens; SKILL.md has 703 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~74
When it runs · the whole SKILL.md, loaded when a task matches
~1.8k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Without a licence we can't republish the file, so here is its outline and opening line. It has 703 words (~1,820 tokens).

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

— opening of SKILL.md by ed3dai
name
howto-develop-with-postgres
user-invocable
false

Read the full SKILL.md on GitHub

Files

SKILL.md and 1 other file in plugins/ed3d-house-style/skills/howto-develop-with-postgres of ed3dai/ed3d-plugins.

  • SKILL.md
  • typescript-drizzle.md

Open the folder on GitHubat commit 0c90f4b

Compare with similar skills

Howto Develop With Postgres next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Howto Develop With Postgres compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Howto Develop With Postgres this skilled3dai/ed3d-plugins250—~1.8kAutomated safety check: PassNone
Drizzle Ormgrowupanand/ConvoForm1011 repos~2.7kAutomated safety check: PassApache-2.0
Drizzle Ormericrisco/rsc-harness167—~2.6kAutomated safety check: PassMIT
Prisma Ormericrisco/rsc-harness167—~3kAutomated safety check: PassMIT
PSL Syntax Tree Layersprisma/orm48k—~2.3kAutomated safety check: PassApache-2.0
Typescript Advanced Typesrolling-scopes/rsschool-app10k25 repos~4.2kAutomated safety check: PassMPL-2.0

Similar skills

  • Drizzle Orm

    growupanand/ConvoForm

    Type-safe SQL ORM for TypeScript with zero runtime overhead. An agent skill from growupanand/ConvoForm.

    101 GitHub starsUsed in 1 repo~2.7k tokens
    DatabasesAuto-check passed
  • Drizzle Orm

    ericrisco/rsc-harness

    A skill your agent uses when modeling data or querying with Drizzle ORM in TypeScript — pgTable schema in .ts, type-safe select/insert/relational queries, drizzle-kit migrations.

    167 GitHub stars~2.6k tokensUpdated today
    DatabasesAuto-check passed
  • Prisma Orm

    ericrisco/rsc-harness

    A skill your agent uses when modeling data or writing type-safe queries with Prisma ORM in TypeScript — schema.prisma, prisma.config.ts, the generated Prisma Client, and Prisma Migrate, including…

    167 GitHub stars~3k tokensUpdated today
    DatabasesAuto-check passed
  • Official

    Explains which of the three PSL syntax tree layers to use with Prisma's parser output, and how to move between them without hand-written walks.

    48k GitHub stars~2.3k tokensUpdated today
    DevelopmentAuto-check passed
  • Typescript Advanced Types

    rolling-scopes/rsschool-app

    Master TypeScript's advanced type system including generics, conditional types, mapped types, template literals, and utility types for building type-safe applications.

    10k GitHub starsUsed in 25 repos~4.2k tokens
    DevelopmentAuto-check passed
  • Walks through adding a Wagmi feature across its layers: a Viem-based core action, TanStack Query options, and React and Vue bindings.

    6.8k GitHub stars~3.8k tokensUpdated 6 days ago
    DevelopmentAuto-check passed

More from ed3dai/ed3d-plugins

All 34 skills in this repo
  • Systematic Debugging

    ed3dai/ed3d-plugins

    A skill your agent uses when encountering any bug, test failure, or unexpected behavior, before proposing fixes - four-phase framework (root cause investigation, pattern analysis, hypothesis…

    250 GitHub starsUsed in 3 repos~2.4k tokens
    Auto-check passed
  • A skill your agent uses when creating or editing skills, before deployment, to verify they work under pressure and resist rationalization - applies RED-GREEN-REFACTOR cycle to process documentation…

    250 GitHub starsUsed in 3 repos~3.5k tokens
    Auto-check passed
  • Brainstorming

    ed3dai/ed3d-plugins

    A skill your agent uses when creating or developing anything, before writing code or implementation plans - refines rough ideas into fully-formed designs through structured Socratic questioning…

    250 GitHub starsUsed in 1 repo~4.3k tokens
    Auto-check passed
  • Writing Good Tests

    ed3dai/ed3d-plugins

    A skill your agent uses when writing or reviewing tests - covers test philosophy, condition-based waiting, mocking strategy, and test isolation

    250 GitHub starsUsed in 1 repo~2.7k tokens
    Auto-check passed
  • Writing Skills

    ed3dai/ed3d-plugins

    A skill your agent uses when creating new skills, editing existing skills, or verifying skills work before deployment - applies TDD to process documentation by testing with subagents before writing…

    250 GitHub starsUsed in 1 repo~1.3k tokens
    Auto-check passed
  • Coding Effectively

    ed3dai/ed3d-plugins

    ALWAYS use this skill when writing or refactoring code. An agent skill from ed3dai/ed3d-plugins.

    250 GitHub stars~1.9k tokensUpdated 1 mo ago
    Auto-check passed

Questions about Howto Develop With Postgres

What does Howto Develop With Postgres do?

A skill your agent uses when writing database access code, creating schemas, or managing transactions with PostgreSQL - enforces transaction safety with TX naming, read-write separation, type safety…. Howto Develop With Postgres is an agent skill from ed3dai/ed3d-plugins.

When should I use Howto Develop With Postgres?

Howto Develop With Postgres fits situations like: writing database access code; creating schemas; managing transactions with PostgreSQL - enforces transaction safety with TX naming; read-write separation.

How do I install Howto Develop With Postgres in Claude Code?

Run `npx skills add ed3dai/ed3d-plugins --skill howto-develop-with-postgres -a claude-code`. Or copy the skill folder (plugins/ed3d-house-style/skills/howto-develop-with-postgres in ed3dai/ed3d-plugins) into .claude/skills/howto-develop-with-postgres in your project. Claude Code loads it when a task matches its description.

How do I install Howto Develop With Postgres in Codex?

Run `npx skills add ed3dai/ed3d-plugins --skill howto-develop-with-postgres -a codex`. Or copy the skill folder (plugins/ed3d-house-style/skills/howto-develop-with-postgres in ed3dai/ed3d-plugins) into .agents/skills/howto-develop-with-postgres in your project. Codex loads it when a task matches its description.

Can I use Howto Develop With Postgres in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add ed3dai/ed3d-plugins --skill howto-develop-with-postgres -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/howto-develop-with-postgres, .gemini/skills/howto-develop-with-postgres, .github/skills/howto-develop-with-postgres and .opencode/skills/howto-develop-with-postgres in your project.

What does Howto Develop With Postgres need to run?

SKILL.md names no scripts, command-line tools or credentials: Howto Develop With Postgres is instructions for the agent only.

Does Howto Develop With Postgres access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Howto Develop With Postgres safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Howto Develop With Postgres use?

No licence was found for Howto Develop With Postgres or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.

How many tokens does Howto Develop With Postgres use?

About 1.8k tokens (SKILL.md is roughly 7.3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Howto Develop With Postgres?

Skills that share tags, products or a category with Howto Develop With Postgres: Drizzle Orm (growupanand/ConvoForm, 101 stars), Drizzle Orm (ericrisco/rsc-harness, 167 stars), Prisma Orm (ericrisco/rsc-harness, 167 stars) and PSL Syntax Tree Layers (prisma/orm, 48k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Howto Develop With Postgres?

ed3dai (a GitHub organization) maintains it in ed3dai/ed3d-plugins, which has 250 GitHub stars. The repository holds 34 skills in this directory. The repository was last updated on September 6, 2026.

Source: ed3dai/ed3d-plugins on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.