PostgreSQL skills and MCP plugin for Azure Database for PostgreSQL

The PostgreSQL skills and MCP plugin turns supported AI coding assistants into context-aware PostgreSQL experts that can both provide guidance and act on a connected database. The bundled plugin combines expert-curated skills for PostgreSQL and Azure Database for PostgreSQL with an MCP server that can inspect your live database context, run queries, apply changes, and support database operations. The plugin uses your schema, PostgreSQL version, extensions, and Azure environment to deliver relevant guidance instead of generic recommendations. It covers scenarios such as query and index tuning, vector search and retrieval-augmented generation (RAG), JSONB, partitioning, security, Azure provisioning and scaling, high availability and failover, point-in-time restore, AI functions, and knowledge graphs with Apache AGE. It automatically routes between generic PostgreSQL and Azure-specific guidance based on your question and connection context. The plugin is available through supported AI coding assistants, including GitHub Copilot CLI, Claude Code, and Codex CLI.[Learn more.](https://techcommunity.microsoft.com/blog/adforpostgresql/postgres-skills-give-your-ai-agent-postgresql-expertise/4556705)