psql-style commands
Use \dt, \d, \l, \x, \timing, \c and \conninfo.
Shell (psql+) · daily shell
A smarter PostgreSQL shell with AI built in
Shell (psql+) is a native PostgreSQL CLI with psql-style commands, schema-aware autocomplete, beautiful terminal help, and AI assistance for understanding queries and PostgreSQL errors.
psql+ is included with every Rillence subscription.
app+> SELECT email, count(*)
app-> FROM users
app-> GROUP BY id;
ERROR: column "users.email" must appear
in the GROUP BY clause
app+> \+ fix last_error
psql+ AI Every selected column must either be
grouped or aggregated. Add email to GROUP BY,
or aggregate it.
Native PostgreSQL shell
Familiar psql, made faster
psql+ is a native shell for developers who live in the terminal. It keeps the psql workflow you already know, then adds schema-aware autocomplete and AI help so you spend less time fighting syntax and errors.
- Connect to your own PostgreSQL databases
- Keep your psql habits and meta-commands
- Ask AI for help without leaving the shell
What's inside
Everything you need in a daily shell
Schema-aware autocomplete
Complete SQL keywords, commands, databases, tables and columns.
AI explain / fix / ask
Understand queries and PostgreSQL errors in context, right in the shell.
Privacy-aware by design
SQL can be redacted and query result rows are not sent by default.
AI in the shell
Explain, fix and ask — in context
The AI commands work on what you just did, so you don't have to copy queries or errors anywhere else.
\+ explain last— explain the last query\+ fix last_error— suggest a fix for the last error\+ ask "why is this slow?"— ask in plain language
AI usage is configurable. By default, query result rows aren't sent and SQL can be redacted — psql+ is built around minimal context.
app+> \+ explain last
psql+ AI This query reads the first rows from
users with no filter, so it returns whatever
order Postgres scans them in.
app+> \+ ask "add an index for email lookups?"
psql+ AI If you filter by email often, a
btree index on users(email) will help equality and
prefix lookups.
FAQ
psql+ questions, answered
Does psql+ replace psql?
psql+ supports familiar psql-style workflows, but we don't describe it as a full drop-in replacement for psql.
Which databases does it connect to?
Your own PostgreSQL databases. psql+ is a native client, not a sandbox.
Is the AI required?
No. The shell works without AI. The \+ explain / fix / ask commands are optional and configurable.
Are my query results sent to AI?
Query result rows are not sent by default. psql+ is designed around minimal context, SQL redaction and configurable AI usage.
Is psql+ sold separately from pgpg?
No. psql+ ships together with pgpg in one Rillence annual subscription.
Also included: pgpg
Explore pgpg →
Practice the incidents you don't want to meet in production
psql+ helps you work faster every day. pgpg helps you practice the incidents you do not want to meet first in production.
Work faster in Postgres every day
One annual subscription includes both pgpg and psql+.