MCP Postgres Server

Overview InspectNew Endpoints Schema Related Servers Reviews Score

query

Execute SQL queries securely with pagination and parameterization, returning up to 500 rows per page on the MCP Postgres Server.

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"
}

This server cannot be installed

Related Tools

query
@Maxim2324/mcp-server-test
execute_sql
@crystaldba/postgres-mcp
execute-query
@NakiriYuuzu/Mssql-Mcp
query_data
@sam2332/mcp-quick-sqlite3
read_data
@EvilPhatBoi/McpSqlServer
execute_sql
@RichardHan/mssql_mcp_server

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