AI · alternatives · 2026
24 alternatives to Pglens – 27 read-only PostgreSQL tools for AI agents via MCP
Contribute to janbjorge/pglens development by creating an account on GitHub.
Pglens is a collection of 27 read-only PostgreSQL tools designed for AI agents using the Model Context Protocol (MCP). It enables AI systems to query and interact with PostgreSQL databases without write access, making… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes.
- 1
Hey HN, I built pg-mcp, a Model Context Protocol (MCP) server for PostgreSQL that provides structured schema inspection and query execution for LLMs and agents. It's multi-tenant and runs over HTTP/SSE (not stdio) Features - Supports multiple database connections from multiple agents - Schema Introspection: Returns table structures, types, indexes and constraints; enriched with descriptions from pg_catalog. (for well documented databases) - Read-Only Queries: Controlled execution of queries via MCP. - EXPLAIN Tool: Helps smart agents optimize queries before execution. - Extension…
2025 · github.com · its alternatives →
- 2
PgQueuer is a Python job queue that uses PostgreSQL for everything — queue storage, locking, notifications. No Redis, no RabbitMQ, no separate broker to operate. If your app already has Postgres, you already have the broker. After ~2 years and 26 minor releases, 1.0 ships today as the first stable release. Strict semver from here on. Thanks to everyone who contributed and left feedback!
2024 · github.com · its alternatives →
- 3
postgres.new▲774The in-browser Postgres sandbox with AI assistance
2024 · database.build · its alternatives →
- 4
- 5
SnapQL is an open-source desktop app (built with Electron) that lets you query your Postgres database using natural language. It’s schema-aware, so you don’t need to copy-paste your schema or write complex SQL by hand. Everything runs locally — your OpenAI API key, your data, and your queries — so it's secure and private. Just connect your DB, describe what you want, and SnapQL writes and runs the SQL for you.
2025 · github.com · its alternatives →
- 6
Pylar▲502Hey HN! We're Hoshang & Vishal, the team behind Pylar - a governed access layer between databases and LLMs. We previously led data and AI and we kept seeing the same problem across teams using LLMs internally: agents are great with unstructured data, but the moment you want them touching your actual systems of record — Snowflake, Postgres, CRMs, product DBs — everything becomes fragile, risky, or outright unsafe. Two issues show up every single time: 1. Agents over-querying They don’t understand cost. They’ll happily generate queries that blow up your warehouse bill. 2. Accidental data…
Dec 2025 · pylar.ai · its alternatives →
- 7
Hey all, I'm the creator of @pg-nano/pg-parser. I'm using it in pg-nano[1] to statically analyze Postgres schemas spread across multiple SQL files for a couple of reasons: 1. Each CREATE statement needs to be in topological order, so pg-nano's dev command can execute them without issue. 2. pg-nano has a plugin system like Vite that allows SQL generation based on the parsed schema. Probably to the surprise of no one, working with an untyped AST feels like you're back in the days of JavaScript, because well... you are. Most of you know by now just how great TypeScript and static types in…
2024 · github.com · its alternatives →
- 8
Hi HN, Been hacking on a simple way to run agents entirely inside of a Postgres database, "an agent per row". Things you could build with this: * Your own agent orchestrator * A personal assistant with time travel * (more things I can't think of yet) Not quite there yet but thought I'd share it in its current state.
Feb 2026 · github.com · its alternatives →
- 9
This extension let's you write PRQL functions in PostgreSQL. When I first saw PRQL on Hacker News a few months ago, I was immediately captivated by the idea, yet equally disappointed that there was no integration for PostgreSQL. Having previous experience with writing PostgreSQL extensions in C, I thought this was a great opportunity to try out the pgrx framework and decided to integrate PRQL with PostgreSQL myself. The maintainers of both PRQL and pgrx were very nice to work with. Thanks guys.
2024 · github.com · its alternatives →
- 10
Hi HN! We're Evgeny and Arjun, and we’re building a better way to do analytics with Postgres. We love Postgres for its simplicity, power, and rich ecosystem. But engineers have to still get bogged down with heavyweight and expensive OLAP systems when connecting an analytics data stack. Postgres is amazing at OLTP queries, but not for OLAP queries (large data scans and aggregations). Even in this case, we’ve still heard from countless scaling startups that they still try to use only a read replica to run analytics workloads since they don’t want to deal with the data engineering complexity of…
2024 · github.com · its alternatives →
- 11
Throughout my career, I tried many tools to query PostgreSQL, and in the end, concluded that for what I do, the simplest is almost always the best: raw SQL queries. Until now, I typed the results manually and relied on tests to catch problems. While this is OK in e.g., GoLang, it is quite annoying in TypeScript. First, because of the more powerful type system (it's easier to guess that updated_at is a date than it is to guess whether it's nullable or not), second, because of idiosyncrasies (INT4s are deserialised as JS numbers, but INT8s are deserialised as strings). So I wrote pg-typesafe,…
Feb 2026 · github.com · its alternatives →
- 12
GraphQL for Postgres. Contribute to solidsnack/GraphpostgresQL development by creating an account on GitHub.
2015 · github.com · its alternatives →
- 13PE
2018 · bluejekyll.github.io · its alternatives →
- 14
Happy Cyber Monday!
2014 · psequel.com · its alternatives →
- 15
- 16
open-source agentic AI data assistant for the next generation of AI + Data products. - eosphoros-ai/DB-GPT
2023 · github.com · its alternatives →
- 17
Hyperterse▲86Hi HN, I’m Samrith, creator of Hyperterse. Today I’m launching Hyperterse 2.0, a schema-first framework for building MCP servers directly on top of your existing production databases. If you're building AI agents in production, you’ve probably run into agents needing access to structured, reliable data but wiring your business logic to MCP tools is tedious. Most teams end up writing fragile glue code. Or worse, giving agents unsafe, overbroad access. There isn’t a clean, principled way to expose just the right data surface to agents. Hyperterse lets you define a schema over your data and…
Feb 2026 · hyperterse.com · its alternatives →
- 18
SchemaFlow▲128Real-time database schemas for AI-IDEs via MCP protocol
2025 · schemaflow.dev · its alternatives →
- 19
Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.
2024 · github.com · its alternatives →
- 20
Hi HN. This is a project I've been building for the last month. It's a macOS postgres client that uses your OpenAI key to generate and immediately execute queries against your database locally on your machine. I imagine the user being someone familiar with SQL and able to identify errors in the generated code, but regularly needs to write queries to answer relatively simple questions. This is my first software project I'm intending on selling myself and would love feedback on the product and landing page. I'd also love ideas on how to market it to users, as I'm very new to this. In the near…
2023 · pgmagic.app · its alternatives →
- 21
Hey HN, Postgres Pro is an open source Model Context Protocol (MCP) server built to support every stage of the development process. It does a lot more than help generate and run SQL—it helps you make sure your application and database actually run well. Features: - Industrial-strength tuning algorithms similar to those in MS SQL Server - “What if?” tool to evaluate LLM-generated index suggestions - Works with Cursor, etc., to make changes in ORM code - Ensures safe SQL execution with restricted mode - Includes health checks to stay ahead of production problems
2025 · github.com · its alternatives →
- 22
Postquel▲70A fast, native PostgreSQL client for macOS, with an AI assistant that uses the Claude Code, Codex or Cursor account already on your Mac.
18d ago · frizky.dev · its alternatives →
- 23
- 24
Experimental extension that brings OpenAI API to your PostgreSQL to run queries in human language. - cloudquery/pg_gpt
2023 · github.com · its alternatives →
Also compare
Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →