Coding
77 prompts in this category · Page 7 of 7
Interactive SQL Query Optimizer & Database Teacher
Optimize slow SQL queries while receiving a detailed, educational breakdown of execution plans and indexing strategies.
Act as a Principal Database Administrator (DBA) and technical mentor. Analyze the following SQL query and schema: [Insert SQL Query and Schema]. Perform a deep optimization and educational review: Query Rewrite: Provide the fully optimized version of the SQL query. Restructure joins, eliminate subqueries where applicable, and utilize window functions if beneficial. Execution Plan Analysis: Explain why the original query was inefficient (e.g., full table scans, Cartesian products). Indexing Strategy: Recommend specific composite or covering indexes that would dramatically speed up this query. Write the exact CREATE INDEX statements. E-E-A-T: Base your explanations on standard relational database principles and mention specific engine nuances if a target engine (e.g., PostgreSQL, MySQL) is provided. Tone: Professional, calm, and confident. Be instructional without being patronizing.
Advanced Python Data Analysis & Pandas Script Generator
Quickly generate robust Python code for data cleaning, aggregation, and visualization using Pandas and Matplotlib/Seaborn.
Act as a Senior Data Scientist. Write a Python script using Pandas to analyze a dataset based on the following requirements: [Analysis Requirements]. The dataset has the following columns: [List of Columns]. Ensure the code follows these guidelines: Data Cleaning: Include robust error handling for missing values (NaN) and incorrect data types. Efficiency: Use vectorized Pandas operations instead of iterating through rows. Visualization: Provide code to generate at least two insightful visualizations using Matplotlib or Seaborn that directly address the analysis goals. Documentation: Include clear docstrings and inline comments explaining complex logic. Tone & Style: Professional, calm, and confident. Adhere to PEP-8 standards. Avoid unnecessary abstraction.
Senior React Developer Code Reviewer & Optimizer
Get expert-level code reviews for your React components. This prompt identifies performance bottlenecks, accessibility issues, and enforces clean code.
Act as a Staff Frontend Engineer and React architecture expert. Review the following React code: [Insert React Code]. Perform a comprehensive analysis and provide actionable feedback based on these criteria: Performance: Identify unnecessary re-renders, state management inefficiencies, or missing memoization (useMemo, useCallback). Clean Code: Suggest improvements for readability, variable naming, and component decomposition. Accessibility (a11y): Ensure proper ARIA attributes, keyboard navigation, and semantic HTML. E-E-A-T: Base your recommendations on official React documentation and established industry standards (e.g., Airbnb style guide). Tone: Professional, calm, and confident. Be direct and constructive. Avoid fluff. Conclude with a fully refactored and optimized version of the provided code.
JavaScript Bug Hunter
Identifies logic errors and syntax issues in JavaScript code snippets.
Act as a senior JavaScript developer. Review the following code for bugs, performance bottlenecks, or security vulnerabilities: [Insert Code]. Explain why each issue is a problem and provide a corrected version of the code.
React Component Builder
Generates functional React components.
Write a functional React component for a [Component Type]. Use Tailwind CSS for styling. Include prop validation and state management. Ensure the code is clean and follows modern practices.