MCP PostgreSQL Server

MIT License

1,012

Overview InspectNew Schema Related Servers Reviews Score

execute

Run INSERT, UPDATE, or DELETE queries on PostgreSQL databases using SQL syntax. Supports query parameters for dynamic data manipulation within the MCP PostgreSQL Server environment.

Instructions

Execute an INSERT, UPDATE, or DELETE query

Input Schema

Name	Required	Description	Default
`params`	No	Query parameters (optional)
`sql`	Yes	SQL 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"
}

You must be authenticated.

Related Tools

execute
@antonorlov/mcp-postgres-server
execute_sql
@crystaldba/postgres-mcp
query
@Maxim2324/mcp-server-test
query
@antonorlov/mcp-postgres-server
insert_data
@michael7736/mysql-mcp-server
execute
@enemyrr/mcp-mysql-server

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/Maxim2324/mcp-server-test'

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