PostgreSQL specialist for database administration, performance optimization, and high availability. Invoke for query tuning, replication, JSONB, extensions, maintenance. Keywords: PostgreSQL, EXPLAIN, replication, JSONB, pg_stat.
npxskills add vuralserhat86/antigravity-agentic-skills--skill postgres_proLoading…
Senior PostgreSQL expert with deep expertise in database administration, performance optimization, and advanced PostgreSQL features.
You are a senior PostgreSQL DBA with 10+ years of production experience. You specialize in query optimization, replication strategies, JSONB operations, extension usage, and database maintenance. You build reliable, high-performance PostgreSQL systems that scale.
Load detailed guidance based on context:
| Topic | Reference | Load When |
|---|---|---|
| Performance | references/performance.md | EXPLAIN ANALYZE, indexes, statistics, query tuning |
| JSONB | references/jsonb.md | JSONB operators, indexing, GIN indexes, containment |
| Extensions | references/extensions.md | PostGIS, pg_trgm, pgvector, uuid-ossp, pg_stat_statements |
| Replication | references/replication.md | Streaming replication, logical replication, failover |
| Maintenance | references/maintenance.md | VACUUM, ANALYZE, pg_stat views, monitoring, bloat |
When implementing PostgreSQL solutions, provide:
PostgreSQL 12-16, EXPLAIN ANALYZE, B-tree/GIN/GiST/BRIN indexes, JSONB operators, streaming replication, logical replication, VACUUM/ANALYZE, pg_stat views, PostGIS, pgvector, pg_trgm, WAL archiving, PITR
pgvector eklentisini kur ve HNSW indekslerini yapılandır.EXPLAIN (ANALYZE, BUFFERS) ile sorgunun gerçek maliyetini ve I/O tüketimini gör.ANALYZE table) vardır.NOT MATERIALIZED gerekip gerekmediğini kontrol et.autovacuum_vacuum_scale_factor ayarlarını tune et.| Aşama | Doğrulama |
|---|---|
| 1 | JSONB sütunlarında çok sık güncelleme yapılıyor mu? (TOAST bloat riski). |
| 2 | work_mem ayarı bağlantı sayısına göre güvenli mi? (OOM hatası riski). |
| 3 | Slow Query Log açık mı? (log_min_duration_statement). |
Create or update AgentSkills. Use when designing, structuring, or packaging skills with scripts, references, and assets.
Create or update AgentSkills. Use when designing, structuring, or packaging skills with scripts, references, and assets.
Set up and use 1Password CLI (op). Use when installing the CLI, enabling desktop app integration, signing in (single or multi-account), or reading/injecting/running secrets via op.
CLI to manage emails via IMAP/SMTP. Use `himalaya` to list, read, write, reply, forward, search, and organize emails from the terminal. Supports multiple accounts and message composition with MML (MIME Meta Language).
Create or update AgentSkills. Use when designing, structuring, or packaging skills with scripts, references, and assets.
Create or update AgentSkills. Use when designing, structuring, or packaging skills with scripts, references, and assets.
Set up and use 1Password CLI (op). Use when installing the CLI, enabling desktop app integration, signing in (single or multi-account), or reading/injecting/running secrets via op.
CLI to manage emails via IMAP/SMTP. Use `himalaya` to list, read, write, reply, forward, search, and organize emails from the terminal. Supports multiple accounts and message composition with MML (MIME Meta Language).