skills.rest
akornmeier
akornmeierCOMMUNITY
Explore all skills by this author →
𝕏@akornmeierGitHub

postgresql-psql

Document PostgreSQL psql commands, meta-commands, and connection options.

4|Updated Nov 16, 2025
Search Tags:#performance#database#CLI#PostgreSQL#psql#meta-commands#Scripting
One-click install
npx skills add https://github.com/akornmeier/claude-config --skill postgresql-psql-akornmeier
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgresql-psql
Source: https://github.com/akornmeier/claude-config/tree/main/skills/postgresql-psql
Command: npx skills add https://github.com/akornmeier/claude-config --skill postgresql-psql-akornmeier

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a comprehensive, ready-to-use PostgreSQL psql reference for database developers and administrators, helping users quickly find commands, meta-commands, and usage patterns without digging through scattered docs.

Core Features & Use Cases

  • Comprehensive meta-command reference: all 70+ backslash commands with examples.
  • Connection and CLI options: host, port, authentication, SSL, SSH tunnels, and environment-based configuration.
  • Scripting, automation, and workflows: running SQL files, batch execution, and shell integration for maintenance tasks.
  • Performance, debugging, and administration: explain plans, timing, query inspection, and routine database management.
  • Real-world patterns: backup/restore, migrations, and daily maintenance tasks that DBAs perform.

Quick Start

Start by requesting a concise guide for common tasks such as listing tables, connecting to a database, or enabling SSL for a connection.

Frequently Asked Questions about postgresql-psql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I list all available psql meta-commands for PostgreSQL database administration?▼

PostgreSQL psql meta-commands are backslash instructions like \dt for listing tables. This reference provides a comprehensive guide covering all 70+ meta-commands with practical examples for immediate database task execution.

What's the best way to connect to PostgreSQL using SSL and SSH tunnels via psql CLI?▼

Connecting to PostgreSQL via psql involves specifying host, port, and authentication options. This guide covers connection configurations including SSL enforcement, SSH tunnel setup, and environment-based profile management.

How do I use psql scripting to run SQL files and automate batch database maintenance?▼

psql scripting executes SQL files and integrates with shell workflows for batch processing. This reference provides patterns for automating routine database maintenance tasks, migrations, and shell-based execution workflows.

Can I debug PostgreSQL query performance issues using psql CLI explain plans?▼

Debugging PostgreSQL query performance in psql utilizes explain plans and timing meta-commands. This guide details performance inspection commands, query analysis patterns, and troubleshooting techniques for database administrators.

Does this psql reference include backup and restore patterns for PostgreSQL database migrations?▼

This psql reference includes real-world backup, restore, and migration patterns. It provides structured sections covering daily maintenance tasks and recovery scenarios that database administrators frequently execute.

Related Skills

Explore More Software Engineering Skills→
windyskywindysky

moai-lang-csharp

Automate C# 12 and .NET 8 development patterns for ASP.NET Core apps.

Community
Advanced
DevMHOneDevMHOne

cli-batches

Automate batch inference job submission and monitoring via the NexRoute CLI.

Community
Intermediate
ryukyagamilightryukyagamilight
1

mongodb

Manage MongoDB databases with CRUD, indexing, aggregation, backup, and restore operations.

Community
Advanced
mikkelkrogsholmmikkelkrogsholm
5

drizzle

Define TypeScript database schemas and generate migrations for PostgreSQL, MySQL, and SQLite.

Community
Intermediate