Design, tune, and secure production PostgreSQL clusters.
npx skills add https://github.com/kittne/codex-skills-by-codex --skill postgresql-kittne
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
Design, tune, and secure PostgreSQL clusters for production workloads, enabling reliable operation of schemas, indexes, queries, backups, replication, and governance.
Configure a baseline PostgreSQL cluster and run a quick health check.
High-intent search queries and answers about installing and using this skill.
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.
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.
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.
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.
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.
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.
anyscaleDeploy Anyscale on AWS EKS using Terraform and Helm commands.
Gami19Automate post-deploy operations for AI agents with metrics, guardrails, and monitoring.
3balljugglerYuOptimize PostgreSQL query efficiency, schema design, and connection management in Supabase.
MovchanetsPlan and validate database administration workflows for cloud and self-managed environments.
