Pack 323 · Developer stacks · 13 items
PostgreSQL Database Pack
10 prompts + 3 skills for postgreSQL developers and DBAs — real jobs from the week, with the steps, rules and output an expert would ask for. 7 written for this work, 6 more from the library.
€4one-time · 13 prompts & skills · ≈ €0.31 each
- Instant download
- Yours to keep
- Works in ChatGPT, Claude, Gemini
What's inside
Made for postgreSQL developers and DBAs
6 prompts + 1 skill- PromptPostgreSQL Slow Query — EXPLAIN ANALYZE Walkthrough and Fix
Reads an EXPLAIN ANALYZE plan line by line, finds where the time goes — bad estimates, sequential scans, sorts spilling to disk, nested loops — and proposes indexes or rewrites.
- PromptPostgreSQL Schema Design Review for a New Feature
Reviews or designs tables for a new feature — keys, types, constraints, relationships, indexes and growth — so data stays correct and queries stay fast as it scales.
- PromptPostgreSQL Zero-Downtime Migration Plan
Plans a risky schema change on a busy table — adding columns, backfilling, changing types, adding constraints or indexes — as safe, reversible steps that don't lock production.
- PromptPostgreSQL Row-Level Security Policies for a Multi-Tenant App
Designs row-level security policies so the database itself enforces tenant and user isolation — with policies per operation, performance-friendly predicates and tests for leaks.
- PromptPostgreSQL Backup, Restore and Recovery Drill Plan
Writes the backup strategy and a tested restore runbook — point-in-time recovery, retention, encryption and a quarterly drill — so recovering from a bad migration or deletion is routine.
- PromptReporting Query With Window Functions — Cohorts, Running Totals, Rankings
Writes correct, readable reporting SQL for questions like retention cohorts, running totals, rankings within groups and period-over-period change — with CTEs and checks on the numbers.
- SkillPostgreSQL Database Engineer
A standing PostgreSQL engineer: schema design, query plans, indexes, safe migrations, row-level security, backups and reporting SQL — evidence-based and production-safe.
Bonus prompts & skills
4 prompts + 2 skills · free with the packFrom the wider PromptCorrectly library, picked for the same work. They come in the same .zip and the start file tells your AI when to use each one.
- SkillExploratory Data Analysis Strategist
Produces a structured EDA plan and narrative findings for any new dataset before modeling.
Library · Free account - SkillOperational Dashboard & Metric Selector
Selects the few metrics worth tracking for an operation and designs a dashboard that drives action, not vanity.
Library · In a pack - PromptSQL → English Explainer
Translate any SQL query into bullets that an analyst can act on.
Library · Free - PromptTranslate Business Questions Into SQL
Turns a plain-English stakeholder question into a correct, well-commented SQL query against a known schema.
Library · Free - PromptRoot-Cause A Metric Spike Or Drop
Drives a systematic decomposition to explain why a metric moved, with SQL to test each hypothesis.
Library · In a pack - PromptData Quality Monitoring Dashboard Spec
Specifies a data-quality dashboard tracking freshness, completeness, validity, and anomaly checks per pipeline.
Library · In a pack
What you download
Everything comes in one pack (.zip) you keep. Start with 00-GIVE-THIS-TO-YOUR-AI.md: paste it into your AI and it knows which file to use for which job, and what to ask you first.
More for Developers · Data Analysis & Excel
postgresql-database/ ├─ 00-GIVE-THIS-TO-YOUR-AI.md ├─ START-HERE.md ├─ TIPS-AND-FOLLOW-UPS.md ├─ AI-CHEAT-SHEET.md ├─ prompts/ │ ├─ 01-postgres-slow-query-explain-analyze-walkthrough.md │ ├─ 02-postgres-schema-design-review-for-new-feature.md │ ├─ 03-postgres-zero-downtime-migration-plan.md │ ├─ 04-postgres-row-level-security-policy-design.md │ ├─ 05-postgres-backup-restore-and-recovery-drill.md │ ├─ 06-sql-reporting-query-with-window-functions.md │ ├─ 07-flagship-sql-to-english.md │ ├─ 08-translate-business-questions-into-sql.md │ ├─ 09-root-cause-a-metric-spike-or-drop.md │ └─ 10-data-quality-monitoring-dashboard-spec.md └─ skills/ ├─ postgres-database-engineer/SKILL.md ├─ exploratory-data-analysis-strategist/SKILL.md └─ operational-dashboard-metric-selector/SKILL.md
A look inside
ROLE: You are a PostgreSQL performance consultant. You read query plans from the inside out, compare estimated and actual rows at every node, and fix the cause — usually statistics, an index or the query shape — rather than tuning server settings first. CONTEXT: The slow query: [QUERY]. EXPLAIN …
Questions
What do I get?
A .zip with 10 prompts + 3 skills: 6 prompts + 1 skill written for postgreSQL developers and DBAs, plus 4 prompts + 2 skills from the wider library that fit the same work. Each prompt is a ready .md file, each skill a SKILL.md folder, plus 00-GIVE-THIS-TO-YOUR-AI.md (a start file your AI reads first), START-HERE.md, TIPS-AND-FOLLOW-UPS.md (tips and the follow-up questions for every file) and the free AI cheat sheet.
How do I use it?
Open ChatGPT, Claude or Gemini and paste 00-GIVE-THIS-TO-YOUR-AI.md, or attach the folder. It asks a few questions about your work once, then picks the right file for each job and fills in the blanks.
Is it a subscription?
No. €4 once, and the files are yours to keep. Nothing renews.
How do I download it?
Right after checkout, on the confirmation page. Sign in later with the email you paid with and the download button waits for you on this page.
Why this price?
A pack is priced by the items written for its trade: €0.50 a prompt and €1 a skill. The 6 bonus items come free on top. This one is €4 for 13 prompts and skills, about €0.31 an item.