Shell (psql+)

FAQ

Is psql+ compatible with psql?

Yes. psql+ is a drop-in psql replacement. Every backslash command, connection option, and .psqlrc setting works unchanged — it only adds features on top.

Does the AI see my data?

Only if you turn it on and only what you ask about. AI is opt-in. When you run ??, psql+ sends your last query and the relevant schema context to the provider you configured — never your table data, and never anything until you invoke it. With AI disabled, nothing leaves your machine.

Does psql+ work offline?

Yes. Autocomplete, readable help, history, and full psql compatibility all run locally with no network. Only the ?? AI command needs a connection to your chosen provider.

Will it run or change my data on its own?

No. psql+ only executes the statements you run. The AI assistant suggests and explains; it never runs or mutates anything by itself.

Which PostgreSQL versions are supported?

psql+ speaks the standard PostgreSQL wire protocol, so it connects to current PostgreSQL versions and most compatible managed services, just like psql.

Can I use my own AI provider and key?

Yes. Set the provider and point psql+ at an environment variable holding your key in ~/.config/rillence/config.toml. You can also disable AI entirely. See Configuration.

Can it connect to a pgpg sandbox?

Yes. A pgpg scenario prints a normal connection string; pass it to psql+ like any other database to investigate the sandbox with full autocomplete and help.