PostgreSQL MCP Server

insert-data

Insert single or multiple records into a PostgreSQL table. Supports conflict resolution (ignore/update) and returns inserted data for efficient database management.

Instructions

Insert new records into a table. Supports single or multiple records, conflict resolution (ignore/update), and returning inserted data.

Input Schema

Name	Required	Default
`conflict_columns`	No
`data`	Yes
`on_conflict`	No	error
`returning`	No
`table`	Yes

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "conflict_columns": {
      "items": {
        "type": "string"
      },
      "type": "array"
    },
    "data": {
      "anyOf": [
        {
          "additionalProperties": {},
          "type": "object"
        },
        {
          "items": {
            "additionalProperties": {},
            "type": "object"
          },
          "type": "array"
        }
      ]
    },
    "on_conflict": {
      "default": "error",
      "enum": [
        "error",
        "ignore",
        "update"
      ],
      "type": "string"
    },
    "returning": {
      "default": [
        "*"
      ],
      "items": {
        "type": "string"
      },
      "type": "array"
    },
    "table": {
      "minLength": 1,
      "type": "string"
    }
  },
  "required": [
    "table",
    "data"
  ],
  "type": "object"
}

Install Server

HTTP connection URL

Related Tools

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/cesarvarela/postgres-mcp'

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