PostgreSQL MCP servers and skills

supabase official supabase skill Guides the agent through database configuration and strict RLS policies in Supabase. CX Codex GP ChatGPT 8installs cloud-sql-basics official google skill This skill helps create and explain Cloud SQL resources for MySQL, PostgreSQL, and SQL Server. Use it when setting up a database in Google Cloud. Claude Code Gemini CLI CX Codex 14,679installs postgres-patterns affaan-m skill PostgreSQL best practice reference based on Supabase guidelines. Covers indexing patterns, data type choices, RLS policies, and slow query diagnosis. Claude Code CX Codex Cursor +1 5,200installs django-patterns affaan-m skill Guides agents on Django and DRF architecture: modular settings, custom user models, and optimized QuerySets without N+1 queries. Claude Code CX Codex Cursor +1 5,100installs database-migrations affaan-m skill A skill that spells out safe, reversible schema changes: expand-contract renames, concurrent indexes, batched backfills, plus workflows for PostgreSQL, Prisma, Drizzle, Kysely, Django and golang-migrate. Claude Code CX Codex Cursor +1 5,100installs postgresql-optimization official github skill Helps developers use PostgreSQL features such as JSONB, arrays, indexes, full-text search, window functions, and extensions. GitHub Copilot 16,436installs sql-optimization official github skill Reviews SQL performance issues, index choices, and slow-query patterns. Use it when tuning queries for MySQL, PostgreSQL, SQL Server, or Oracle. GitHub Copilot 15,701installs alloydb-basics official google skill Use this skill to create and configure AlloyDB for PostgreSQL clusters and instances, manage backups, and work with AlloyDB MCP tools. It is for AlloyDB administration. Claude Code Gemini CLI CX Codex 12,991installs healthcare-phi-compliance affaan-m skill PHI and PII security patterns for healthcare systems under HIPAA, GDPR, and DISHA. Helps configure RLS, audit logging, and stop data leaks in URLs or logs. Claude Code CX Codex Cursor +1 4,500installs prisma-patterns affaan-m skill Production patterns and schema guidelines for Prisma ORM in TypeScript. Helps write safe queries, transactions, and pagination while avoiding connection pool exhaustion. Claude Code CX Codex Cursor +1 4,500installs sql-code-review official github skill Reviews SQL for security and performance issues, as well as maintainability. Use it when checking queries or a database schema. GitHub Copilot 14,060installs postgresql-code-review official github skill Reviews SQL and database schemas for PostgreSQL-specific issues. Use it before reviewing migrations, JSONB queries, functions, or access rules. GitHub Copilot 12,608installs postgresql-table-design Seth Hobson skill Helps design and review PostgreSQL schemas with guidance on data types, keys, constraints, indexes, and table partitioning. Claude Code CX Codex Cursor 27,780installs fastapi-templates Seth Hobson skill This skill lays out FastAPI projects with async code and dependency injection. Use it when starting a Python API or backend service. Claude Code CX Codex Cursor 25,840installs create-spring-boot-java-project official github skill Creates a Spring Boot Java skeleton with Maven, database settings and Docker Compose. Use it when a new API needs PostgreSQL, Redis and MongoDB locally. GitHub Copilot 9,516installs create-spring-boot-kotlin-project official github skill This skill scaffolds a Spring Boot project in Kotlin, then configures PostgreSQL, Redis and MongoDB. Use it when you want a reactive starter with Gradle tests. GitHub Copilot 8,700installs sql-queries official anthropics skill Writes and optimizes SQL across PostgreSQL, Snowflake, BigQuery, Redshift, and Databricks. Useful when tuning queries or migrating analytics across warehouses. Claude Code CX Codex Cursor +1 4,500installs firebase-data-connect Google LLC skill Builds and configures Firebase SQL Connect backends on PostgreSQL with GraphQL schemas and generated SDKs. Useful when adding relational data to Firebase projects. Claude Code CX Codex Cursor +1 168,300installs sql-optimization-patterns Seth Hobson skill This skill helps inspect slow SQL, EXPLAIN plans, and index choices. Use it when a query scans too much data, JOINs poorly, or causes N+1 calls. Claude Code CX Codex Cursor 19,717installs golang-database samber skill Go database guidelines for database/sql, sqlx, and pgx. Enforces parameterized queries, context passing, and explicit connection pool handling without ORMs. Claude Code CX Codex Cursor +1 40,700installs write-query official anthropics skill Writes SQL for a chosen dialect, handles joins and aggregations, and considers partitioning. Use it for analytical queries or performance-sensitive work. Claude Code CX Codex Cursor +1 3,000installs incident-runbook-templates Seth Hobson skill This skill builds step-by-step incident runbooks for detection, triage, mitigation, recovery, escalation, and status updates. Claude Code CX Codex Cursor 10,900installs prisma-postgres prisma skill A deprecated compatibility name for prisma-postgres-setup. Use it only when explicitly invoked; new projects should select prisma-postgres-setup instead. Claude Code CX Codex Cursor +1 380,400installs prisma-postgres-setup prisma skill Provisions or connects a Prisma Postgres database and links it to your app. Useful for spinning up dev databases quickly or wiring connections in Vercel and v0. Claude Code CX Codex Cursor +1 374,900installs reviewing-oracle-to-postgres-migration official github skill Reviews Oracle-to-PostgreSQL migration risks and checks whether migration artifacts and integration tests cover the relevant behavior changes. GitHub Copilot 1,800installs planning-oracle-to-postgres-migration-integration-testing official github skill This skill inspects a single .NET project and writes an integration test plan for an Oracle-to-PostgreSQL migration. Use it to map database touchpoints to tests. GitHub Copilot 1,800installs migrating-oracle-to-postgres-stored-procedures official github skill Moves Oracle PL/SQL procedures and functions to PostgreSQL PL/pgSQL. Use it during a database migration when signatures and control flow must stay intact. GitHub Copilot 1,800installs creating-oracle-to-postgres-migration-integration-tests official github skill Creates Oracle integration tests for .NET data access artifacts before a PostgreSQL migration, preserving expected database behavior as the test baseline. GitHub Copilot 1,800installs creating-oracle-to-postgres-migration-bug-report official github skill This skill turns Oracle-to-PostgreSQL migration defects into structured bug reports. Use it when a behavior gap needs a clear cause, reproduction path, and remediation. GitHub Copilot 1,800installs creating-oracle-to-postgres-master-migration-plan official github skill This skill scans a .NET solution, finds Oracle dependencies, and builds a PostgreSQL migration plan. Use it before coordinating a migration across several projects. GitHub Copilot 1,800installs scaffolding-oracle-to-postgres-migration-test-project official github skill Creates an empty xUnit integration test project for Oracle in a .NET solution. Use it in Phase 3 before writing Oracle baseline integration tests. GitHub Copilot 1,700installs sql-pro VoltAgent Community subagent Subagent for optimizing complex SQL queries, designing database schemas, and fixing performance bottlenecks across PostgreSQL, MySQL, SQL Server, and Oracle. Claude Code 3,602installs sql-pro Seth Hobson subagent Helps design database schemas, inspect query plans, and tune SQL for OLTP and OLAP systems. Use it for database optimization or complex analysis. Claude Code CX Codex Cursor 3,602installs database-optimizer VoltAgent Community subagent This subagent reviews slow queries, execution plans, and indexes. Use it when a database needs query, schema, or configuration tuning. Claude Code 3,320installs database-admin Seth Hobson subagent This subagent helps plan, migrate, monitor, and operate cloud databases. Use it for architecture work, reliability tasks, and database operations. Claude Code CX Codex Cursor 2,185installs senior-backend Alireza Rezvani skill Scaffolds backend APIs, detects database bottlenecks, and runs load tests. Useful when designing Express routes, optimizing PostgreSQL, or preparing for production. Claude Code 1,674installs postgres-pro VoltAgent Community subagent A subagent for PostgreSQL query tuning, replication, backups, and database troubleshooting. Use it when database performance or availability needs a structured review. Claude Code 897installs sql-database-assistant Alireza Rezvani skill Write SQL, inspect database schemas, review query performance, and prepare migrations. Useful for everyday database work and ORM-backed projects. Claude Code 727installs database-administrator VoltAgent Community subagent A subagent for database performance work, replication, backups, recovery, and production infrastructure. Use it when database reliability needs a structured review. Claude Code 452installs efcore-d2-db-diagram official github skill Generates D2 ER diagrams from Entity Framework Core models. Use it when a database schema must reflect DbContext mappings and migrations. GitHub Copilot 58installs