🐘
DevOpsPython

PostgreSQL

by nimadorostkar

PostgreSQL is a DevOps skill for Claude Code, published by nimadorostkar in Claude-Skills-collection.

25 stars3 forkson nimadorostkar/Claude-Skills-collectionAdded 2026/08/12Repository updated 2026/07/26
View source on GitHubDownload repo ZIP
aiclaudeclaude-skillsskills
Install in seconds
Install PostgreSQL
Copy PostgreSQL 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/nimadorostkar/Claude-Skills-collection/tree/main/skills/data/postgres ~/.claude/skills/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/nimadorostkar/Claude-Skills-collection.git

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

In this catalog

Source file
skills/data/postgres/SKILL.md in nimadorostkar/Claude-Skills-collection
Installs to
~/.claude/skills/postgres
Collection
One of 50 skills cataloged from this repository
Category
DevOps — 798 skills

What PostgreSQL does

PostgreSQL helps you tune schemas, indexes, autovacuum, pooling, and replication for Postgres workloads. Use it when diagnosing slow queries, bloat, locks, or planning large migrations.

PostgreSQL is cataloged under DevOps on DirSkills. PostgreSQL comes from a repository tagged ai, claude, claude-skills and skills.

Documentation

README

PostgreSQL

Purpose

Operate PostgreSQL well: understand what MVCC costs you, why the table is bloated, why the connection count matters more than you think, and how to change a large table without locking it.

When to Use

  • Designing schemas or indexes for Postgres.
  • Diagnosing bloat, slow queries, or lock contention.
  • Configuring connection pooling and replication.
  • Running a migration on a large table without downtime.

Capabilities

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

Frequently asked about PostgreSQL

  • What else does nimadorostkar publish alongside PostgreSQL?

    PostgreSQL is one of 50 skills that DirSkills catalogs from nimadorostkar/Claude-Skills-collection, the repository it ships in. Its siblings there include API Design, Agent Design and Agent Instructions. Each one is a separate skill with its own page in this directory, installs the same way PostgreSQL does, and is maintained by nimadorostkar in that same repository. The rest of the collection is listed on the nimadorostkar/Claude-Skills-collection page.

  • How does PostgreSQL compare to other DevOps skills?

    PostgreSQL ranks #772 by stars among the 798 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 against them. Open each page to compare what they document and how they install.

More from nimadorostkar/Claude-Skills-collection

PostgreSQL is one of 50 skills cataloged on DirSkills from nimadorostkar/Claude-Skills-collection.

See all 50 skills →
🔗
2026/07/16

API Design

Use when designing or reviewing an HTTP API. Covers resource modeling, status codes, pagination, idempotency, versioning, error formats, and the contract details that break clients when you get them wrong.
Quality
182
🤖
2026/07/16

Agent Design

Provides patterns for designing reliable LLM agents with tool use, including loop termination, error handling, human checkpoints, and recognizing when an agent isn't needed.
AI Engineering
182
🧭
2026/07/16

Agent Instructions

Write short, accurate instruction files for coding agents, including commands, conventions, and hard constraints. Use it when setting up or refreshing CLAUDE.md, AGENTS.md, or similar files.
AI Engineering
182
🧠
2026/07/16

Agent Memory

A method for agents to persist critical state—facts, failures, conclusions—in a file that survives context compaction and session ends, with strategies for retrieval and preventing stale data.
AI Engineering
182
🧾
3w ago

Architecture Decisions

Architecture Decisions records technical choices as ADRs with context, options, the decision, and consequences. Use it when a significant or hard-to-reverse decision needs to be documented for future maintainers.
Writing
253
⏳
2026/07/16

Background Jobs

Use when designing asynchronous job processing. Covers queue selection, idempotency, retry and backoff policy, scheduling, poison messages, and observability for work that happens outside the request.
DevOps
182

More DevOps skills

PostgreSQL is one of 798 DevOps skills cataloged on DirSkills, ranked #772 by stars among them.

Browse all DevOps skills →
⚙️
3w ago

Backend Patterns

Backend Patterns covers backend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes. Use when building or reviewing Node.js, Express, or Next.js API routes and their data access.
DevOps
239.8K36.4K
🔌
3w ago

API Connector Builder

API Connector Builder builds a new API connector or provider by matching an existing integration pattern in the codebase exactly. Use it when adding a new integration to a project without introducing a second architecture.
DevOps
239.8K36.4K
🔄
3w ago

Migration

Migration implements reversible compatibility-safe transitions for schema, data, API, protocol, configuration, or dependency changes. Use it when rollback and preservation proof are required.
DevOps
97.8K5.6K