postgres-best-practices
A general PostgreSQL skill published by Neon that is not tied to Neon's own service.
What the skill teaches
A general PostgreSQL skill published by Neon that is not tied to Neon's own service. It covers PostgreSQL 14 to 18, marks features by the version that introduced them and routes the agent to reference files by topic: schema design, indexing, reading query plans, query patterns, performance diagnostics with statistics views and locks, logical replication, hot standby, transaction isolation, backup and restore, roles and security, bulk loading, connection pooling with PgBouncer and major version upgrades. It is loaded when writing SQL, designing schemas, tuning queries or setting up a database, and consists of Markdown references only.
Capabilities
- Design PostgreSQL schemas and choose index types
- Read query plans and fix slow queries
- Plan replication, backup and restore
- Set up roles, row-level security and connection pooling
- Prepare a major version upgrade
About
- Publisher
- Neon
- Tool
- PostgreSQL
Install
The project doesn't document install steps that we could confirm. See the project's own instructions
What's inside
- references/backup-restore.md
- references/bulk-loading.md
- references/connection-pooling.md
- references/hot-standby.md
- references/indexing.md
- references/logical-replication.md
- references/major-version-upgrades.md
- references/performance-diagnostics.md
- references/query-optimization.md
- references/query-patterns.md
- references/schema-design.md
- references/security-roles.md
- references/transaction-isolation.md
MCP servers and skills can run code on your computer and act on your data. Review the source before installing.
Details
| Fact | Value | Source |
|---|---|---|
| Type | Skill | |
| Tool | PostgreSQL | |
| Publisher | Neon | source |
| Official status | Community (not published by the tool's vendor) | source |
| Needs an API key or sign-in | Not stated in its documentation | |
| Includes scripts | No | source |
| Platforms | Not stated in its documentation | |
| AI clients | Not stated in its documentation | |
| Licence | Apache-2.0 | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Oct 6, 202656 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository |
Sources
- Skill file (SKILL.md)github.com/neondatabase/postgres-skillsNov 10, 2026
- Licence file (LICENSE)github.com/neondatabase/postgres-skills · Backs: LicenceNov 12, 2026
- GitHub repositorygithub.com/neondatabase/postgres-skills · Backs: Official status, Publisher, Activity, LicenceNov 11, 2026
- Folder in the repository (postgres-best-practices)github.com/neondatabase/postgres-skills · Backs: Includes scriptsNov 10, 2026