en es ja ko zh

MCP PostgreSQL Server

by Maxim2324

Verified

Databases

JavaScript

MIT License

1,519

Reddit Discord

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

execute

Run INSERT, UPDATE, or DELETE queries on PostgreSQL databases using SQL syntax. Supports query parameters for dynamic data manipulation within the MCP PostgreSQL Server environment.

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
@antonorlov/mcp-postgres-server
execute_sql
@crystaldba/postgres-mcp
query
@Maxim2324/mcp-server-test
query
@antonorlov/mcp-postgres-server
insert_data
@michael7736/mysql-mcp-server

ID: vaztx3bu73

execute

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MCP PostgreSQL Server

Related Tools