Skip to main content
Glama

PostgreSQL MCP Server

AGPL 3.0
808
116
  • Linux
  • Apple

pg_copy_between_databases

Transfer data between PostgreSQL databases by specifying source and target connection strings and table name. Optionally truncate target table or filter data using a WHERE clause.

Instructions

Copy data between two databases

Input Schema

NameRequiredDescriptionDefault
sourceConnectionStringYes
tableNameYes
targetConnectionStringYes
truncateTargetNo
whereNo

Input Schema (JSON Schema)

{ "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "properties": { "sourceConnectionString": { "type": "string" }, "tableName": { "type": "string" }, "targetConnectionString": { "type": "string" }, "truncateTarget": { "default": false, "type": "boolean" }, "where": { "type": "string" } }, "required": [ "sourceConnectionString", "targetConnectionString", "tableName" ], "type": "object" }

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/HenkDz/postgresql-mcp-server'

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