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