MCP server intelligence profile

PostgreSQL MCP Server

A TypeScript-based Model Context Protocol server that enables AI assistants to perform secure database operations on PostgreSQL databases through structured tool interfaces

Local Onlycesarvarela
Awaiting current scanNpm · 1.0.1

The selected current version does not yet have completed public verification. Unknown does not mean clean or vulnerable.

1Distribution channel
8Independently observed tools
0Linked remote endpoints
AvailableVersion intelligence

Detailed security scan evidence is not public for this MCP yet. Public identity, registry metadata, and independently observed protocol inventory remain available.

Install and connect

Installation and connection instructions are shown only when supported by retained package, repository, or endpoint evidence.

Install @cesarvarela/postgres-mcp from npm

Version 1.0.1 declares 1 executable entrypoint.

npm install --save-exact @cesarvarela/postgres-mcp@1.0.1
npx -y -p @cesarvarela/postgres-mcp@1.0.1 @cesarvarela/postgres-mcp
MCP client configuration example
{
  "mcpServers": {
    "@cesarvarela/postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "-p",
        "@cesarvarela/postgres-mcp@1.0.1",
        "@cesarvarela/postgres-mcp"
      ]
    }
  }
}

Identity

Canonical slugpostgresql-mcp-server-c03e309cDeploymentLocal Only
Canonical packagenpm:@cesarvarela/postgres-mcpRepositorycesarvarela/postgres-mcp
First published—Latest release—
Last security verification—Classification confidence90%
PublicationDraftOfficial distributionNot verified

Distributions

ChannelIdentifierCurrent versionVersionsSource
npm@cesarvarela/postgres-mcp1.0.11Repository

Current release

PackageVersionPublished / observedInventorySecurity scan
npm@cesarvarela/postgres-mcp1.0.1CurrentSep 5, 20268 toolsSucceeded · 0 resources · 0 promptsEvidence restricted
Enterprise protection

Continuously monitor this MCP for security risk

Independently scan the exact version your agents use, receive alerts when its risk changes, and investigate every finding with retained version evidence.

  • Independent exact-version security scans
  • Continuous release and vulnerability monitoring
  • Risk-change alerts with capability context
  • Historical evidence and API exports
Custom pricingContact salesTailored to your organization, integrations, data needs, and support requirements.

Current version evidence

No public current-version evidence is available yet.

Current protocol inventory

2025-06-18Negotiated protocol
postgres-mcpServer-reported name
1Capability groups
Aug 22, 2026Observed

Tools 8

ToolCategoryAnnotationsRisk
connection-statusCheck database connection status, view error details, and retry connection. Use retry: true to attempt reconnection when database is unavailable.
Input schema
{
  "type": "object",
  "properties": {
    "retry": {
      "type": "boolean",
      "default": false
    }
  },
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
——
delete-dataDelete records from a table. Requires WHERE conditions for safety. Includes confirmation prompt for large deletions.
Input schema
{
  "type": "object",
  "properties": {
    "table": {
      "type": "string",
      "minLength": 1
    },
    "where": {
      "type": "object",
      "additionalProperties": {}
    },
    "confirm_delete": {
      "type": "boolean",
      "default": false
    },
    "returning": {
      "type": "array",
      "items": {
        "type": "string"
      }
    }
  },
  "required": [
    "table",
    "where"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
——
execute-queryExecute a parameterized SQL query with safety checks. Supports SELECT, INSERT, UPDATE, DELETE operations with parameter binding to prevent SQL injection.
Input schema
{
  "type": "object",
  "properties": {
    "query": {
      "type": "string",
      "minLength": 1
    },
    "params": {
      "type": "array",
      "default": []
    },
    "explain": {
      "type": "boolean",
      "default": false
    }
  },
  "required": [
    "query"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
——
get-schemaGet database schema information including tables, columns, data types, and optionally constraints. Useful for understanding database structure.
Input schema
{
  "type": "object",
  "properties": {
    "schema_name": {
      "type": "string",
      "default": "public"
    },
    "table_pattern": {
      "type": "string"
    },
    "include_columns": {
      "type": "boolean",
      "default": true
    },
    "include_constraints": {
      "type": "boolean",
      "default": false
    }
  },
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
——
get-table-infoGet detailed information about a specific table including columns, constraints, indexes, and optionally statistics like row count and size.
Input schema
{
  "type": "object",
  "properties": {
    "table": {
      "type": "string",
      "minLength": 1
    },
    "schema_name": {
      "type": "string",
      "default": "public"
    },
    "include_statistics": {
      "type": "boolean",
      "default": true
    }
  },
  "required": [
    "table"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
——
insert-dataInsert new records into a table. Supports single or multiple records, conflict resolution (ignore/update), and returning inserted data.
Input schema
{
  "type": "object",
  "properties": {
    "table": {
      "type": "string",
      "minLength": 1
    },
    "data": {
      "anyOf": [
        {
          "type": "object",
          "additionalProperties": {}
        },
        {
          "type": "array",
          "items": {
            "type": "object",
            "additionalProperties": {}
          }
        }
      ]
    },
    "on_conflict": {
      "type": "string",
      "enum": [
        "error",
        "ignore",
        "update"
      ],
      "default": "error"
    },
    "conflict_columns": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "returning": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "default": [
        "*"
      ]
    }
  },
  "required": [
    "table",
    "data"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
——
query-tableQuery data from a specific table with filtering, pagination, and sorting. Supports WHERE conditions with exact matches, arrays (IN), and LIKE patterns.
Input schema
{
  "type": "object",
  "properties": {
    "table": {
      "type": "string",
      "minLength": 1
    },
    "columns": {
      "type": "array",
      "items": {
        "type": "string",
        "minLength": 1
      }
    },
    "where": {
      "type": "object",
      "additionalProperties": {}
    },
    "pagination": {
      "type": "object",
      "properties": {
        "limit": {
          "type": "integer",
          "minimum": 1,
          "maximum": 1000,
          "default": 50
        },
        "offset": {
          "type": "integer",
          "minimum": 0,
          "default": 0
        }
      },
      "additionalProperties": false
    },
    "sort": {
      "type": "object",
      "properties": {
        "column": {
          "type": "string",
          "minLength": 1
        },
        "direction": {
          "type": "string",
          "enum": [
            "ASC",
            "DESC"
          ],
          "default": "ASC"
        }
      },
      "required": [
        "column"
      ],
      "additionalProperties": false
    }
  },
  "required": [
    "table"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
——
update-dataUpdate existing records in a table. Requires WHERE conditions for safety. Supports complex WHERE clauses and returns updated records.
Input schema
{
  "type": "object",
  "properties": {
    "table": {
      "type": "string",
      "minLength": 1
    },
    "data": {
      "type": "object",
      "additionalProperties": {}
    },
    "where": {
      "type": "object",
      "additionalProperties": {}
    },
    "returning": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "default": [
        "*"
      ]
    }
  },
  "required": [
    "table",
    "data",
    "where"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
——

Resources 0

  • None observed.

Resource templates 0

  • None observed.

Prompts 0

  • None observed.

Remote endpoints

EndpointTransportAuthenticationHealthObserved
No verified remote endpoint is linked.

PostgreSQL MCP Server questions

How do I install PostgreSQL MCP Server?

Install the selected package version with: npm install --save-exact @cesarvarela/postgres-mcp@1.0.1

What tools does PostgreSQL MCP Server provide?

PostgreSQL MCP Server exposed 8 tools during independent protocol observation, including connection-status, delete-data, execute-query, get-schema, get-table-info, insert-data, query-table, update-data.

Is PostgreSQL MCP Server secure?

The selected current version does not yet have completed public verification. Unknown does not mean clean or vulnerable.

Explore related MCP server guides

Curated product and capability guides containing this catalog record.

PostgreSQL MCP ServersDatabase MCP ServersOfficial vs Community MCP Servers

Let’s talk about MCP security.

Share your details and our security team will contact you.