Skip to main content
Glama

PostgreSQL MCP Server

AGPL 3.0
498
94
  • Linux
  • Apple

pg_copy_between_databases

Transfer data between PostgreSQL databases by specifying source and target connections, table name, and optional filters or truncation settings.

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