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.

About

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

Expert troubleshooting for transactions, permissions, and session variables
Guidance on client-side data operations and script automation
30 GitHub stars
Mastery of psql meta-commands (\d, \dt, \pset) for object inspection
Comprehensive output formatting for CSV, HTML, and aligned table results
Advanced connection management including URI strings and .pgpass configuration

Use Cases

Configuring secure, encrypted remote connections to production PostgreSQL instances
Writing and executing automated SQL scripts for CI/CD or maintenance tasks
Interactively inspecting database schemas and managing tables or functions

About

Key Features

Expert troubleshooting for transactions, permissions, and session variables
Guidance on client-side data operations and script automation
30 GitHub stars
Mastery of psql meta-commands (\d, \dt, \pset) for object inspection
Comprehensive output formatting for CSV, HTML, and aligned table results
Advanced connection management including URI strings and .pgpass configuration

Use Cases

Configuring secure, encrypted remote connections to production PostgreSQL instances
Writing and executing automated SQL scripts for CI/CD or maintenance tasks
Interactively inspecting database schemas and managing tables or functions