Skip to content

pgchat v1.0.0 — Initial Release

Latest

Choose a tag to compare

@icon-gaurav icon-gaurav released this 02 Jul 08:12
59ba209

What's New

First public release of pgchat — a CLI tool for chatting with your PostgreSQL database using LangChain and Ollama. This release establishes the core architecture: a single SQL execution gateway, startup-time schema caching, and file-based session memory.

Added

  • Natural language querying against PostgreSQL via Ollama-backed LangChain agent
  • Single SQL execution gateway (execute_sql() in db.py) — all queries route through one function for consistency and auditability
  • Startup schema cache — table structures, columns, foreign keys, and stats are fetched once at initialization and injected into the system prompt for context-aware querying
  • /refresh-schema command for manual schema cache refresh mid-session
  • JSON file-based session memory for conversation continuity across runs
  • MIT licensed

Install:

pip install pgchat

Full Changelog: https://github.com/icon-gaurav/pgchat/commits/v1.0.0