PostgreSQL MCP Server

MIT License

Overview InspectNew Schema Related Servers Reviews Score

execute_custom_query

Run custom SQL queries on PostgreSQL databases using a secure connection. Manage schemas, debug issues, migrate data, and monitor performance with controlled access and optional query timeout.

Instructions

Execute a custom SQL query against the database. WARNING: Use with care. Do not expose to untrusted input.

Input Schema

Name	Required	Description
`connectionString`	Yes	PostgreSQL connection string
`query`	Yes	SQL query to execute
`timeout`	No	Optional query timeout in milliseconds
`values`	No	Optional parameter values for the query

Input Schema (JSON Schema)

{
  "properties": {
    "connectionString": {
      "description": "PostgreSQL connection string",
      "type": "string"
    },
    "query": {
      "description": "SQL query to execute",
      "type": "string"
    },
    "timeout": {
      "description": "Optional query timeout in milliseconds",
      "type": "number"
    },
    "values": {
      "description": "Optional parameter values for the query",
      "items": {
        "type": "string"
      },
      "type": "array"
    }
  },
  "required": [
    "connectionString",
    "query"
  ],
  "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/1Levick3/postgresql-mcp-server'

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