postgresql-psql

Manage PostgreSQL databases using psql meta-commands and command-line options.

Updated Aug 23, 2026

Search Tags:#automation #performance #SQL #database #postgresql #psql #administration

One-click install

npx skills add https://github.com/OleksiiPopovDev/claude --skill postgresql-psql-oleksiipopovdev

Or copy as Structured Prompt for Agent▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually managing PostgreSQL databases via psql can be complex, time-consuming, and error-prone, especially for advanced tasks like performance tuning, scripting, or transaction management. This skill simplifies these operations.

Core Features & Use Cases

Comprehensive psql Reference: Access 70+ meta-commands and 25+ command-line options for efficient database interaction.
Advanced SQL & Scripting: Leverage full-text search, JSON operations, window functions, and dynamic SQL scripts for complex tasks.
Performance & Security: Optimize queries with EXPLAIN ANALYZE and manage users/permissions securely.
Use Case: Automate a weekly database health check, including analyzing and vacuuming tables, and reindexing the database, all from a single script.

Quick Start

Use the postgresql-psql skill to list all databases and then connect to the 'myapp_db' database.