skills.rest
Elios-FPT
Elios-FPTOFFICIAL
Explore all skills by this author →
GitHub

postgresql-psql

Guide PostgreSQL database administration, scripting, and query management via psql.

Updated Aug 23, 2026
Search Tags:#automation#database#postgresql#cli#sql#psql#administration
One-click install
npx skills add https://github.com/Elios-FPT/EliosCodePracticeService --skill postgresql-psql-elios-fpt
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgresql-psql
Source: https://github.com/Elios-FPT/EliosCodePracticeService/tree/main/.claude/skills/postgresql-psql
Command: npx skills add https://github.com/Elios-FPT/EliosCodePracticeService --skill postgresql-psql-elios-fpt

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually interacting with PostgreSQL databases can be complex and time-consuming, especially for advanced administration, scripting, and troubleshooting. This skill provides a comprehensive guide to psql, simplifying database management and enabling automation.

Core Features & Use Cases

  • Database Administration: Perform complex tasks like user management, backup/recovery, and performance tuning with ease.
  • Scripting & Automation: Write powerful SQL and shell scripts to automate routine database operations, saving significant time.
  • Query & Data Management: Execute queries, manage tables, and format output efficiently for development and analysis.
  • Use Case: Automate a weekly database health check, including analyzing table sizes, checking for long-running queries, and performing routine vacuum operations, all through a single script.

Quick Start

Use the postgresql-psql skill to connect to the 'production_db' database and list all tables.