MCP PostgreSQL Server

by antonorlov

Verified

Databases

JavaScript

Reddit Discord

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

query

Execute a SELECT query

Input Schema

Name	Required	Description	Default
`params`	No	Query parameters (optional)
`sql`	Yes	SQL 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

describe_table
list_tables
connect_db
query
execute