Pgcli Interactive Postgresql Client

Name: Pgcli Interactive Postgresql Client
Author: agentskillexchange

ASecurity

pgcli is an interactive PostgreSQL CLI with context-aware autocompletion, syntax highlighting, and multi-line query editing. Part of the dbcli project with 13k+ GitHub stars, it makes database exploration and query writing dramatically more productive.

36 stars
0 votes
0 copies
2 views
Added June 8, 2026

ai-agentspythongosqlgitdatabasesecurity

Works with

Security analysis

A92/100

mediumInstalls packages at runtime which could introduce malicious dependencies

Pro shows the line behind each finding and how to fix it

Scanned June 8, 2026

npx -y skills add agentskillexchange/skills --skill pgcli-interactive-postgresql-client --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Pgcli Interactive Postgresql Client?

Add the live security badge to your README. It updates with every re-scan.

Security grade badge for Pgcli Interactive Postgresql Client

[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/agentskillexchange-pgcli-interactive-postgresql-client/badge)](https://www.skillsdirectory.com/skills/agentskillexchange-pgcli-interactive-postgresql-client)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro

SKILL.md

---
name: "pgcli Interactive PostgreSQL Client with Autocompletion"
slug: "pgcli-interactive-postgresql-client"
description: "pgcli is an interactive PostgreSQL CLI with context-aware autocompletion, syntax highlighting, and multi-line query editing. Part of the dbcli project with 13k+ GitHub stars, it makes database exploration and query writing dramatically more productive."
github_stars: 13092
verification: "security_reviewed"
source: "https://github.com/dbcli/pgcli"
category: "Developer Tools"
framework: "OpenClaw"
tool_ecosystem:
  github_repo: "dbcli/pgcli"
  github_stars: 13092
---

# pgcli Interactive PostgreSQL Client with Autocompletion

pgcli is an interactive PostgreSQL CLI with context-aware autocompletion, syntax highlighting, and multi-line query editing. Part of the dbcli project with 13k+ GitHub stars, it makes database exploration and query writing dramatically more productive.

## Installation

Use the upstream install or setup path that matches your environment:
- $ pip install -U pgcli
- $ brew install pgcli # Only on macOS
- $ brew install pgcli
- $ pip install pgcli

Requirements and caveats from upstream:
- If you already know how to install python packages, then you can simply do:
- If you don't know how to install python packages, please check the
- .. _prompt_toolkit: https://github.com/jonathanslenders/python-prompt-toolkit

Basic usage or getting-started notes:
- -----------
- ::
- or

- Source: https://github.com/dbcli/pgcli
- Extracted from upstream docs: https://raw.githubusercontent.com/dbcli/pgcli/HEAD/README.rst

## Source

- [Agent Skill Exchange](https://agentskillexchange.com/skills/pgcli-interactive-postgresql-client/)