AI/ML●●Solid
Pglens – 27 read-only PostgreSQL tools for AI agents via MCP
Stops AI hallucination with `column_values` and `find_join_path` instead of generic query tools.
Solve My ProblemNiche Gem
jeeybee
1372mo ago
Back to browse
GitHub Repository
14 starsPython
Pglens – Postgres MCP server that lets agents look before they query
by jeeybee·Mar 23, 2026·3 points·0 comments
AI Analysis
●●SolidNiche GemSolve My Problem
Postgres MCP server that lets agents inspect column values before writing queries.
Strengths
- •`column_values` tool prevents agents from hallucinating enum values like 'active'.
- •`find_join_path` automatically discovers multi-hop FK relationships for complex queries.
- •Read-only safety caps prevent agents from dropping tables accidentally.
Weaknesses
- •MCP ecosystem is still nascent, limiting immediate utility for many developers.
- •Limited to PostgreSQL, excludes MySQL and SQLite users entirely.
Category
Target Audience
Backend developers, AI engineers
Similar To
LangChain · Vanna AI · MindsDB
Similar Projects
Developer Tools●●●Banger
DB9 – Postgres, but for Agents
Postgres with database branching and pgvector built-in, designed for agents to use autonomously.
Big BrainSlick
c4pt0r
203mo ago
Developer Tools●●Solid
Monolith, live typed queries on real Postgres for Java (no JDBC)
Compile-time generated invalidation rules that walk JOINs for precise reactive updates.
Big BrainWizardry
uday_singlr
3112d ago
Developer Tools●●Solid
Pgcraft – a lazygit-style TUI for Postgres
Native Postgres TUI digs into pg_stat_* where generic tools like lazysql stop.
Niche GemSolve My Problem
lucasfrederico
6018d ago
Infrastructure●●Solid
Polynya – Turn your Postgres into workspaces for AI
Ephemeral ClickHouse on demand beats Kafka pipelines — but early access limits confidence.
Big BrainShip It
hasyimibhar
501mo ago
Developer Tools●●Solid
Pg_dbml – A dependency-free CLI to export Postgres to DBML
Pure SQL introspection means zero driver hell when exporting Postgres schemas to DBML.
Solve My ProblemShip It
heptau
101mo ago