Skills
.Work. You
Rest

postgresql-psql

Community

Master PostgreSQL with psql, effortlessly.

Software Engineering#automation#database#postgresql#cli#sql#psql#administration
Authormrgoonie
Version1.0.0
Installs0

System Documentation

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

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: postgresql-psql
Download link: https://github.com/mrgoonie/claudekit-skills/archive/main.zip#postgresql-psql

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.