# amitte/postgres-tools

> Read-only Postgres surface — list_tables, describe_table, run_select. SQL is parsed with pg_query to reject INSERT / UPDATE / DELETE; row caps enforced.

## Identity

- **Type:** mcp-server
- **Version:** 0.1.0
- **Trust tier:** official
- **License:** Apache-2.0
- **Authors:** Amitte Maintainers
- **Repo / bundle:** amitte/showcase
- **Canonical URL:** https://amitte.com/s/amitte/postgres-tools

## Tags

- **Capabilities:** tables-list, table-describe, select-only
- **Domains:** databases, sql

## Evaluation

- **Adversarial score:** 95/100
- **Content score:** 82/100

## Endpoints

- **service-backed** `postgres-tools` → https://mcp.amitte.com/v1/postgres-tools/sse — Remote MCP server fronting Postgres via a registry-managed read-only role. Targets Claude Desktop, Cursor, VS Code.
  - tool: `list_tables` — Read-only. List user tables in a schema; returns name, type, row estimate.
  - tool: `describe_table` — Read-only. Describe a table — columns, types, nullability, defaults, primary key, indexes.
  - tool: `run_select` — Read-only. Run a parameterised SELECT (or WITH ... SELECT). The SQL is parsed with pg_query; any non-read statement is rejected. Hard cap of 500 rows or 5MB per call.

## Programmatic access

- Fetch JSON-RPC: `POST https://registry.amitte.com/rpc` with `{ "method": "fetch", "params": { "id": "amitte/postgres-tools" } }`
- Install via CLI: `amitte install amitte/postgres-tools`
- HTML page: https://amitte.com/s/amitte/postgres-tools

Last updated: 2026-06-08T18:11:08.103Z