---
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…
---

# postgres-best-practices

Best practices and guidelines for working with Postgres. Covers schema design, indexing strategies, query optimization, migrations, and common pitfalls. Use…

# postgres-best-practicesby neondatabase
Best practices and guidelines for working with Postgres. Covers schema design, indexing strategies, query optimization, migrations, and common pitfalls. Use…

`npx skills add https://github.com/neondatabase/postgres-skills --skill postgres-best-practices`Download ZIPGitHub

## Postgres Best Practices

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

## References

AreaResourceWhen to UseSchema Design`references/schema-design.md`Designing tables, choosing data types, normalizing

## More skills from neondatabase
claimable-postgresby neondatabaseInstant Postgres databases for local development, demos, prototyping, and test environments. No account required. Databases expire after 72 hours unless claimed to a Neon account.neon-postgres-branchesby neondatabaseThe outcome of this skill should be a created Neon branch (or a clear, actionable next step if creation cannot proceed). Choose the correct branch type, then execute branch creation via MCP or CLI.neon-postgres-egress-optimizerby neondatabaseGuide the user through diagnosing and fixing application-side query patterns that cause excessive data transfer (egress) from their Postgres database. Most high egress bills come from the application fetching more data than it uses.plugin-managerby neondatabaseManage plugin structure and configuration for this repository across both Cursor and Claude Code. Use when creating, updating, or reviewing plugin folders…skill-creatorby neondatabaseGuide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's…add-neon-docsby neondatabaseUse this skill when the user asks to add documentation, add docs, add references, or install documentation about Neon. Adds Neon best practices reference links…neon-authby neondatabaseSets up Neon Auth for your application. Configures authentication, creates auth routes, and generates UI components. Use when adding authentication to Next.js,…neon-drizzleby neondatabaseCreates a fully functional Drizzle ORM setup with a provisioned Neon database. Installs dependencies, provisions database credentials, configures connections,…

---

**Source**: https://github.com/neondatabase/postgres-skills/tree/HEAD/skills/postgres-best-practices
**Author**: neondatabase
**Discovered via**: mcpservers.org