PostgreSQL MCP Server

execute_query

Run read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH) on PostgreSQL databases, with optional row limits, to retrieve or analyze data securely.

Instructions

Execute a read-only SQL query (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH statements only)

Input Schema

Name	Required	Description	Default
`limit`	No	Maximum number of rows to return (default: 100)
`query`	Yes	SQL query to execute (read-only operations only)

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "limit": {
      "description": "Maximum number of rows to return (default: 100)",
      "type": "number"
    },
    "query": {
      "description": "SQL query to execute (read-only operations only)",
      "type": "string"
    }
  },
  "required": [
    "query"
  ],
  "type": "object"
}

This server cannot be installed

Related Tools

query-postgres
@RathodDarshil/mcp-postgres-query-server
query
@modelcontextprotocol/postgresql
execute_query
@perrypixel/Simple-Postgres-MCP
execute_custom_query
@1Levick3/postgresql-mcp-server
pg_execute_query
@HenkDz/postgresql-mcp-server
steampipe_query
@turbot/steampipe-mcp

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/melihbirim/pg-mcp'

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