MCPg: MCP server, setup and security

What MCPg does

According to its repository: “PostgreSQL catalog introspection, AST-validated query execution, index tuning, natural-language SQL, and pgvector, TimescaleDB and AGE integrations.”

The Model Context Protocol (MCP) is a standard plug between an AI agent and an outside service: once the server is connected, its tools show up in the agent, which decides when to call them. MCPg is listed under Databases, a category of 138 servers in the directory, where it ranks #114 by stars.

Topics declared by the repository: anthropic, claude, claude-code, database, database-tools, pgvector.

Installing and connecting MCPg

Distribution modes declared in the official MCP registry:

• PyPI package (Python, started with uvx or pip)

It works with any MCP-compatible client (Claude Desktop, Claude Code, Cursor, VS Code, Codex and most recent agents). You add one entry to the client's MCP configuration: server name, start command or URL, environment variables. Project language: Python. Listed systems: macOS, Windows, Linux.

Security: what to check

Connecting an MCP server means installing software that talks straight to your agent: it runs with your rights and the model trusts its tool descriptions. The risk therefore depends on what it can touch and how far its code can be trusted.

None of the risk signals we track (system access, secrets, missing licence, abandonment) applies to MCPg. That does not replace reading the code.

Good practice: grant only the rights needed (least privilege), require human approval for irreversible actions, and run the AI agent security check.

Project activity and maintenance

Created on May 20, 2026, the devopam/MCPg repository has 14 stars and 1 forks, with 1 open issues. It has more stars than 32% of the servers in the directory. It received changes this month. Version published in the registry: 0.8.3 (October 14, 2026).

Stars measure attention, not quality: a recent, heavily promoted project can collect them fast, while a useful but niche server will have few.