本文へスキップ
Kitbay
スキル

postgres-best-practices

Apache-2.02026年10月6日 更新56GitHubスター

A general PostgreSQL skill published by Neon that is not tied to Neon's own service.

スキルの内容

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.

できること

  • 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