skills.rest
mrgoonie
mrgoonieCOMMUNITY
Explore all skills by this author →
Website𝕏@goon_nguyenGitHub

postgresql-psql

Manage PostgreSQL databases with psql commands and automation scripts.

2.2k|422|Updated Oct 23, 2025
Search Tags:#automation#database#postgresql#cli#sql#psql#administration
One-click install
npx skills add https://github.com/mrgoonie/claudekit-skills --skill postgresql-psql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgresql-psql
Source: https://github.com/mrgoonie/claudekit-skills/tree/main/.claude/skills/postgresql-psql
Command: npx skills add https://github.com/mrgoonie/claudekit-skills --skill postgresql-psql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Managing PostgreSQL databases can be complex and time-consuming, especially from the command line. This skill simplifies database administration, query execution, and scripting, allowing you to automate tasks and reduce manual effort.

Core Features & Use Cases

  • Comprehensive psql Reference: Access detailed documentation for all psql commands, meta-commands, and options.
  • Automated Database Tasks: Find examples for backups, health checks, and maintenance scripts.
  • Query Optimization & Debugging: Use EXPLAIN ANALYZE and monitoring tools to improve query performance.
  • Use Case: Quickly troubleshoot a slow query by getting an EXPLAIN ANALYZE plan and identifying bottlenecks, then applying best practices for indexing.

Quick Start

Connect to a database

psql -U username -h hostname -d database_name

List tables in current schema

\dt

Show help for SQL commands

\h