55 Production-Ready Claude Prompts for Engineers

Antonio Marasco — Wed, 15 Jul 2026 20:55:14 +0000

I've been using Claude in production for a while, and I kept noticing the same thing: I was re-deriving the same prompts across every project. Code review, SQL optimization, IAM policies, refactoring, the same patterns, over and over.

So I organized the 55 I actually reach for. Here's what's in them, plus 7 you can grab free.

7 free prompts (no signup)

Before the pitch, here are 7 of them, free, on GitHub:
https://gist.github.com/razorphish/5469109bbe6f20a49280c5b5002d1a5a

They cover SQL optimization, async refactoring, API validation, React, Python ETL, IAM policies, and microservice design. Copy, paste your context into the brackets, iterate.

What the full set covers

Code review & architecture (15): e.g. "Review this PR for security issues, edge cases, and performance." Great for async review; catches things a first human pass misses.
Security & compliance (10): e.g. "Threat-model this system from an attacker's perspective." Maps to the OWASP Top 10.
Testing & DevOps (10): integration test generation, CI/CD, failure-scenario planning.
AI & agentic loops (5): multi-agent designs, tool binding, function definitions.
Data & analytics (5): e.g. "Optimize this SQL query for a 100M-row table."
Other specialized (10): the rest I use regularly.

Why package them?

Most engineers rediscover the same ~50 prompts independently.
One good prompt saves 2 to 4 hours. The time-to-value is lopsided.
These are tested in production, not theoretical.

Each prompt in the full set includes the full text, a real example input, a production-ready example output, and notes on adapting it to your project, so you see how it behaves before you run it.

A free sample prompt

"Audit this Python code for security vulnerabilities. List issues by severity (critical, high, medium) and suggest a fix for each."

Paste your code after it; Claude returns issues and fixes ordered by severity.

Get them

7 free (no signup): https://gist.github.com/razorphish/5469109bbe6f20a49280c5b5002d1a5a
Full set of 55 (each with a worked example + real output): https://2797536849428.gumroad.com/l/vxetvk , $49, one-time.

Questions? Ask in the comments, happy to explain any prompt or use case. And I'm curious: which prompts do you keep re-writing?

The Claude prompt I use to optimize slow SQL queries

Antonio Marasco — Wed, 15 Jul 2026 18:50:37 +0000

Here's the single Claude prompt I reach for most when a query is dragging.

Optimize a slow SQL query

Analyze and optimize this slow SQL query:
[paste query]

Context:
- Table size: [rows]
- Query frequency: [per second/minute]
- Current performance: [ms]  ->  Target: [ms]

Suggest indexes, rewrites, and explain the trade-offs (read speed vs. write cost).
Show EXPLAIN reasoning: what scans it eliminates.

Use it when a query is slow and you are not sure whether the fix is an index, a rewrite, or a schema change. Asking for the EXPLAIN reasoning and the read-vs-write trade-off is what turns a generic answer into one you can actually ship.

This is one of 55 prompts I use in production. 7 are free, no signup: https://gist.github.com/razorphish/5469109bbe6f20a49280c5b5002d1a5a

The full set (each with a worked example input and a real output) is here: https://2797536849428.gumroad.com/l/vxetvk

What prompt do you reach for most? I am curious whether the "worked example + output" format beats a bare prompt list.

DEV Community: Antonio Marasco