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
Updated 1/18/2026
Stars
1
Forks
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.

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use postgresql