postgresql

Name: postgresql
Availability: InStock
Author: kittne

Design, tune, and secure production PostgreSQL clusters.

Updated Aug 23, 2026

Search Tags:#security #postgresql #observability #replication #tuning #database-design #backup-restore

Ready to run

npx skills add https://github.com/kittne/codex-skills-by-codex --skill postgresql-kittne

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgresql
Source: https://github.com/kittne/codex-skills-by-codex/tree/main/postgresql
Command: npx skills add https://github.com/kittne/codex-skills-by-codex --skill postgresql-kittne

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Design, tune, and secure PostgreSQL clusters for production workloads, enabling reliable operation of schemas, indexes, queries, backups, replication, and governance.

Core Features & Use Cases

Schema design and indexing strategy to optimize critical queries.
Backup/restore, PITR, replication, and high-availability operations.
Security hardening, observability, and operational governance for production databases.

Quick Start

Configure a baseline PostgreSQL cluster and run a quick health check.

Frequently Asked Questions about postgresql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I design a PostgreSQL schema and indexing strategy to optimize critical queries?▼

To optimize critical queries, PostgreSQL schema design and indexing strategy align table structures with access patterns. This approach minimizes sequential scan overhead and accelerates data retrieval across production workloads.

What's the best way to configure PostgreSQL backup, restore, and point-in-time recovery operations?▼

The best way to configure PostgreSQL backup and restore involves deploying point-in-time recovery (PITR) and replication. This ensures high availability and documented operational safeguards for reliable failure recovery.

How do I assess and tune PostgreSQL performance using pg_settings?▼

Assess and tune PostgreSQL performance by evaluating cluster configuration from pg_settings. This provides targeted performance tuning guidance to optimize resource utilization and improve query execution plans.

How do I implement security hardening and observability for a production PostgreSQL cluster?▼

Implement PostgreSQL security hardening and observability by establishing operational governance and continuous monitoring. This secures cloud-based or self-managed clusters and ensures reliable production database operations.

Does this PostgreSQL tuning guidance work for both self-managed and cloud-based clusters?▼

Yes, PostgreSQL tuning guidance supports configuration assessment and recovery readiness across both self-managed and cloud-based clusters. It delivers documented runbooks and operational safeguards for either deployment context.

Why do I need documented runbooks for PostgreSQL failure recovery?▼

Documented runbooks for PostgreSQL failure recovery provide structured safeguards and step-by-step restoration actions. They ensure reliable high availability and minimize data loss during unexpected production outages.