CLI Profile

psql CLI

Community CuratedPostgreSQLvlatest

PostgreSQL interactive terminal

Install Matrix

brew

hash: unavailable

Auth Guide

Config Filedatabase:readdatabase:write

Token refresh: Rotate DB credentials or IAM auth token.

Step 1

Export required environment variables: PGHOST, PGUSER, PGPASSWORD, PGDATABASE

Command Map

Global Flags

--help (boolean) - Display command options and usage details.

Database Setup

psql will list

Derived from docs command references

Output: JSONdatabase-setupfull-stack-saas

--listoptional (string|boolean) - list available databases, then exit
--versionoptional (string|boolean) - output version information, then exit
--no-psqlrcoptional (string|boolean) - do not read startup file (~/.psqlrc)
--echo-alloptional (string|boolean) - echo all input from script
--echo-errorsoptional (string|boolean) - echo failed commands

Example 1

Example 2

Known errors: Resource not found for current context; Insufficient permissions; Invalid parameters

psql -c

Run one SQL command

Output: Tabledatabase-setupfull-stack-saas

Example 1

Known errors: Command failed; Insufficient permissions; Invalid parameters

psql \dt

List tables

Output: Tabledatabase-setupfull-stack-saas

Example 1

Known errors: Command failed; Insufficient permissions; Invalid parameters

psql \du

List roles

Output: Tabledatabase-setupfull-stack-saas

Example 1

Known errors: Command failed; Insufficient permissions; Invalid parameters

psql \q

Exit session

Output: Tabledatabase-setupfull-stack-saas

Example 1

Known errors: Command failed; Insufficient permissions; Invalid parameters

Workflow Recipes

No workflow chains currently reference this CLI.

Compatibility

Claude CodeUntestedEstimatedCodex CLIUntestedEstimatedGemini CLIUntestedEstimatedClineUntestedEstimatedAiderUntestedEstimatedOpenCodeUntestedEstimated

Requirements

Runtime: Standalone binary / package-managed CLI
Platforms: macOS, Linux (arm64, x86_64)
Approx. Size (estimated): ~29 MB

Permissions

Network: Yes
Filesystem: Read/Write
Credentials: PGHOST, PGUSER, PGPASSWORD, PGDATABASE
Ports: Not declared

Safe Execution

This CLI has broad system access. Recommended: run inside a container/sandbox.

Listing Stats

Queries/Week: 67.8
Trust Score: 74.0
Last Verified: 2/17/2026, 6:52:34 PM
Last Updated: 2/17/2026, 6:52:34 PM
Website: https://www.postgresql.org/docs/current/app-psql.html

Version Feed

Version: #1
ID: lv_psql_1
Updated: 2/17/2026, 6:52:34 PM
Changes: commands, auth, install

Report Issue

CLI Profile

Loading CLI profile...

Fetching install matrix, auth flow, command map, and compatibility data.

Please wait while clime prepares the listing details.