Sezzlee PostgreSQL

Lets an assistant explore a PostgreSQL database read-only: search the catalog, inspect schemas, and run bounded SELECT queries.

What you can do

A local stdio MCP server exposing four tools: describe_connection, search_catalog, describe_table, and run_query. Catalog introspection covers readable tables, partitions, foreign tables, views and materialized views, column and table descriptions, and primary, unique and foreign constraints. Every query runs in its own read-only transaction with statement and lock deadlines and always ends in ROLLBACK, and results arrive through server cursors in batches of at most 128 rows.

When to use it

Useful when an assistant needs to answer questions about an existing PostgreSQL schema or read data without any risk of writes. It suits exploration, schema documentation, and ad-hoc read-only reporting against a database you can point it at.

Requirements

Runs locally over stdio as the npm package @sezzlee/postgres-mcp, so Node.js is needed. Required environment variables: SEZZLEE_POSTGRES_SERVER, SEZZLEE_POSTGRES_DATABASE, SEZZLEE_POSTGRES_USER, and the secret SEZZLEE_POSTGRES_PASSWORD. Optional: SEZZLEE_POSTGRES_PORT, SEZZLEE_POSTGRES_SSL_MODE (default verify-full), SEZZLEE_POSTGRES_CONNECT_TIMEOUT_MS, SEZZLEE_POSTGRES_QUERY_TIMEOUT_MS. Network access to the database host is required; desktop only.