PostgreSQL Pro
技能 活跃Use 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.
功能
- 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
使用场景
- 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
非目标
- Replacing the database administrator directly
- Automating all database changes without user intervention
- Providing generic SQL commands unrelated to PostgreSQL optimization
工作流
- Analyze performance using EXPLAIN
- Design indexes based on workload
- Optimize queries and refresh statistics
- Setup and monitor replication
- Monitor and maintain database health
实践
- 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.
安装
请先添加 Marketplace
/plugin marketplace add jeffallan/claude-skills/plugin install claude-skills@fullstack-dev-skills质量评分
类似扩展
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
100为任何支持的驱动程序语言优化 MongoDB 客户端连接配置（池、超时、模式）。在处理/更新/审查实例化或配置 MongoDB 客户端（例如，调用 `connect()` 时）、配置连接池、对连接错误（ECONNREFUSED、超时、池耗尽）进行故障排除、优化与连接相关的性能问题时，请使用此技能。这包括构建具有 MongoDB 的无服务器函数、创建使用 MongoDB 的 API 端点、优化高流量 MongoDB 应用程序、创建长期运行任务和并发性，或调试与连接相关的失败等场景。
DBHub Database Query Guide
100DBHub MCP 服务器查询数据库指南。每当您需要通过 DBHub 的 MCP 工具（search_objects、execute_sql）来探索数据库模式、检查表或运行 SQL 查询时，请使用此技能。在任何数据库查询任务、模式探索、数据检索或通过 MCP 执行 SQL 时激活，即使用户只说“检查数据库”或“为我查找一些数据”。此技能可确保您遵循正确的先探索后查询的工作流程，而不是猜测表结构。