psql

Run PostgreSQL queries from the CLI by executing the query script with bun and passing your SQL statement as an argument. This approach enables ad-hoc data exploration and routine database administration directly from the terminal.

Yes, you can execute SQL migration files against a PostgreSQL database by running the query script with the --file flag followed by the migration path. This processes batch changes and schema migrations seamlessly.

Configure PostgreSQL connection variables for CLI access by setting environment variables like PGHOST, PGDATABASE, PGUSER, and PGPASSWORD. This environment-based access enables seamless database connections without persistent sessions.

Yes, you need the bun runtime and the psql client installed to run psql meta-commands. This Skill leverages bun to execute the underlying scripts that interface with your PostgreSQL database.

The best way to inspect a database schema from the terminal is using psql meta-commands through this CLI Skill. It supports schema inspection by passing meta-commands directly without maintaining a persistent connection.

No, this approach does not maintain a persistent connection to the PostgreSQL database. It executes individual queries and psql meta-commands directly from the CLI for ad-hoc data exploration and administration.