Skip to content
Kitbay
Skill

postgres-best-practices

Apache-2.0Updated on Oct 6, 202656GitHub stars

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