from Hacker News

Show HN: Pgchat – One command to chat with any Postgres database

by johnjcsmith on 1/29/25, 10:23 PM with 0 comments

Hey HN,

Sharing a project we have been working on which provides an LLM-powered chat experience for querying Postgres databases (local or remote).

pgchat takes a Postgres connection string and spawns a terminal UI for the chat:

`npx pgchat postgresql://xxxx`

It is built on top of our other project Inferable [1] which handles the LLM requests (open source / self hostable).

Database queries are issued from the pgchat process to the connection string which allows for use with local Postgres instances.

Keen to hear your thoughts!

[1] https://github.com/inferablehq/inferable