Lightlines
By github

postgresql-optimization

github16k installs

Faster PostgreSQL queries with targeted fixes.

What it does

Recommends PostgreSQL optimizations to improve query performance, security, and maintainability.

When to use it

Use for PostgreSQL-specific guidance on selected code or an entire project.

How to use it

Give it selected SQL or a project; it returns query analysis, optimized SQL, and recommended indexes.

What you provide

  • An existing project

Uses

Good to know

  • cannot be undone: PostgreSQL

Latest review

What you need · 2

An accessible PostgreSQL database is needed to run the instructed query analysis.

The instructed query-performance monitoring uses pg_stat_statements.


Access · 1

This skill

PostgreSQL

Write

Removes unused database indexes (irreversible)