PostgreSQL CRUD

Safely inspect, query, and change PostgreSQL data through saved local profiles. The skill uses a Bash script and the psql CLI; it does not depend on Python, psycopg, or jq.

Purpose

Use this skill for:

• saving reusable PostgreSQL connection profiles
• direct PostgreSQL CLI connections
• SSH tunnel connections to private PostgreSQL hosts
• SSH remote execution where the database URL exists on a server, such as a remote .env file
• schema-aware table operations with public as the default schema
• schema inspection
• select, insert, update, delete, and raw SQL

Output: