PGAutoPilot is a production-ready PostgreSQL MCP server that lets any AI assistant safely interact with PostgreSQL using natural language. It combines schema-aware query generation, enterprise safety controls, and a minimal-configuration setup into a single executable.
Skill Claude CodeCodex
Use this skill when creating, managing, or restoring PostgreSQL backups through PGAutoPilot. Trigger when user asks to: - "Back up the database" - "How do I restore from a backup?" - "Create a backup before I make changes" - "Export the database" - "I need to restore my data" - Backup, restore, dump, export, import…
Skill Claude CodeCodex
Use this skill when diagnosing PostgreSQL connection issues through PGAutoPilot. Trigger when user asks to: - "I can't connect to the database" - "Connection refused" - "Connection timed out" - "Database is not reachable" - "How do I fix my database URL?" - "The database won't start" - Connection errors…
Skill Claude CodeCodex
Use this skill when checking PostgreSQL database health, monitoring, or diagnosing production issues. Trigger when user asks to: - "Check database health" - "Is the database healthy?" - "Check vacuum status" - "Check replication lag" - "Are there unused indexes?" - "Check connection pool" - "Database monitoring" …
Skill Claude CodeCodex
Use this skill when working with multiple PostgreSQL databases through PGAutoPilot. Trigger when user asks to: - "Switch to the analytics database" - "List all databases" - "Query the staging database" - "What databases are connected?" - "Compare data between production and staging" - "Health check all databases" …
Skill Claude CodeCodex
Use this skill for ANY PostgreSQL database work through the PGAutoPilot MCP server. Trigger when user asks to: - Explore, query, or manage a PostgreSQL database - Design schemas, tables, or data models for Postgres - Write, optimize, or debug SQL queries - Check database health, performance, or connectivity - Insert…
Skill Claude CodeCodex
Use this skill when analyzing, optimizing, or debugging PostgreSQL query performance. Trigger when user asks to: - "Why is this query slow?" - "Help me optimize this query" - "What indexes would improve performance?" - "Analyze the execution plan" - "Find slow queries" - "Tune database performance" - "My app is slow"…
Skill Claude CodeCodex
Use this skill when writing, inserting, updating, or deleting data in PostgreSQL through PGAutoPilot. Trigger when user asks to: - "Add a new user/record/row" - "Update orders status" - "Delete old logs" - "Create or update this product" - "Bulk update/delete" - Insert, update, upsert, delete, write operations…
At most 3 mods per repository are shown here, and a mod shipped inside a plugin is left to that plugin's page — the rest are on their repository pages: