postgresql-query-optimization-explain
/postgresql-query-optimization-explain
Use this skill when inspecting query plans, identifying sequential table scans, and tuning PostgreSQL execution costs with EXPLAIN ANALYZE.
- Author
- nextboxis ↗
- Repository
- library-skill-agents ↗
- Licence
- MIT
- Last repository change
- 28.10.2026
Assessment and security
- Files in this package
- 1
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 28.10.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
Use this skill when inspecting query plans, identifying sequential table scans, and tuning PostgreSQL execution costs with EXPLAIN ANALYZE.
Original author description
Use this skill when inspecting query plans, identifying sequential table scans, and tuning PostgreSQL execution costs with EXPLAIN ANALYZE.
How it works
- When to use
- Prerequisites
- Step-by-step workflow
- Commands / code examples
- Common mistakes & pitfalls
- Verification checklist
- Related skills
SKILL.md preview
--- name: postgresql-query-optimization-explain description: Use this skill when inspecting query plans, identifying sequential table scans, and tuning PostgreSQL execution costs with EXPLAIN ANALYZE. --- # PostgreSQL Query Optimization & EXPLAIN ANALYZE ## When to use Use this skill when you need to inspecting query plans, identifying sequential table scans, and tuning PostgreSQL execution costs with EXPLAIN ANALYZE. ## Prerequisites - Working knowledge of relevant programming language or database fundamentals. - Access to testing environment or local runtime instance. ## Step-by-step workflow 1. **Analyze operational requirements**: Review performance boundaries, data integrity constraints, and query patterns. 2. **Design schema / interface**: Define explicit data contracts, types, or indexes supporting planned operations. 3. **Implement core routines**: Construct declarative, type-safe, or parameterized queries and functions. 4. **Validate performance**: Verify execution metrics using profilers, EXPLAIN plans, or benchmark test suites. 5. **Implement defensive controls**: Enforce timeout boundaries, connection pooling limits, and transaction safety. ## Commands / code examples ```sql -- Production query and schema pattern for postgresql-query-optimization-explain BEGIN; SELECT 1; COMMIT; ``` ## Common mistakes & pitfalls - Overlooking indexing strategies on foreign keys and frequently queried filter columns. - Running unparameterized dynamic queries, creating severe SQL injection vulnerabilities. - Holding open long-running database transactions during slow external network calls. ## Verification checklist - [ ] Schema contracts and type signatures are strictly enforced. - [ ] Queries are fully parameterized against injection vulnerabilities. - [ ] Profiling or execution plans show optimal resource consumption. - [ ] Error handling safely releases locks and rolls back aborted transactions. ## Related skills - postgresql-query-optimization-explain - sql-anti-patterns-remediation - acid-transactions-isolation-levels - secure-code-review-static-analysis-sast
Versions
The database has no other skills named postgresql-query-optimization-explain.
Database snapshot: 13.11.2026 · package version 0449090e8299 (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 100postgresql-optimization
Expert in PostgreSQL performance tuning, query optimization, and database administration. Specializes in EXPLAIN analysis, indexing strategies, connection pooling, partitioning, and production-grade PostgreSQL operations. Use when the user explicitly needs postgresql… - 90postgresql
PostgreSQL schema design, query optimization, indexing, and administration. Use when working with PostgreSQL, JSONB, partitioning, RLS, CTEs, window functions, or EXPLAIN ANALYZE. - 100sql-insight
Translate natural language to SQL, optimize query performance, and interpret EXPLAIN plans for SQLite and PostgreSQL. Triggered when users ask to convert questions into SQL, improve slow queries, tune indexes, analyze execution plans, or mention keywords like NL2SQL, query… - 100postgres
Use when user references PostgreSQL/Postgres, postgres:// or postgresql:// connection strings, asks for ad-hoc SELECT, EXPLAIN/ANALYZE plans, schema/index/lock inspection, or slow-query investigation. Read-only by default. Multi-database via PG_PROFILE. - 100query-optimization
Diagnose and optimize existing slow SQL queries using execution plans, indexing strategies, query rewriting, and ORM tuning. Use when the user provides a query, performance symptom, or EXPLAIN plan; use sql-query-generation when creating a new query from requirements. - 100postgresql
Expert PostgreSQL assistance covering advanced SQL, JSONB, indexing (B-Tree, GIN, BRIN), query optimization with EXPLAIN ANALYZE, and replication. Use when designing robust relational schemas or tuning performance.