Skip to main content
Glama

PostgreSQL MCP Server

by cesarvarela

query-table

Retrieve data from PostgreSQL tables with customizable filters, sorting, and pagination using WHERE conditions, exact matches, arrays, and LIKE patterns.

Instructions

Query data from a specific table with filtering, pagination, and sorting. Supports WHERE conditions with exact matches, arrays (IN), and LIKE patterns.

Input Schema

NameRequiredDescriptionDefault
columnsNo
paginationNo
sortNo
tableYes
whereNo

Input Schema (JSON Schema)

{ "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "properties": { "columns": { "items": { "minLength": 1, "type": "string" }, "type": "array" }, "pagination": { "additionalProperties": false, "properties": { "limit": { "default": 50, "maximum": 1000, "minimum": 1, "type": "integer" }, "offset": { "default": 0, "minimum": 0, "type": "integer" } }, "type": "object" }, "sort": { "additionalProperties": false, "properties": { "column": { "minLength": 1, "type": "string" }, "direction": { "default": "ASC", "enum": [ "ASC", "DESC" ], "type": "string" } }, "required": [ "column" ], "type": "object" }, "table": { "minLength": 1, "type": "string" }, "where": { "additionalProperties": {}, "type": "object" } }, "required": [ "table" ], "type": "object" }
Install Server

Other Tools from PostgreSQL MCP Server

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/cesarvarela/postgres-mcp'

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