Skills postgresql-optimization
📦

postgresql-optimization

v1.0.0 Content revision r1 Safe ⚙️ External commands

Optimize PostgreSQL Performance

Slow PostgreSQL systems need structured analysis before changes. This skill guides query tuning, index planning, configuration review, maintenance, and monitoring.

Supports: Claude Codex Code(CC)
🥈 80 Silver

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "postgresql-optimization" from https://skillstore.io/skills/sickn33-postgresql-optimization.md and its manifest at https://skillstore.io/api/skills/sickn33-postgresql-optimization/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/sickn33-postgresql-optimization.md Signed manifest GET /api/skills/sickn33-postgresql-optimization/manifest Signed lockfile GET /api/skills/sickn33-postgresql-optimization/lockfile

Test it

Using "postgresql-optimization". A backend engineer reports slow account searches during peak traffic.

Expected outcome:

  • A prioritized assessment checklist for version, settings, slow queries, resource usage, and bottlenecks.
  • A query review plan covering execution time, scan types, joins, and candidate optimizations.
  • A validation plan to compare performance before and after each change.

Using "postgresql-optimization". A data team needs indexes for high-volume reporting tables.

Expected outcome:

  • A suggested index review workflow for missing, composite, and partial indexes.
  • A warning list for write overhead, unused indexes, and workload-specific tradeoffs.
  • A follow-up checklist for usage review and statistics refresh.

Using "postgresql-optimization". A DBA wants a maintenance and monitoring plan for PostgreSQL.

Expected outcome:

  • A maintenance schedule covering vacuum, analyze, table bloat, autovacuum, and statistics.
  • A monitoring outline for dashboards, alerts, core metrics, and trend review.
  • Quality gates to confirm improved performance and effective operations.

Security Audit

Safe
v4 • 7/7/2026 Open versioned report

The audit reviewed 30 static external-command detections in SKILL.md. All detections are Markdown inline code or fenced prompt examples, not executable commands, scripts, or hidden instructions. No prompt injection or malicious intent was found.

1
Files scanned
176
Lines analyzed
0
Review items
0
False positives ignored

Risk Factors

⚙️ External commands (30)
SKILL.md:31 SKILL.md:32 SKILL.md:42-44 SKILL.md:44-49 SKILL.md:49-50 SKILL.md:50-60 SKILL.md:60-62 SKILL.md:62-67 SKILL.md:67-68 SKILL.md:68-78 SKILL.md:78-80 SKILL.md:80-85 SKILL.md:85-86 SKILL.md:86-96 SKILL.md:96-98 SKILL.md:98-103 SKILL.md:103-104 SKILL.md:104-114 SKILL.md:114-116 SKILL.md:116-121 SKILL.md:121-122 SKILL.md:122-132 SKILL.md:132-134 SKILL.md:134-139 SKILL.md:139-140 SKILL.md:140-150 SKILL.md:150-152 SKILL.md:152-173 SKILL.md:173-174 SKILL.md:174-175
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History →
Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/sickn33-postgresql-optimization/audits/4?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/sickn33-postgresql-optimization/security.svg)](https://skillstore.io/skills/sickn33-postgresql-optimization?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/sickn33-postgresql-optimization?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/sickn33-postgresql-optimization/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/sickn33-postgresql-optimization.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>
Academic citations (APA · BibTeX · CFF)

APA citation

sickn33. (2026). postgresql-optimization security audit report (audit version 4) [Author version 1.0.0]. Skillstore. https://skillstore.io/skills/sickn33-postgresql-optimization/audits/4

BibTeX citation

@techreport{sickn33-sickn33-postgresql-optimization-2026, author = {sickn33}, title = {postgresql-optimization security audit report (audit version 4)}, institution = {Skillstore}, year = {2026}, number = {4}, url = {https://skillstore.io/skills/sickn33-postgresql-optimization/audits/4}, note = {Author version 1.0.0} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "postgresql-optimization security audit report (audit version 4)" version: "1.0.0" type: report authors: - name: "sickn33" date-released: "2026-07-07" url: "https://skillstore.io/skills/sickn33-postgresql-optimization/audits/4" identifiers: - type: other value: "skillstore:sickn33-postgresql-optimization:audit:4" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: High
55
Architecture
100
Maintainability
87
Content
69
Community
83
Spec Compliance

What You Can Build

Triage Slow Production Queries

Review slow queries, execution plans, scan types, joins, and timing before proposing tuning work.

Plan Better Index Coverage

Identify missing or ineffective indexes and compare B-tree, composite, and partial index options.

Prepare Database Maintenance Work

Create a checklist for vacuum, analyze, bloat checks, autovacuum review, monitoring, and alerting.

Try These Prompts

Assess a Slow Database 
Use this skill to review my PostgreSQL database performance and list the first checks I should run.
Review a Slow Query 
Use this skill to analyze a slow PostgreSQL query, explain likely bottlenecks, and suggest safer tuning steps.
Plan Index Improvements 
Use this skill to design an indexing strategy for these tables and describe tradeoffs before changes.
Design a Production Optimization Plan 
Use this skill to create a phased PostgreSQL optimization plan covering queries, indexes, configuration, maintenance, monitoring, and validation.

Best Practices

  • Collect query plans, schema details, PostgreSQL version, and metrics before changing settings.
  • Test each optimization separately and compare measured results before broader rollout.
  • Review index benefits against write overhead, storage cost, and maintenance impact.

Avoid

  • Changing production configuration without baseline metrics or rollback planning.
  • Adding many indexes without checking query patterns and write performance.
  • Treating a single slow query as proof of a database-wide bottleneck.

Frequently Asked Questions

Does this skill run database commands?
No. It provides workflow guidance and prompts. Users must run database commands in their approved environment.
Can this skill replace a database administrator?
No. It helps structure analysis, but production changes need qualified review and operational approval.
What information should I provide?
Provide PostgreSQL version, query plans, schema details, slow query samples, configuration notes, and performance metrics.
Does it support managed PostgreSQL services?
Yes. The workflow applies to managed PostgreSQL, but provider limits may restrict configuration changes.
Which AI tools can use this skill?
The report lists support for Claude, Codex, and Claude Code.
Will it automatically fix slow queries?
No. It helps plan and review changes. Users must test and apply fixes themselves.

Developer Details

Author

sickn33

License

MIT

Author version

v1.0.0

Skillstore revision

r1

Repository

https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/postgresql-optimization

Ref

816c62b2546ddb1c6a0453e7c781b5e095117819

Maintenance freshness

7/18/2026

Usage

7 downloads · 128 views

File structure

📄 SKILL.md