Postgres Best Practices

What it does

This skill equips AI agents with the knowledge to implement robust PostgreSQL configurations, ensuring high performance and data integrity through industry-standard practices. It guides agents in optimizing query execution, managing connection pools, and securing database instances against common vulnerabilities.

When to use it

• Configuring a new production-grade PostgreSQL instance for an application deployment.
• Optimizing slow-running queries or analyzing execution plans for bottlenecks.
• Hardening database security settings to comply with compliance requirements.
• Tuning connection limits and memory parameters for high-concurrency workloads.

Key capabilities

• Query optimization strategies and indexing techniques.
• Connection pooling configuration and management.
• Security best practices including authentication and encryption.
• Performance tuning for memory and CPU utilization.
• Backup and recovery procedure planning.

Example prompts

• "Configure a PostgreSQL instance with connection pooling for a high-traffic e-commerce site."
• "Analyze this slow SQL query and suggest optimization strategies using execution plans."
• "Generate a checklist for hardening a production PostgreSQL database against security threats."

Tips & gotchas

Ensure your AI agent has access to the specific PostgreSQL version documentation, as features vary significantly across releases. Always validate generated configurations in a staging environment before applying them to production systems to prevent unintended downtime or data loss.