Skills
.Work. You
Rest

postgres-hardening

Official

Secure PostgreSQL deployments with best practices.

Software Engineering#security#postgresql#auditing#backup#encryption#hardening#access-control
AuthorGoldenWing-360
Version1.0.0
Installs0

System Documentation

What problem does it solve?

It provides a comprehensive guide for hardening PostgreSQL installations to prevent unauthorized access and ensure data security.

Core Features & Use Cases

  • Network Security: Configures listener addresses and firewall rules to restrict database access.
  • Authentication Setup: Guides the setup of pg_hba.conf for role-based access control with secure methods.
  • Role Management: Demonstrates role separation with minimal privileges for different database operations.
  • Encryption & TLS: Advises on enabling SSL/TLS for encrypted communication channels.
  • Auditing & Logging: Recommends logging strategies and the integration of pg_audit for traceability.
  • Backup & Recovery: Highlights encrypted backup procedures using tools like pg_dump and age.
  • Upgrade & Maintenance: Provides procedures for version upgrades and maintaining inherited instances.

Quick Start

Review the guide to implement network restrictions, configure role separation, and enable TLS for your PostgreSQL server.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: postgres-hardening
Download link: https://github.com/GoldenWing-360/claude-security-skills/archive/main.zip#postgres-hardening

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.