AI Blocks › Build and ship software
Postgres performance tuner
Give it your queries or schema. Get Postgres fixes for speed, indexes and security, ranked by impact.
Postgres performance tuner is a free AI skill for the job "Build and ship software". Give the instructions to an AI assistant that supports the required files and tools, then review its output.
Free · No account · CC BY 4.0 licence · Made by sickn33 · Level: advanced
Made by sickn33. See the original on GitHub; we copied it as it is, with its licence.
What it does
Faster Postgres without guessing. Hand over your queries or schema and get a list of fixes ranked by how much each one helps. The rules come from Supabase and are grouped into eight areas in priority order: query speed, connections, security and row-level access, schema design, locking, data access patterns, monitoring and advanced features. The skill checks your SQL and table design against each area, starting with the changes that matter most, such as missing indexes and wasteful queries. Each finding says what to change and why. It suits anyone writing or reviewing Postgres, not only Supabase users.
You give it
- Slow queries or SQL files
- Table definitions
- Query plan output (optional)
- Traffic and data size notes (optional)
You get
- Fixes ranked by impact
- Index suggestions
- Connection and pooling advice
- Security and row-level rule checks
Use it when
- A page is slow and you suspect one database query.
- You are about to ship a new schema and want a review.
- Your app runs out of database connections under load.
- You use row-level security and want to check it is safe and quick.
How to use it
- Add it to your AI once: download it and add the folder to Claude, ChatGPT or Codex as a skill.
- Ask for the job in your own words. Your AI opens the skill when it fits.
- It works best when your AI can read your project files.