← PostgreSQL MCP Server

PostgreSQL MCP Server 1.0.2

npm · postgres-connector · current release

3
Tools
0
Resources
0
Templates
0
Prompts

Observation

Observed 2026-08-17T22:27:13.084Z using mcpSecurity-inventory. Status: succeeded. Negotiated protocol: 2025-06-18.

Server capabilities
{
  "tools": {
    "listChanged": true
  }
}

Tools 3

ToolCategoryAnnotationsRisk
execute-sql-queryExecute a SQL query on the database. Only SELECT statements are allowed for security.
Input schema
{
  "type": "object",
  "properties": {
    "sql": {
      "type": "string",
      "description": "The SQL query to execute"
    }
  },
  "required": [
    "sql"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
— · —
get-all-tablesExecute SQL queries to get all tables in the database
Input schema
{
  "type": "object",
  "properties": {}
}
— · —
test-postgres-connectionTest the Postgres connection and return connection status
Input schema
{
  "type": "object",
  "properties": {}
}
— · —

Resources 0

Resource templates 0

Prompts 0

Let’s talk about MCP security.

Share your details and our security team will contact you.