Postgres Pro
Jeffallan/claude-skillsUse when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
At a glance
This skill is for Data & Analytics and helps you optimize postgresql queries, analyze query performance with explain, and configure database replication.
/plugin marketplace add Jeffallan/claude-skills
/plugin install postgres-pro
Setup, runtime and requirements describe Jeffallan/claude-skills, the repo this skill ships in.
postgresqlDatabase OptimizationQuery TuningReplicationPerformance Monitoringextensions
Also in Jeffallan/claude-skills
View the repoGenerates Angular 17+ standalone components, configures advanced routing with lazy loading and guards, implements NgRx state management, app...
Use when designing REST or GraphQL APIs, creating OpenAPI specifications, or planning API architecture. Invoke for resource modeling, versio...
Use when designing new high-level system architecture, reviewing existing designs, or making architectural decisions. Invoke to create archi...
Integrates with Atlassian products to manage project tracking and documentation via MCP protocol. Use when querying Jira issues with JQL fil...
Designs chaos experiments, creates failure injection frameworks, and facilitates game day exercises for distributed systems — producing runb...
Use when building CLI tools, implementing argument parsing, or adding interactive prompts. Invoke for parsing flags and subcommands, display...
Designs cloud architectures, creates migration plans, generates cost optimization recommendations, and produces disaster recovery strategies...
Generates, formats, and validates technical documentation — including docstrings, OpenAPI/Swagger specs, JSDoc annotations, doc portals, and...
Analyzes code diffs and files to identify bugs, security vulnerabilities (SQL injection, XSS, insecure deserialization), code smells, N+1 qu...
Writes, optimizes, and debugs C++ applications using modern C++20/23 features, template metaprogramming, and high-performance systems techni...
Use when building C# applications with .NET 8+, ASP.NET Core APIs, or Blazor web apps. Builds REST APIs using minimal or controller-based ro...
Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing exec...
Other Data & Analytics skills
An engineering runbook — service overview, alerts table, dashboards links, common procedures with copy-pasteable commands, on-call rotation,...
Professional trading analysis dashboard template (single-file HTML) with light/dark theme switch, dense market panels, chart interactions, d...
A consumer-feeling dating / matchmaking dashboard — left rail navigation, ticker bar of community signals, headline KPIs, a 30-day mutual-ma...
Teaches the agent to produce D3 charts and interactive data visualizations. A comprehensive D3.js skill with examples across chart types and...
Notion-style team dashboard rendered as a Live Artifact. A single-page, self-contained HTML dashboard with KPIs, a 7-day sparkline, a real-t...
Admin / analytics dashboard in a single HTML file. Fixed left sidebar, top bar with user/search, main grid of KPI cards and one or two chart...