MCP PostgreSQL Server

MIT License

580

Overview InspectNew Endpoints Schema Related Servers Reviews Score

query

Run SELECT queries on PostgreSQL databases securely using SQL commands and parameters. Explore schemas, analyze data, and retrieve results efficiently with this MCP tool.

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"
}

This server cannot be installed

Related Tools

query
@antonorlov/mcp-postgres-server
execute_sql
@crystaldba/postgres-mcp
execute_custom_query
@1Levick3/postgresql-mcp-server
pg_execute_query
@HenkDz/postgresql-mcp-server
query
@enemyrr/mcp-mysql-server
query
@yaoxiaolinglong/mcp-mongodb-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