Postgres Pro
by jeffallan1be15d8064f8MIT11K starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated 5 days ago
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
Add to a SourceWeft workspace
- Open the skill in your dashboard and add it to a workspace.
- Enable it for the chats that should use it.
This skill is instructions only: it ships no scripts to execute.
Add to SourceWeftYou will be asked to sign in first, then taken straight to this skill.
Ask your agent to install it
Paste this prompt into Claude Code, Codex, Cursor or another agent that can run commands — or into SourceWeft chat. The agent reads this skill's install guide, shows you its source, license and scripts, and installs it with the SourceWeft CLI once you agree.
Read https://sourceweft.com/skills/gh-jeffallan-claude-skills-postgres-pro/install.md and install the skill it describes. Before installing, show me its source, license and whether it ships scripts, and wait for my OK. Ask me before changing anything else on my machine.Install it yourself from a terminal
For Claude Code, Codex, Cursor and other local agents. The SourceWeft CLI fetches the skill from its source repository at the commit scanned here, and verifies every file against the hashes recorded when the skill was scanned. If anything differs, nothing is written.
npx @sourceweft/cli skills install gh-jeffallan-claude-skills-postgres-proAdd --agent claude-code, codex, cursor or universal to choose which agent gets it (Claude Code by default).
Upstream installer — not verified by SourceWeft
The open-source skills installer fetches the same pinned commit, but does not check the files against the hashes SourceWeft recorded.
npx skills add https://github.com/jeffallan/claude-skills/tree/1be15d8064f88fc25216442406d40add8fd23b53/skills/postgres-proSource and attribution
Source:jeffallan/claude-skillsinskills/postgres-proat commit1be15d8
License: MIT
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from jeffallan/claude-skills
Wordpress Pro
jeffallan
Guides WordPress theme, plugin, Gutenberg block, and WooCommerce development with security and performance practices.
Vue Expert Js
jeffallan
Builds Vue 3 apps in JavaScript only, using JSDoc annotations instead of TypeScript.
The Fool
jeffallan
Applies five structured critical-reasoning modes to stress-test ideas, plans, and decisions.
Swift Expert
jeffallan
Guides Swift 5.9+ development for Apple platforms, covering SwiftUI, async/await, actors, protocols and testing.
Sql Pro
jeffallan
Guides SQL query optimization, database schema design, and performance troubleshooting across major dialects.
Spring Boot Engineer
jeffallan
Guides Spring Boot 3.x backend implementation: REST controllers, JPA data access, Security 6, WebFlux and testing.
More in Data & Analytics
Spanner Basics
Guides Google Cloud Spanner administration, schema design, querying and performance diagnosis.
Gke Cost Analysis
Answers natural-language questions about GKE cluster and workload costs using BigQuery billing exports and live cluster metrics.
Datalineage Bigquery Asset Impact Analysis
Guides an agent through downstream impact (blast radius) analysis for a BigQuery table or view using Data Lineage.
Bigquery Troubleshooting
Diagnoses failing, slow, or unexpectedly expensive BigQuery jobs through structured root-cause workflows.
Bigquery Optimization
Guides BigQuery cost and performance optimization across capacity editions, storage layout, and SQL queries.
Bigquery Bigframes
Guides writing Python code with BigQuery DataFrames (BigFrames) for data processing, analysis, and machine learning.