PostgreSQL server administration & operations — DBA work on a running cluster. Use when configuring a server (postgresql.conf, ALTER SYSTEM, reload vs restart, GUCs), managing roles & privileges (CREATE ROLE, GRANT/REVOKE, DEFAULT PRIVILEGES, predefined roles, membership), authentication (pg_hba.conf, scram-sha-256, peer/cert/ldap), backups & restore (pg_dump/pg_dumpall/pg_restore, pg_basebackup, incremental backups, PITR), replication & HA (streaming, logical publications/subscriptions, replication slots, failover, synchronous commit), pg_upgrade, or monitoring (pg_stat_activity, pg_stat_io, pg_stat_progress_*, log settings, checkpoints, connections). Server-side ops — for the psql client use psql, for SQL & query syntax postgres-sql, for query tuning & autovacuum mechanics postgres-performance, for contrib modules postgres-extensions. Features added in a release are tagged inline like (pg16+); untagged items are bedrock (PostgreSQL 9.x or earlier). Verify with SHOW server_version.
How to install postgres-admin?
dashed/claude-marketplace/postgres-admin
$npx -y skills add dashed/claude-marketplace --skill postgres-adminInstalls into the current project.
›Prefer a prompt? Paste this to your agent
Run `npx skills use "https://github.com/dashed/claude-marketplace" --skill "dashed/claude-marketplace/postgres-admin"` and follow the generated skill instructions now. Read its complete output, redirecting it to a temporary file first if necessary. Resolve relative paths from the supporting-files directory it provides.
Use the skills in "https://github.com/dashed/claude-marketplace" that are relevant to the current task. Run `npx skills add "https://github.com/dashed/claude-marketplace"` and select the relevant skills, then follow their instructions.
Related
6 picksType
- supabase-postgres-best-practicesPostgres performance optimization and best practices from Supabase.Jul 2026
- firebase-data-connect-basicsBuilds and deploys Firebase SQL Connect (aka Firebase Data Connect) backends with PostgreSQL securely.Jul 2026
- firebase-firestoreSets up, manages, queries, and configures Cloud Firestore databases (Standard/Enterprise edition), including data modeling, security rules, indexes, and SDK…Jul 2026
- prisma-database-setupGuides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).Jul 2026
- prisma-client-apiPrisma Client API reference covering model queries, filters, operators, and client methods.Jul 2026
- prisma-cliPrisma ORM CLI commands reference covering init, generate, migrate, db, dev, studio, validate, format, debug, and mcp.Jul 2026
