Data
PromptBeginner5 minmarkdown
- [ ] Identify missing database query optimization (missing indexes
full table scans)
0
Explore
Find agent skills by outcome
59,471 skills indexed with the new KISS metadata standard.
Showing 24 of 59,471Categories: General, Coding & Debugging, Openclaw, Cursor-rules, Data
General
PromptBeginner5 minmarkdown
- [ ] Identify missing connection pooling (`requests.Session`
`aiohttp.ClientSession`)
0
Coding & Debugging
PromptBeginner5 minmarkdown
- [ ] Detect `*args
**kwargs` passthrough that hides actual API
0
General
PromptBeginner5 minmarkdown
- [ ] Detect missing security headers (CSP
HSTS
0
General
PromptBeginner5 minmarkdown
- [ ] Find dependencies installed from non-PyPI sources (git URLs
local paths)
0
General
PromptBeginner5 minmarkdown
- [ ] Check for proper cookie flags (`secure`
`httponly`
0
General
PromptBeginner5 minmarkdown
- [ ] Check for `requests.get(url
verify=False)` — disables TLS verification
0
General
PromptBeginner5 minmarkdown
- [ ] Identify missing CSRF protection (Django `@csrf_exempt` overuse
Flask-WTF missing)
0
General
PromptBeginner5 minmarkdown
- [ ] Identify weak hash algorithms (`md5`
`sha1`) for security operations
0
Coding & Debugging
PromptBeginner5 minmarkdown
- [ ] Find hardcoded credentials
API keys
0
General
PromptBeginner5 minmarkdown
- [ ] Check for proper password hashing (`bcrypt`
`argon2` — NOT `hashlib.md5/sha256`)
0
General
PromptBeginner5 minmarkdown
- [ ] Find JWT implementation flaws (algorithm confusion
missing expiry validation)
0
General
PromptBeginner5 minmarkdown
- [ ] Find caches (`dict`
`lru_cache`) without size limits — unbounded memory growth
0
General
PromptBeginner5 minmarkdown
- [ ] Detect file permissions too permissive (`os.chmod(path
0o777)`)
0
General
PromptBeginner5 minmarkdown
- [ ] Identify missing file encoding specification (`open(f
encoding=utf-8)`)
0
General
PromptBeginner5 minmarkdown
- [ ] Find blocking calls inside `async` functions (`time.sleep`
sync I/O
0
Coding & Debugging
PromptBeginner5 minmarkdown
- [ ] Identify GIL assumptions for thread safety (only protects Python bytecode
not C extensions)
0
General
PromptBeginner5 minmarkdown
- [ ] Find resource acquisition without `with` statement (files
locks
0
General
PromptBeginner5 minmarkdown
- [ ] Find `except` blocks that catch too broadly (`except (Exception
BaseException):`)
0
General
PromptBeginner5 minmarkdown
- [ ] Find bare `except:` clauses — catches `SystemExit`
`KeyboardInterrupt`
0
General
PromptBeginner5 minmarkdown
- [ ] Identify `dict`
`list`
0
General
PromptBeginner5 minmarkdown
After completing the review
provide:
0
Coding & Debugging
PromptBeginner5 minmarkdown
You are an expert Python code reviewer with 20+ years of experience in enterprise software development
security auditing
0
Coding & Debugging
PromptBeginner5 minmarkdown
Comprehensive Python Codebase Review - Forensic-Level Analysis Prompt
# COMPREHENSIVE PYTHON CODEBASE REVIEW
0