# 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. - Skill: `tomevault-io/postgres-best-practices-2` (Agent Skill, multi-file: 2 files) - Install (CLI): `npx skillmds@latest add tomevault-io/postgres-best-practices-2` - Raw SKILL.md: https://api.skillmd.com/api/skills/tomevault-io/postgres-best-practices-2/raw - Safety review: pending - Works with: Claude Code, Claude.ai, OpenAI Codex - Category: Data & Analytics - Author: tomevault-io (https://skillmd.com/u/tomevault-io) - Updated: 2026-09-17 - Page: https://skillmd.com/skills/tomevault-io/postgres-best-practices-2 --- # 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](https://tomevault.io/claim/neondatabase) — claim your Tome and manage your conversions.