postgresql-psql

Execute PostgreSQL queries and automate administrative tasks via psql.

Updated Aug 23, 2026

Search Tags:#automation #query optimization #SQL #database management #PostgreSQL #psql #DBA

One-click install

npx skills add https://github.com/kienhaminh/profile --skill postgresql-psql-kienhaminh

Or copy as Structured Prompt for Agent▼

Please help me install this Agent Skill.
Skill: postgresql-psql
Source: https://github.com/kienhaminh/profile/tree/main/.claude/skills/postgresql-psql
Command: npx skills add https://github.com/kienhaminh/profile --skill postgresql-psql-kienhaminh

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill simplifies complex PostgreSQL database interactions, allowing you to automate administrative tasks, execute queries efficiently, and manage database objects without deep manual command-line expertise. It reduces the time and effort spent on routine database operations and troubleshooting.

Core Features & Use Cases

Comprehensive psql Reference: Access a complete guide to psql meta-commands, connection options, and SQL operations.
Automated Scripting: Write and execute SQL scripts for tasks like health checks, maintenance, and data import/export.
Performance Tuning: Analyze query plans and monitor database performance to optimize your PostgreSQL setup.
Use Case: Automatically generate a daily report of database sizes and active connections across all your PostgreSQL instances, then export it to a CSV file for review.

Quick Start

Use the postgresql-psql skill to list all databases and their sizes on the local PostgreSQL server.