app like that
pgchat
pgchat

A chat agent for your Postgres database that allows you to chat with your database schema securely. It supports complex queries, lets you review and approve queries before execution, and can be used locally or in a private subnet.

Features

Chat with Postgres

Allows you to interact with your Postgres database without exposing connection strings, providing secure database communication.

Agent dynamically learns database schema

The agent can learn your database schema dynamically as you chat, allowing for more intuitive interactions.

Sample complex queries

Supports sampling complex queries and data-modifying operations, enabling you to perform advanced database operations easily.

Approval mode for queries

Allows you to review and approve queries before they are executed, ensuring that no unwanted operations are performed on your database.

Retrieve data locally

Enables you to return data to your terminal directly without sending it to the model, offering increased privacy and control over your data.

Deployment options

Works locally or can be deployed in a private subnet, providing flexibility in how and where you use the tool.