MCP PostgreSQL Server

by antonorlov

Verified

Databases

JavaScript

Reddit Discord

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

execute

Execute an INSERT, UPDATE, or DELETE query

Input Schema

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