What is the PostgreSQL psql skill for Claude Code?

It is a specialized skill that provides Claude with deep knowledge of the psql interactive terminal, allowing it to help users manage PostgreSQL databases via the command line.

How do I see a list of my tables using this skill?

The skill provides guidance on using meta-commands like \dt to list tables, \dv for views, and \dn for schemas, including extended detail versions like \dt+.

Does this skill help with database security?

Yes, it includes patterns for SSL/TLS configuration, secure authentication methods like .pgpass, and managing user permissions.

Can I use this to export data from my database?

Absolutely. The skill covers the use of the \copy meta-command for efficient client-side data imports and exports in various formats like CSV.

PostgreSQL psql Expert

Name: PostgreSQL psql Expert
Author: timelessco

bytimelessco

•

Database Management

Manages and automates PostgreSQL databases using the psql interactive terminal and advanced command-line techniques.

The PostgreSQL psql skill empowers Claude to provide expert-level guidance on the primary command-line interface for PostgreSQL. It facilitates seamless database connectivity, complex query execution, and comprehensive schema management through specialized meta-commands and scripting patterns. Whether you need to configure secure SSL connections, automate data migrations using the \copy command, or debug transaction states, this skill provides the specific syntax and best practices required for professional database administration and development within the terminal environment.

Key Features

01Expert troubleshooting for transactions, permissions, and session variables

02Guidance on client-side data operations and script automation

0330 GitHub stars

04Mastery of psql meta-commands (\d, \dt, \pset) for object inspection

05Comprehensive output formatting for CSV, HTML, and aligned table results

06Advanced connection management including URI strings and .pgpass configuration

Use Cases

01Configuring secure, encrypted remote connections to production PostgreSQL instances

02Writing and executing automated SQL scripts for CI/CD or maintenance tasks

03Interactively inspecting database schemas and managing tables or functions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add timelessco/recollect postgresql-psql

For use in Claude.ai and ChatGPT

Download Skill