postgresql-psql

psql supports SSL/TLS connections via command-line options like --ssl-mode and --cert. For SSH tunneling, establish the tunnel first, then connect psql to localhost on the forwarded port. The Skill covers both secure connection patterns for production environments.

psql's \copy meta-command exports query results to CSV, JSON, or other formats. Use \copy (table_name) to (file.csv) with csv option, or pipe query output to external tools. The Skill provides scripting examples for automated import/export workflows.

psql includes 70+ meta-commands for listing databases, schemas, users, and permissions (\l, \dn, \du); managing roles and grants; and inspecting query plans. The Skill delivers a comprehensive reference covering commands for backups, health checks, and schema management.

Use EXPLAIN and EXPLAIN ANALYZE to inspect query plans and identify bottlenecks. psql's timing options (\timing) measure execution, and the Skill includes performance analysis guidance for query optimization without external tools.

Yes. psql executes SQL scripts and shell commands via -f flag and \! meta-command. The Skill covers scripting patterns for health checks, scheduled maintenance, and transactional control in automation pipelines.

psql serves development, staging, and production environments. The Skill addresses security (SSL connections, user permissions), transactional control, and robust troubleshooting applicable across all deployment contexts.