ServerData & DatabasesOfficial

Postgres Lens

Safe, read-only Postgres exploration — schema, queries, and EXPLAIN — as MCP tools.

#postgres#sql#database#read-only

Install

With the Zana CLI

$ zana add postgres-lens

Direct (copy-paste fallback)

$ npx -y @zana-mcp/postgres-lens

Environment

DATABASE_URL=postgres connection string (use a read-only role)

Source

catalog/servers/postgres-lens

1 files. Read them here, or pull the folder without the CLI.

Copy the folder

$ npx degit aminitech/amini-zana/catalog/servers/postgres-lens postgres-lens

No clone, no history. Just this folder.

Sparse checkout (private repos, uses your git auth)

$ git clone --depth 1 --filter=blob:none --sparse https://github.com/aminitech/amini-zana.git && cd amini-zana && git sparse-checkout set catalog/servers/postgres-lens

Single file (amini.yaml)

$ curl -sL https://raw.githubusercontent.com/aminitech/amini-zana/main/catalog/servers/postgres-lens/amini.yaml

amini.yaml

Raw

schemaVersion: 1
slug: postgres-lens
name: Postgres Lens
kind: server
category: data-databases
tags: [postgres, sql, database, read-only]
summary: Safe, read-only Postgres exploration — schema, queries, and EXPLAIN — as MCP tools.
description: |
  Give an agent a read-only window into a Postgres database: inspect schema, run
  parameterized SELECTs against a row-limit, and read query plans. Write statements
  are refused by default.
author:
  name: Amini
  handle: amini
  location:
    city: Bridgetown
    country: Barbados
    countryCode: BB
runtime: node
install:
  type: npx
  package: '@zana-mcp/postgres-lens'
  env:
    DATABASE_URL: 'postgres connection string (use a read-only role)'
links:
  repo: https://github.com/zana-dev/zana
flags:
  official: true
  verified: false

About

Give an agent a read-only window into a Postgres database: inspect schema, run parameterized SELECTs against a row-limit, and read query plans. Write statements are refused by default.

repo

Author

Amini · Bridgetown, Barbados