postgres-best-practices

Name: postgres-best-practices
Author: neondatabase/postgres-skills

$npx mdskill add neondatabase/postgres-skills/postgres-best-practices

Provides Postgres best practices for schema design, indexing, query optimization, migrations, and avoiding pitfalls.

Helps developers write SQL, design schemas, optimize queries, and set up Postgres databases effectively.
Integrates with Postgres databases and references internal documentation like schema-design.md.
Decides recommendations based on established guidelines for database management and performance.
Presents results through structured references and guidelines in markdown format.

SKILL.md

.github/skills/postgres-best-practicesView on GitHub ↗

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