mcpField
S
Sezzlee PostgreSQL

Sezzlee PostgreSQL

Local
docs.sezzlee.appDatabases1Updated today
RepositoryVisit website

About Sezzlee PostgreSQL

Sezzlee PostgreSQL is a read-only MCP server for exploring PostgreSQL catalogs, schemas and query results. It uses read-only transactions, bounded cursor batches and safeguards around query execution.

Key features

  1. 01Describe database connections
  2. 02Search catalog objects
  3. 03Inspect tables, columns and constraints
  4. 04Run bounded read-only queries
  5. 05Stream rows in batches of up to 128

Use cases

  1. 01Find readable tables and views
  2. 02Inspect a table's columns and constraints
  3. 03Query permitted data without changing it

MCP support

Exposes connection description, catalog search, table inspection and query tools to MCP clients. Each request runs in a read-only transaction that is rolled back afterward.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

mcp.json · Universal config
{
  "mcpServers": {
    "sezzlee-postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@sezzlee/postgres-mcp"
      ],
      "env": {
        "SEZZLEE_POSTGRES_SERVER": "<SEZZLEE_POSTGRES_SERVER>",
        "SEZZLEE_POSTGRES_PORT": "<SEZZLEE_POSTGRES_PORT>",
        "SEZZLEE_POSTGRES_DATABASE": "<SEZZLEE_POSTGRES_DATABASE>",
        "SEZZLEE_POSTGRES_USER": "<SEZZLEE_POSTGRES_USER>",
        "SEZZLEE_POSTGRES_PASSWORD": "<SEZZLEE_POSTGRES_PASSWORD>",
        "SEZZLEE_POSTGRES_SSL_MODE": "<SEZZLEE_POSTGRES_SSL_MODE>",
        "SEZZLEE_POSTGRES_CONNECT_TIMEOUT_MS": "<SEZZLEE_POSTGRES_CONNECT_TIMEOUT_MS>",
        "SEZZLEE_POSTGRES_QUERY_TIMEOUT_MS": "<SEZZLEE_POSTGRES_QUERY_TIMEOUT_MS>"
      }
    }
  }
}
Run commandnpx -y @sezzlee/postgres-mcp
Environment variables to set
SEZZLEE_POSTGRES_SERVERDatabase host
SEZZLEE_POSTGRES_PORTDatabase port
SEZZLEE_POSTGRES_DATABASEDatabase name
SEZZLEE_POSTGRES_USERLogin of a read-only principal
SEZZLEE_POSTGRES_PASSWORDSecretPassword of that login
SEZZLEE_POSTGRES_SSL_MODETLS mode
SEZZLEE_POSTGRES_CONNECT_TIMEOUT_MSConnect timeout in milliseconds
SEZZLEE_POSTGRES_QUERY_TIMEOUT_MSQuery timeout in milliseconds

Local servers need a runtime on your machine (e.g. Node.js 18+). Config file locations differ by client; see your client’s docs.

Packages
npm@sezzlee/postgres-mcp0.2.1

Tools

4

Saved tool list · updated 2w ago

This tool takes no parameters.

Details

The maintainer has not added details yet. Check the README in the repository.

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.