Skip to main content
Glama

MCP PostgreSQL Server

execute

Run INSERT, UPDATE, or DELETE queries on a PostgreSQL database using parameterized SQL statements to modify data securely and efficiently.

Instructions

Execute an INSERT, UPDATE, or DELETE query

Input Schema

NameRequiredDescriptionDefault
paramsNoQuery parameters (optional)
sqlYesSQL query (INSERT, UPDATE, DELETE) (use $1, $2, etc. for parameters)

Input Schema (JSON Schema)

{ "properties": { "params": { "description": "Query parameters (optional)", "items": { "type": [ "string", "number", "boolean", "null" ] }, "type": "array" }, "sql": { "description": "SQL query (INSERT, UPDATE, DELETE) (use $1, $2, etc. for parameters)", "type": "string" } }, "required": [ "sql" ], "type": "object" }

Other Tools from MCP PostgreSQL Server

Related Tools

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/antonorlov/mcp-postgres-server'

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