How do I install the Postgresql CLI skill?

Run npx skillmds@latest add melvynx/postgresql-cli in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Postgresql CLI safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Postgresql CLI?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Postgresql CLI free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Postgresql CLI?

melvynx (@melvynx) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Postgresql CLI by melvynx — Agent Skill

Name: Postgresql CLI
Author: melvynx

Postgresql CLI

Manage PostgreSQL databases via CLI - database connections, SQL queries, schema inspection, table descriptions. Use when user mentions 'postgresql', 'postgres', 'database query', 'SQL query', 'database schema', 'table schema', or wants to interact with PostgreSQL databases.

melvynx ca7593a 2.7 KB Updated Sep 17, 2026

File contents

postgresql-cli

Manage PostgreSQL databases from the CLI. Register database connections, run SQL queries, and inspect schemas.

Always use --json when calling programmatically.

Setup

If postgresql-cli is not found, install and build it:

bun --version || curl -fsSL https://bun.sh/install | bash
npx api2cli bundle postgresql
npx api2cli link postgresql

api2cli link adds ~/.local/bin to PATH automatically.

Working Rules

Always use --json for agent-driven calls so downstream steps can parse the result.
Start with --help if the exact action or flags are unclear instead of guessing.
Use schema or describe to understand database structure before writing queries.

Connection Strings

Supports two formats:

Direct URL: postgresql-cli database add prod "postgresql://user:pass@host:5432/db"
Env var name: postgresql-cli database add prod "DATABASE_URL" (reads from environment at runtime)

Connections stored at ~/.config/postgresql-cli/databases.json (chmod 600).

database

Command	Description
`postgresql-cli database add <name> <connection-string> --json`	Register a database connection (URL or env var name)
`postgresql-cli database list --json`	List all registered databases
`postgresql-cli database remove <name> --json`	Remove a registered database
`postgresql-cli database test <name> --json`	Test connection to a registered database
`postgresql-cli database query <name> "<sql>" --json`	Run a SQL query against a database
`postgresql-cli database query <name> "<sql>" --format csv`	Run a SQL query with CSV output
`postgresql-cli database schema <name> --json`	Get full schema (tables, columns, types, constraints, indexes)
`postgresql-cli database tables <name> --json`	List all tables with estimated row counts and sizes
`postgresql-cli database describe <name> <table> --json`	Get detailed schema for a single table

Output Format

--json returns a standardized envelope:

{ "ok": true, "data": [...], "meta": { "total": 42 } }

On error:

{ "ok": false, "error": { "code": 1, "message": "...", "suggestion": "..." } }

Quick Reference

postgresql-cli --help
postgresql-cli database --help
postgresql-cli database <action> --help

Global flags: --json, --format <text|json|csv|yaml>, --verbose, --no-color, --no-header

Exit codes: 0 = success, 1 = API error, 2 = usage error

---name: postgresql-clidescription: Manage PostgreSQL databases via CLI - database connections, SQL queries, schema inspection, table descriptions. Use when user mentions 'postgresql', 'postgres', 'database query', 'SQL query', 'database schema', 'table schema', or wants to interact with PostgreSQL databases.---# postgresql-cliManage PostgreSQL databases from the CLI. Register database connections, run SQL queries, and inspect schemas.Always use `--json` when calling programmatically.## SetupIf `postgresql-cli` is not found, install and build it:```bashbun --version || curl -fsSL https://bun.sh/install | bashnpx api2cli bundle postgresqlnpx api2cli link postgresql````api2cli link` adds `~/.local/bin` to PATH automatically.## Working Rules- Always use `--json` for agent-driven calls so downstream steps can parse the result.- Start with `--help` if the exact action or flags are unclear instead of guessing.- Use `schema` or `describe` to understand database structure before writing queries.## Connection StringsSupports two formats:- Direct URL: `postgresql-cli database add prod "postgresql://user:pass@host:5432/db"`- Env var name: `postgresql-cli database add prod "DATABASE_URL"` (reads from environment at runtime)Connections stored at `~/.config/postgresql-cli/databases.json` (chmod 600).## database| Command | Description ||---------|-------------|| `postgresql-cli database add <name> <connection-string> --json` | Register a database connection (URL or env var name) || `postgresql-cli database list --json` | List all registered databases || `postgresql-cli database remove <name> --json` | Remove a registered database || `postgresql-cli database test <name> --json` | Test connection to a registered database || `postgresql-cli database query <name> "<sql>" --json` | Run a SQL query against a database || `postgresql-cli database query <name> "<sql>" --format csv` | Run a SQL query with CSV output || `postgresql-cli database schema <name> --json` | Get full schema (tables, columns, types, constraints, indexes) || `postgresql-cli database tables <name> --json` | List all tables with estimated row counts and sizes || `postgresql-cli database describe <name> <table> --json` | Get detailed schema for a single table |## Output Format`--json` returns a standardized envelope:```json{ "ok": true, "data": [...], "meta": { "total": 42 } }```On error:```json{ "ok": false, "error": { "code": 1, "message": "...", "suggestion": "..." } }```## Quick Reference```bashpostgresql-cli --helppostgresql-cli database --helppostgresql-cli database <action> --help```Global flags: `--json`, `--format <text|json|csv|yaml>`, `--verbose`, `--no-color`, `--no-header`Exit codes: 0 = success, 1 = API error, 2 = usage error

Frequently asked questions