← Back to tools

pgcli

Postgres CLI with autocompletion and syntax highlighting

Homepage
Data & JSON linuxmacoswindows Python BSD-3-Clause

Description

pgcli is a command line interface for PostgreSQL with autocompletion and syntax highlighting. It offers context-aware completions for SQL keywords, tables, views, columns, and functions, making database interaction more efficient.

AI Summary

A PostgreSQL CLI with smart autocompletion and syntax highlighting.

Capabilities

  • + Auto-complete PostgreSQL keywords, tables, columns, and functions
  • + Syntax highlighting for SQL queries
  • + Multi-line query editing
  • + Output formatting options

Use When

  • → You work with PostgreSQL databases from the terminal
  • → You want better autocompletion than psql

Avoid When

  • x You need a GUI database management tool
  • x You don't use PostgreSQL
View AGENTS.md for pgcli