postgresql

To connect to a PostgreSQL database and list tables, use the psql CLI with the DATABASE_URL environment variable. Once connected, you can run common commands to list tables, describe schemas, and execute queries across cloud or self-hosted deployments.

Yes, you can export PostgreSQL query results to CSV or JSON. This Skill provides a psql-based workflow to run queries and export data, supporting data exploration and reporting tasks in a repeatable manner across your environments.

Yes, this psql workflow supports cloud databases like Supabase, Neon, AWS RDS, and Railway, as well as self-hosted PostgreSQL deployments. It handles connections via DATABASE_URL for consistent data exploration and maintenance across environments.

The best way to inspect a PostgreSQL schema from the command line is using the psql CLI. This Skill enables you to describe table structures, inspect schemas, and perform basic DDL and DML operations repeatably without manual error-prone commands.

To handle psql connection errors and common pitfalls in PostgreSQL, this Skill provides guidance for error handling. It establishes a consistent psql-based workflow to avoid repetitive mistakes when connecting, inspecting schemas, and running queries across environments.