Simple PostgreSQL MCP Server

execute_query

Run SQL queries on a PostgreSQL database, with configurable read-only or write permissions, using the Simple PostgreSQL MCP Server.

Instructions

Execute SQL queries on PostgreSQL database

Input Schema

Name	Required	Description	Default
`query`	Yes	SQL query to execute
`readOnly`	No	If true, only allows read-only queries (SELECT, EXPLAIN, etc.)

Input Schema (JSON Schema)

{
  "properties": {
    "query": {
      "description": "SQL query to execute",
      "type": "string"
    },
    "readOnly": {
      "default": false,
      "description": "If true, only allows read-only queries (SELECT, EXPLAIN, etc.)",
      "type": "boolean"
    }
  },
  "required": [
    "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/perrypixel/Simple-Postgres-MCP'

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