en es ja ko zh

MCP PostgreSQL Server

by Maxim2324

Verified

Databases

JavaScript

MIT License

1,519

Reddit Discord

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

query

Run read-only SELECT queries on PostgreSQL databases. Use parameterized SQL to safely retrieve and analyze data through 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

execute_sql
@crystaldba/postgres-mcp
query
@modelcontextprotocol/postgresql
execute
@antonorlov/mcp-postgres-server
execute
@Maxim2324/mcp-server-test
execute_postgresql
@alexander-zuev/supabase-mcp-server

ID: vaztx3bu73

query

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MCP PostgreSQL Server

Related Tools