MCP Postgres Server

Overview InspectNew Schema Related Servers Reviews Score

query

Execute SQL queries, with pagination and parameterization for secure database exploration on PostgreSQL, supporting up to 500 rows per page.

Instructions

Execute SQL queries with pagination support and parameterization for security. Supports page sizes up to 500 rows.

Input Schema

Name	Required	Description
`offset`	No	Number of rows to skip for pagination
`pageSize`	No	Number of rows to return (1-500, default: 100)
`parameters`	No	Optional array of parameters for parameterized queries
`sql`	Yes

Input Schema (JSON Schema)

{
  "additionalProperties": false,
  "properties": {
    "offset": {
      "description": "Number of rows to skip for pagination",
      "minimum": 0,
      "type": "number"
    },
    "pageSize": {
      "description": "Number of rows to return (1-500, default: 100)",
      "maximum": 500,
      "minimum": 1,
      "type": "number"
    },
    "parameters": {
      "description": "Optional array of parameters for parameterized queries",
      "items": {
        "type": [
          "string",
          "number",
          "boolean",
          "null"
        ]
      },
      "type": "array"
    },
    "sql": {
      "maxLength": 50000,
      "minLength": 1,
      "type": "string"
    }
  },
  "required": [
    "sql"
  ],
  "type": "object"
}

Install Server

HTTP connection URL

Related Tools

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/MadeByNando/mcp-postgres-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server