---
name: postgres-best-practices
description: Best practices and guidelines for working with Postgres. Covers schema design, indexing strategies, query optimization, migrations, and common pitfalls. Use when writing SQL, designing database schemas, optimizing queries, or setting up a Postgres database.
---

# Postgres Best Practices

Guidelines and best practices for working with Postgres, covering schema design, indexing, query optimization, and common pitfalls.

## References

| Area           | Resource                          | When to Use                                      |
| -------------- | --------------------------------- | ------------------------------------------------ |
| Schema Design  | `references/schema-design.md`     | Designing tables, choosing data types, normalizing |