home/categories/sql-databases/muzhicaomingwang-ai-ideas-project-ai-dba-skills-postgresql-skill-md
sql-databasesdatabases

postgresql

PostgreSQL DBA skill for schema design review, indexing, query tuning (EXPLAIN/ANALYZE), vacuum/autovacuum, concurrency/locking, partitioning, backup/restore, replication/HA, and safe migrations. Use for tasks like diagnosing slow queries, designing indexes and constraints, and operating Postgres in production.

muzhicaomingwang
maintainer
muzhicaomingwang
更新於 1/18/2026
星標
1
分支
0
quick start

Installation and usage

PostgreSQL DBA skill for schema design review, indexing, query tuning (EXPLAIN/ANALYZE), vacuum/autovacuum, concurrency/locking, partitioning, backup/restore, replication/HA, and safe migrations. Use for tasks like diagnosing slow queries, designing indexes and constraints, and operating Postgres in production.

安裝
$ install --globalskills.sh
使用

安裝後,您可以通過在終端運行以下命令來使用此技能:

skills use postgresql