Postgresql Best Practices

What it does

This skill provides guidance on PostgreSQL best practices, covering topics like indexing, query optimization, and security. It can analyze SQL queries to suggest improvements for performance and efficiency. The agent can also offer recommendations for database design and maintenance based on established industry standards.

When to use it

• You need help optimizing a slow-running SQL query in your PostgreSQL database.
• You're designing a new PostgreSQL database schema and want to ensure best practices are followed.
• You’re troubleshooting performance issues related to indexing or query planning.
• You require advice on securing your PostgreSQL instance against common vulnerabilities.

Key capabilities

• SQL Query Analysis & Optimization Suggestions
• Database Design Recommendations
• Indexing Best Practices
• Security Hardening Guidance

Example prompts

• "Analyze this SQL query and suggest improvements: SELECT * FROM orders WHERE customer_id = 123;"
• "What are the best practices for indexing a table with millions of rows?"
• “How can I secure my PostgreSQL database against SQL injection attacks?”

Tips & gotchas

The skill's effectiveness relies on providing accurate and complete SQL queries or database schema details. It is not a replacement for thorough understanding of PostgreSQL administration, but rather a tool to aid in best practice implementation.