Skip to main content
Glama

PostgreSQL MCP Server

AGPL 3.0
808
116
  • Linux
  • Apple

pg_import_table_data

Transfer data from JSON or CSV files into a PostgreSQL table. Specify the table name, file path, and optional truncation, format, or delimiter settings for precise integration.

Instructions

Import data from JSON or CSV file into a table

Input Schema

NameRequiredDescriptionDefault
connectionStringNo
delimiterNo
formatNojson
inputPathYesabsolute path to the file to import
tableNameYes
truncateFirstNo

Input Schema (JSON Schema)

{ "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "properties": { "connectionString": { "type": "string" }, "delimiter": { "type": "string" }, "format": { "default": "json", "enum": [ "json", "csv" ], "type": "string" }, "inputPath": { "description": "absolute path to the file to import", "type": "string" }, "tableName": { "type": "string" }, "truncateFirst": { "default": false, "type": "boolean" } }, "required": [ "tableName", "inputPath" ], "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