psql — PostgreSQL's interactive terminal client and SQL script runner (the psql command). Covers connection strings/URIs, ~/.pgpass & service files, invocation flags (-c/-f/-1/--csv/-qAtX/-v), the \d-family inspection meta-commands, \copy, \watch, \gexec/\gset, \if scripting, \pset output formats & \x, variables & :'…' interpolation, .psqlrc, exit codes/ON_ERROR_STOP, and extended-protocol/pipeline commands (\bind/\parse/\startpipeline). Use when connecting to or inspecting a Postgres database from a terminal, running SQL scripts or one-off queries in shells/CI/agents, formatting or capturing query output, or fixing psql connection/auth problems. Includes inline (pgNN+) version annotations (pg14–pg19). This is the psql CLIENT only — for SQL syntax/data types use postgres-sql; for EXPLAIN/indexes/vacuum use postgres-performance; for server config/auth/backup/replication use postgres-admin; for CREATE EXTENSION use postgres-extensions.
How to install psql?
dashed/claude-marketplace/psql
$npx -y skills add dashed/claude-marketplace --skill psqlInstalls into the current project.
›Prefer a prompt? Paste this to your agent
Run `npx skills use "https://github.com/dashed/claude-marketplace" --skill "dashed/claude-marketplace/psql"` and follow the generated skill instructions now. Read its complete output, redirecting it to a temporary file first if necessary. Resolve relative paths from the supporting-files directory it provides.
Use the skills in "https://github.com/dashed/claude-marketplace" that are relevant to the current task. Run `npx skills add "https://github.com/dashed/claude-marketplace"` and select the relevant skills, then follow their instructions.
Related
6 picksType
- supabase-postgres-best-practicesPostgres performance optimization and best practices from Supabase.Jul 2026
- firebase-data-connect-basicsBuilds and deploys Firebase SQL Connect (aka Firebase Data Connect) backends with PostgreSQL securely.Jul 2026
- firebase-firestoreSets up, manages, queries, and configures Cloud Firestore databases (Standard/Enterprise edition), including data modeling, security rules, indexes, and SDK…Jul 2026
- prisma-database-setupGuides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).Jul 2026
- prisma-client-apiPrisma Client API reference covering model queries, filters, operators, and client methods.Jul 2026
- prisma-cliPrisma ORM CLI commands reference covering init, generate, migrate, db, dev, studio, validate, format, debug, and mcp.Jul 2026
