PostgreSQL MCP Server

MIT License

Overview InspectNew Schema Related Servers Reviews Score

execute_custom_query

Run custom SQL queries on PostgreSQL databases using the MCP Server. Specify connection strings, queries, and optional parameters for precise database interactions. Use cautiously to avoid security risks.

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