Back to browse
GitHub Repository
14 starsPython

Pglens – 27 read-only PostgreSQL tools for AI agents via MCP

by jeeybee·Mar 29, 2026·13 points·7 comments

AI Analysis

●●SolidSolve My ProblemNiche Gem

Stops AI hallucination with `column_values` and `find_join_path` instead of generic query tools.

Strengths
  • `find_join_path` automates relationship discovery so agents don't guess foreign keys manually.
  • `column_values` returns distinct values so agents stop hallucinating enum states incorrectly.
  • Read-only safety caps prevent agents from accidentally dropping tables during exploration.
Weaknesses
  • Only supports PostgreSQL, excluding MySQL and SQLite users building similar workflows.
  • Early repo with only six commits and minimal documentation beyond the README.
Category
Target Audience

Developers building AI agents that interact with PostgreSQL databases

Similar To

LangChain · Vanna AI · Defog AI

Similar Projects