Skip to main content
Glama

MCP PostgreSQL Server

query

Execute SQL SELECT queries on PostgreSQL databases using parameterized inputs. Enables AI models to interact with data through standardized database operations.

Instructions

Execute a SELECT query

Input Schema

NameRequiredDescriptionDefault
paramsNoQuery parameters (optional)
sqlYesSQL SELECT query (use $1, $2, etc. for parameters)

Input Schema (JSON Schema)

{ "properties": { "params": { "description": "Query parameters (optional)", "items": { "type": [ "string", "number", "boolean", "null" ] }, "type": "array" }, "sql": { "description": "SQL SELECT query (use $1, $2, etc. for parameters)", "type": "string" } }, "required": [ "sql" ], "type": "object" }

Other Tools from MCP PostgreSQL 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/antonorlov/mcp-postgres-server'

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