Create professional, comprehensive README.md files for software projects. Generates badges, installation instructions, usage examples, API references, and contributing guides tailored to the project type. Use when the user needs a README, wants to improve project documentation, or needs to write docs for a new repo.
Write optimized SQL queries for complex data requirements. Handle multi-table joins, aggregations, window functions, CTEs, subqueries, and performance optimization. Use when the user needs to write a SQL query, optimize a slow query, understand a query plan, design a schema, or work with database data.
Build Stripe payment integrations - one-time payments, subscriptions, marketplaces, and Connect platforms. Covers API selection (Checkout Sessions vs PaymentIntents vs Setup Intents), webhooks, restricted API keys, Stripe Connect (Accounts v2), billing, and security best practices. Use when accepting payments…
Write unit tests, integration tests, and end-to-end tests following best practices. Covers pytest, Jest, Go testing, and JUnit. Generates tests for functions, classes, REST endpoints, and database operations. Use when the user wants to write tests, increase test coverage, practice TDD, or add a test suite to existing…
Build complex, self-contained interactive web artifacts - rich HTML/CSS/JavaScript applications, React components with Tailwind CSS and shadcn/ui, data visualizations with D3.js or Chart.js, interactive tools, and games - all bundled into a single portable HTML file. Use when the user wants to create an interactive…
Scrape and extract structured content from websites. Handle pagination, dynamic JavaScript-rendered pages, rate limiting, and anti-bot measures. Use when the user needs to extract data from a website, scrape product listings, collect article text, or automate web data collection.
Create, edit, and analyze Excel spreadsheets (.xlsx, .xlsm, .csv, .tsv files). Covers building spreadsheets with openpyxl and pandas, writing Excel formulas, applying professional formatting and color conventions, creating charts, and validating formula correctness. Use when the user wants to create an Excel file…