Skip to main content
Glama

PostgreSQL MCP Server

AGPL 3.0
498
94
  • Linux
  • Apple

pg_export_table_data

Export PostgreSQL table data to JSON or CSV format by specifying table name, output path, and optional filters. Use with PostgreSQL MCP Server for streamlined database management.

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