# postgres-temporal-mcp

> postgres-temporal-mcp — martinko-na-postgres-temporal-mcp. Use this tool when you need to manage and interact with temporal data in PostgreSQL, solving problems such as auditing, versioning, and data recovery. It provides a Model Context Protocol (MCP) server to view table history, restore previous versions, and manage temporal data. Ideal for use cases requiring data version control and historical data analysis, with inputs including PostgreSQL temporal tables and outputs including restored data versions.

Canonical page: https://skillsregistry.net/skills/martinko-na-postgres-temporal-mcp  
JSON: https://api.skillsregistry.net/v1/skills/martinko-na-postgres-temporal-mcp

## Description

MCP Server for PostgreSQL Temporal Tables Extension  This server provides tools to interact with PostgreSQL temporal_tables extension, allowing users to view table history, restore previous versions, and manage temporal data through the Model Context Protocol.

## Trust

- **Trust score (0–1):** 1.00
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** container
- **Runtime environment:** vm
- **License:** Apache-2.0
- **Updated:** 2026-09-28

## Source

- **Source listing:** [GitHub](https://github.com/martinko-na/postgres-temporal-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": "martinko-na-postgres-temporal-mcp"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/martinko-na-postgres-temporal-mcp` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/martinko-na-postgres-temporal-mcp/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
