# Postgres Connector

> Use this tool when you need to securely query and manage PostgreSQL databases, solving problems such as retrieving table listings and executing SELECT queries with security restrictions. It provides a direct database querying interface that accepts environment configurations and SQL queries as inputs, and outputs query results and table listings. Ideal for data analysts, developers, and teams requiring secure PostgreSQL integration in their AI workflows.

Canonical page: https://skillsregistry.net/skills/martymarkenson-postgres-connector  
JSON: https://api.skillsregistry.net/v1/skills/martymarkenson-postgres-connector

## Description

This PostgreSQL connector MCP server by Marty Markenson provides direct database querying capabilities for PostgreSQL databases through secure SQL execution and schema inspection tools. Built with TypeScript using the MCP SDK and postgres library, it offers tools for retrieving table listings, executing SELECT queries with security restrictions, and setting up database connections through environment configuration. The implementation includes comprehensive connection management with dotenv support, Zod validation for type safety, and a manifest-based configuration system that allows users to specify database credentials through user config parameters, making it valuable for data analysts querying company databases, developers building database-driven AI applications, and teams needing secure PostgreSQL integration in their AI workflows.

## Trust

- **Trust score (0–1):** 0.64
- **Verification tier:** scanned
- **Last scanned:** 2026-09-02

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-02

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/martymarkenson-postgres-connector)
- **Repository:** <https://github.com/martymarkenson/postgres-connector-mcp>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "martymarkenson-postgres-connector"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/martymarkenson-postgres-connector` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/martymarkenson-postgres-connector/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt