All skills
postgres-pro
Diagnose slow PostgreSQL queries with EXPLAIN and deliver verified index and query fixes.
- Part of Jeffallan/claude-skills
- 8.4k installs
- Developer Tools · Backend
When to use it
You have a slow query or high dead-tuple table and need concrete EXPLAIN analysis, index design, or VACUUM tuning.
For example
You say
Use postgres-pro to fix this slow query: SELECT * FROM orders WHERE customer_id = 42 AND status = 'pending' takes 3 seconds on a 10M-row table.
You get
- EXPLAIN ANALYZE interpretation
- Partial index definition
- Before/after verification
How it works
- Recommends CREATE INDEX CONCURRENTLY to avoid locking production tables.
- Covers JSONB GIN indexing, replication lag checks, and autovacuum tuning.
More Backend skills
See all- lark-shared497kHandles Lark CLI login, identity, permissions and authorization status.
- lark-event489kStreams Lark real-time events like messages, approvals and meetings for bots and subscribers.
- cuopt-routing-api-python2.3kBuilds and solves vehicle routing, traveling salesman, and pickup-delivery problems in Python with cuOpt.
- cuopt-server-api-python2.2kStarts the cuOpt REST server and calls its endpoints from Python or curl.
Also in this pack
- golang-pro19.8kWrites concurrent Go services with goroutines, channels, gRPC or REST, and profiles performance.
- php-pro16.4kBuilds modern PHP applications with strict typing, Laravel or Symfony, tests and REST or GraphQL APIs.
- typescript-pro15kBuilds advanced TypeScript types and end-to-end type-safe APIs with tRPC.
- flutter-expert14.9kBuilds cross-platform Flutter apps with widgets, Riverpod or Bloc state, navigation and performance tuning.