en es ja ko zh

MCP PostgreSQL Server

by antonorlov

Verified

Databases

JavaScript

MIT License

127

Reddit Discord

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

query

Run SQL SELECT queries on PostgreSQL databases with parameterized inputs to retrieve specific data, enabling efficient database interactions for AI models via the MCP PostgreSQL Server.

Instructions

Execute a SELECT query

Input Schema

Name	Required	Description	Default
`params`	No	Query parameters (optional)
`sql`	Yes	SQL SELECT query (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 SELECT query (use $1, $2, etc. for parameters)",
      "type": "string"
    }
  },
  "required": [
    "sql"
  ],
  "type": "object"
}

You must be authenticated.

Related Tools

connect_db
@antonorlov/mcp-postgres-server
query
@enemyrr/mcp-mysql-server
query
@sussa3007/mysql-mcp
execute
@Maxim2324/mcp-server-test
execute
@antonorlov/mcp-postgres-server

ID: 14ye5puu55

query

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MCP PostgreSQL Server

Related Tools