PostgreSQL MCP Server:

The SelfHost PostgreSQL MCP server is an AI-powered toolkit with 76 tools that lets you manage your entire database infrastructure from Claude, Cursor, or VS Code using natural language. It covers provisioning, backups, monitoring, alerts, networking, PG configuration, and team management - no other PostgreSQL MCP server offers this scope.

SelfHost provides 76 MCP tools for PostgreSQL across 8 modules: Instances (14 tools), Backups (10), Alerts (13), Networking (8), PG Config (3), Teams (11), and additional monitoring and scaling tools. Free tier includes 11 read-only tools, Starter includes 38, and Pro/Enterprise includes all 76. See tier details.

The SelfHost PostgreSQL MCP server works with Claude (Desktop and Code), Cursor, Windsurf, VS Code, and any MCP-compatible client. Install with npx @selfhost.dev/mcp-server, authenticate via browser, and all 76 tools become available in your AI editor immediately.

Yes - you can manage PostgreSQL from Claude using SelfHost's MCP server. Ask Claude to create databases, run backups, configure alerts, tune PostgreSQL settings, check metrics, and manage team access - all in plain English. Claude executes these through the MCP protocol with full confirmation on destructive operations.

Most PostgreSQL MCP servers (Anthropic's reference server, pgEdge, Crystal DBA) focus on queries and schema access - typically 5-15 tools. SelfHost provides 76 tools covering full infrastructure lifecycle: provisioning, backups, PITR, monitoring, alerts, networking, configuration, and team management. See full comparisons.

Yes - the MCP server runs locally on your machine and communicates with the SelfHost API to manage infrastructure. It never connects to your databases directly. Destructive operations (delete, stop, reboot) require explicit confirmation. Credentials are stored locally with chmod 600 owner-only permissions.

Run npx @selfhost.dev/mcp-server to install. Add it to your MCP config file, then run the server - it opens your browser for authentication. Once signed in, all 76 tools register automatically. The entire setup takes under 2 minutes. Available on npm at @selfhost.dev/mcp-server.

SelfHost's 10 backup MCP tools let you create on-demand snapshots, set up automated DLM backup policies with custom retention, configure S3 backup targets, and perform point-in-time restores - all via natural language. Ask your AI: "Set up daily backups with 7-day retention" and it handles the rest.

SelfHost's alert module includes 13 PostgreSQL AI tools for monitoring CPU, memory, disk usage, replication lag, cache hit ratio, and custom PostgreSQL metrics. Set up multi-channel notifications via email, Slack, or webhooks - all through natural language commands in Claude, Cursor, or VS Code.

The MCP server is included on all SelfHost plans at no extra cost. Free tier includes 11 read-only tools for viewing instances, metrics, and status. Starter ($19/mo) unlocks 38 tools including backups and alerts. Pro ($79/mo) and Enterprise ($249/mo) include all 76 tools with full read-write access. See pricing.

Yes - all 76 MCP tools work with both Managed and BYOC deployments. On BYOC, the MCP server manages databases running in your own AWS account through the SelfHost API. This means you get AI native database management while maintaining full infrastructure ownership. BYOC is available on Pro ($79/mo).

The SelfHost PostgreSQL MCP server includes 8 modules: Instances (14 tools - create, scale, fork, delete), Backups (10 - snapshots, DLM, PITR), Alerts (13 - metrics, thresholds, notifications), Networking (8 - VPC, subnets, security groups), PG Config (3 - parameter tuning), Teams (11 - orgs, roles, audit logs), plus monitoring and scaling tools.