Postgres Best Practices

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. Use when this capability is needed.

tomevault-io Updated

File contents

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

Converted and distributed by TomeVault — claim your Tome and manage your conversions.

tomevault-io/skills-registry/tree/main/neondatabase--postgres-skills--postgres-best-practices commit 9dbd0ed8cf

Frequently asked questions

npx skillmds@latest add tomevault-io/postgres-best-practices-2