PostgreSQL Pro
Skill ActiveUse when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
To act as a senior PostgreSQL expert, guiding users through complex database administration tasks and performance tuning.
Features
- EXPLAIN ANALYZE query optimization
- Index design and verification
- Replication setup (streaming, logical)
- VACUUM, ANALYZE, and autovacuum tuning
- JSONB operations and indexing
- PostgreSQL extension usage (PostGIS, pgvector)
- Performance monitoring with pg_stat views
Use Cases
- Analyzing and fixing slow-running SQL queries
- Implementing efficient indexing strategies
- Setting up and monitoring database replication
- Tuning database performance parameters
- Leveraging advanced JSONB capabilities
Non-Goals
- Replacing the database administrator directly
- Automating all database changes without user intervention
- Providing generic SQL commands unrelated to PostgreSQL optimization
Workflow
- Analyze performance using EXPLAIN
- Design indexes based on workload
- Optimize queries and refresh statistics
- Setup and monitor replication
- Monitor and maintain database health
Practices
- Database Administration
- Performance Tuning
- Query Optimization
- Replication Strategy
Maintenance
- warning:Commit recencyThe last commit was 13 days ago, which is recent. However, trust signals indicate pushedAt was 2026-05-01, which is in the future. Assuming current date is 2026-05-13, this is very recent. There are no commits in the last 90 days according to the provided data.
Installation
First, add the marketplace
/plugin marketplace add jeffallan/claude-skills/plugin install claude-skills@fullstack-dev-skillsQuality Score
Similar Extensions
Sql Optimization
100Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.
Dsql
100Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
Azure Postgres Ts
100Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package. Use for PostgreSQL queries, connection pooling, transactions, and Microsoft Entra ID (passwordless) authentication. Triggers: "PostgreSQL", "postgres", "pg client", "node-postgres", "Azure PostgreSQL connection", "PostgreSQL TypeScript", "pg Pool", "passwordless postgres".
MongoDB Connection Optimizer
100Optimize MongoDB client connection configuration (pools, timeouts, patterns) for any supported driver language. Use this skill when working/updating/reviewing on functions that instantiate or configure a MongoDB client (eg, when calling `connect()`), configuring connection pools, troubleshooting connection errors (ECONNREFUSED, timeouts, pool exhaustion), optimizing performance issues related to connections. This includes scenarios like building serverless functions with MongoDB, creating API endpoints that use MongoDB, optimizing high-traffic MongoDB applications, creating long-running tasks and concurrency, or debugging connection-related failures.
DBHub Database Query Guide
100Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.