postgres-activity-mcp
JSON →Version 0.1.0. An MCP (Model Context Protocol) server that automatically logs all INSERT, UPDATE, and DELETE operations in a PostgreSQL database and exposes the log to AI coding agents via MCP tools. Unlike manual database introspection, it sets up audit triggers on all tracked tables once, then lets agents query recent row changes without writing SQL. Currently requires Node >=20 and Postgres >=13. Ships four tools: setup_activity_logging, refresh_activity_triggers, get_recent_db_changes, and summarize_recent_db_changes. Not yet stable; API and trigger behavior may change between minor versions.
Resources
packagepostgres-activity-mcp ↗
API endpoints
full doc /v1/registry/postgres-activity-mcp