MCP PostgreSQL Server

MIT License

932

Overview InspectNew Schema Related Servers Reviews Score

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
execute
@antonorlov/mcp-postgres-server
execute
@Maxim2324/mcp-server-test
execute_postgresql
@alexander-zuev/supabase-mcp-server
run_read_query
@madhukarkumar/singlestore-mcp-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