dbcli/pgcli

View on GitHub

Postgres CLI with autocompletion and syntax highlighting

Stars: 13.4k
Forks: 612
Open beginner issues: 0
Indexed issues: 27
Avg merge: 6d 14h
Merged PRs (30d): 10

Dominant language: Python
License: BSD-3-Clause
Last GitHub push: Sep 9, 2026
Latest indexed: Sep 15, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: help wanted

Open All

27 open issues indexed

NoneType exception in get_completions() Open

bug help wanted

dbcli/pgcli#1204 · 6 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
`\ef` in a transaction causes pgcli to crash Open

dbcli/pgcli#1392 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
The query result is messed up in Chinese Open

dbcli/pgcli#1411 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Not working on windows 11 Open

dbcli/pgcli#1413 · 16 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
\d+ doesn't show options of a table while psql does Open

dbcli/pgcli#1414 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Connecting via unix socket on a specific DB crashes pgcli Open

dbcli/pgcli#1422 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add a way to edit named queries from an external editor Open

feature request

dbcli/pgcli#1430 · 2 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
Using environment variables to connect via ssh Open

feature request

dbcli/pgcli#1433 · 5 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Tab completion not working in version 4.0.1 on macOS Open

dbcli/pgcli#1448 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Unable to use `pgcli service={service}` Open

dbcli/pgcli#1474 · 3 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
Distribute binary packages when tagging new versions Open

enhancement

dbcli/pgcli#1475 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
\d+ metacommand doesn't indicate the name/type of what it's displaying Open

enhancement

dbcli/pgcli#1478 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
pgcli crashes when using use directive Open

bug

dbcli/pgcli#1484 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Function syntax highlighting \sf Open

feature request

dbcli/pgcli#1488 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Log and history should go to $XDG_STATE_HOME instead of $XDG_CONFIG_HOME Open

enhancement

dbcli/pgcli#1497 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Debian install docs issues Open

dbcli/pgcli#1498 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Use an incorrect copy command syntax copy instead of \copy and cannot quit app. Open

bug

dbcli/pgcli#1505 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
pgcli couldn't parse password that contained character '#' Open

dbcli/pgcli#1512 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
startup crashes on `TypeError: replace() argument 2 must be str, not bytes`, followed by `TypeError: cannot use a string pattern on a bytes-like object` Open

bug

dbcli/pgcli#1518 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
\d with wildcards doesn't say which table is which Open

bug

dbcli/pgcli#1521 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Feature request: easily list/explore all objects (in schema) Open

feature request

dbcli/pgcli#1586 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Feature request: Complete suggestions using "l" in Vi mode Open

dbcli/pgcli#1606 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Cancelling query send does not cancel query Open

dbcli/pgcli#1607 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Ctrl-u cuts the line, but Ctrl-y doesn't put it back in Vi-mode Open

dbcli/pgcli#1608 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Feature Request: show service name in prompt Open

dbcli/pgcli#1624 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
`changelog.rst` is difficult to find Open

dbcli/pgcli#1627 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Replace the pgclirc ConfigObj parser while preserving configuration compatibility Open

dbcli/pgcli#1634 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026

dbcli/pgcli

Get new issues in your inbox