Skip to main content
Glama

PostgreSQL MCP Server

AGPL 3.0
808
116
  • Linux
  • Apple

pg_export_table_data

Export PostgreSQL table data to JSON or CSV for analysis or migration. Specify table name, output path, and optional filters like 'where' clause or row limit to customize data extraction.

Instructions

Export table data to JSON or CSV format

Input Schema

NameRequiredDescriptionDefault
connectionStringNo
formatNojson
limitNo
outputPathYesabsolute path to save the exported data
tableNameYes
whereNo

Input Schema (JSON Schema)

{ "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "properties": { "connectionString": { "type": "string" }, "format": { "default": "json", "enum": [ "json", "csv" ], "type": "string" }, "limit": { "exclusiveMinimum": 0, "type": "integer" }, "outputPath": { "description": "absolute path to save the exported data", "type": "string" }, "tableName": { "type": "string" }, "where": { "type": "string" } }, "required": [ "tableName", "outputPath" ], "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