en es ja ko zh

MCP PostgreSQL Server

by antonorlov

Verified

Databases

JavaScript

MIT License

127

Reddit Discord

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

execute

Run INSERT, UPDATE, or DELETE SQL queries on PostgreSQL databases using query parameters for dynamic execution, enabling direct database manipulation through the MCP PostgreSQL Server interface.

Instructions

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.

Related Tools

execute
@Maxim2324/mcp-server-test
execute_sql
@crystaldba/postgres-mcp
query
@Maxim2324/mcp-server-test
query
@antonorlov/mcp-postgres-server
execute
@enemyrr/mcp-mysql-server

ID: 14ye5puu55

execute

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MCP PostgreSQL Server

Related Tools