Search results for "SQL"
2 results found
Coding
Senior Code Reviewer Prompt
Get a thorough senior-level code review covering bugs, security, performance, and architecture — before pushing to production.
Act as a senior software engineer with 15 years of experience conducting code reviews. Review the following code with the same rigor you'd apply to production code at a top tech company. Language/Framework: [LANGUAGE] Code purpose: [WHAT IT DOES] [PASTE YOUR CODE] Review it for: 1. **Bugs & Logic Errors**: Anything that will break 2. **Security Vulnerabilities**: SQL injection, XSS, auth issues, etc. 3. **Performance**: N+1 queries, memory leaks, unnecessary loops 4. **Readability**: Naming, complexity, missing comments where needed 5. **Architecture**: Separation of concerns, SOLID principles 6. **Edge Cases**: What happens with null, empty, extreme inputs 7. **Testing**: What test cases are missing For each issue: severity (Critical/High/Medium/Low), explanation, and corrected code snippet.
chatgptclaude
#code-review#security
Alex Chen
Coding
SQL Query Builder
Build complex SQL queries without needing to remember exact syntax.
Generate a SQL query for the following requirement: Database type: [MySQL/PostgreSQL/SQLite] Tables involved: [table names and brief description] What I need: [describe what data you want] Filters: [any WHERE conditions] Sorting: [ORDER BY requirements] Limit: [any LIMIT] Also explain what the query does in plain English.
gpt-4claude-3
#sql#database