PlugWiki

postgresql-optimization Skill: PostgreSQL-Specific Features and Tuning

Gives your agent PostgreSQL-specific know-how: JSONB, arrays, full-text search, indexes, window functions and query tuning.

Installs
16.6K
on skills.sh
Stars
40.7K
on GitHub
Updated
Oct 2026
last repo commit

The skill is one long SKILL.md of SQL examples with no scripts. It covers PostgreSQL features (JSONB with GIN indexes, arrays, full-text search, custom and range types), performance tuning with EXPLAIN ANALYZE and pg_stat_statements, index strategy, extensions, and maintenance queries.

It ends with an optimization checklist and a fixed report format: original query, issues found, optimized query, recommended indexes and expected impact. It is written for GitHub Copilot, so it opens with a ${selection} placeholder that other agents will not fill in. The examples create extensions and tables, so run them on a test database first.

Good for

  • Developers writing or tuning PostgreSQL queries
  • Teams using JSONB, arrays or full-text search
  • Anyone reviewing a slow query plan

Install postgresql-optimization

Claude Code

  1. 1

    Copy this prompt.

    Install the postgresql-optimization skill in Claude Code. Run this command:

npx skills add https://github.com/github/awesome-copilot --skill postgresql-optimization

Then check that it loaded and tell me how to use it.
  2. 2

    Paste it into Claude Code. It shows the change and asks before running it.

Requires Node.js.

From its listing on skills.sh. Source.

What's in the skill

When it loads

PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and PostgreSQL extensions ecosystem.

Sections in SKILL.md

  1. � PostgreSQL-Specific Features
  2. JSONB Operations
  3. Array Operations
  4. Window Functions & Analytics
  5. Full-Text Search
  6. � PostgreSQL Performance Tuning
  7. Query Optimization
  8. Index Strategies
  9. Connection & Memory Management
  10. �️ PostgreSQL Advanced Data Types
  11. Custom Types & Domains
  12. Range Types
  13. Geometric Types
  14. 📊 PostgreSQL Extensions & Tools
  15. Useful Extensions
  16. Monitoring & Maintenance

Key facts

Author
github
Installs on skills.sh
16,608 (Nov 2, 2026)
GitHub stars
40,666 (Nov 2, 2026), whole repo
Files
1 file including SKILL.md
Last commit
Oct 30, 2026 (repo)
Collection
Community-contributed skill in github/awesome-copilot; the README says to inspect third-party customizations before installing

What it includes

  • JSONB, arrays, window functions, full-text search

    SQL examples including GIN indexes and ts_rank.

    PostgreSQL-specific features

  • EXPLAIN ANALYZE, index strategy, connection and memory settings

    Uses pg_stat_statements and pg_settings views to find slow queries.

    Read · Performance tuning

  • Custom types, domains, range and geometric types

    Examples of each.

    Advanced data types

  • uuid-ossp, pgcrypto, unaccent, pg_trgm, btree_gin

    Examples run CREATE EXTENSION IF NOT EXISTS.

    Write · Extensions and tools

  • Size, index usage and query stats

    Queries on pg_stat_user_indexes and database size views; notes VACUUM and ANALYZE.

    Read · Monitoring and maintenance

  • Query analysis, indexes, security, monitoring

    Four checklists.

    Optimization checklist

  • Fixed report structure

    Original query, issues, optimized query, recommended indexes, expected impact.

    Output format

From the official docs

Permissions

Low risk

What it can do

  • Read your data
  • Create and change things
  • Delete things
  • Read-only mode

Watch out for

  • Examples change a database

    They include CREATE EXTENSION, CREATE INDEX, UPDATE and notes on VACUUM and ANALYZE. Run them on a test database first. The awesome-copilot README says its customizations come from third-party developers and should be inspected before installing. github.com

Questions

What does the postgresql-optimization skill do?

It gives your agent PostgreSQL-specific guidance and a fixed way to report query tuning. The focus is PostgreSQL-only features such as JSONB and GIN indexes, not generic SQL.

How do I install it?

Use the install box above. It is a single SKILL.md with no scripts or references. The awesome-copilot README also documents copilot plugin install <plugin-name>@awesome-copilot for plugins in Copilot CLI.

What is the ${selection} text at the top?

The SKILL.md opens with "Expert PostgreSQL guidance for ${selection} (or entire project if no selection)". The file does not say which agents fill that in, so name the query or file in your prompt.

Does it connect to my database?

SKILL.md names no connection step and the folder bundles no scripts. The agent works from the SQL you give it, or from commands you approve.

Is it safe?

The skill is text with SQL examples. Examples such as CREATE EXTENSION, CREATE INDEX and UPDATE change a database, so run them on a test copy before production.

Does it work in Claude Code, Codex or Cursor?

The SKILL.md is plain Markdown with SQL examples. The awesome-copilot README documents plugin installs for GitHub Copilot CLI and VS Code (copilot plugin install <plugin-name>@awesome-copilot) and names no other client for individual skills. Use the install box above for the skills CLI route.

Information

updated Nov 2, 2026

Repository
github/awesome-copilot
Folder
skills/postgresql-optimization

github/awesome-copilotskills.sh

Sources

Docs, issue trackers and discussions this page is built from.

Show all 2
  1. postgresql-optimization SKILL.md · github.com
  2. awesome-copilot README · github.com

Updated Nov 2, 2026.