Skip to main content
Glama

MCP PostgreSQL Server

query

Run SQL SELECT queries on PostgreSQL databases with parameterized inputs to retrieve specific data, enabling efficient database interactions for AI models via the MCP PostgreSQL Server.

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

You must be authenticated.

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