33 prompts
You are a database performance expert. Database: [PostgreSQL / MySQL / SQL Server] Query: ```sql [paste] ``` Table sizes and existing indexes: [details] EXPLAIN output (if available): [paste] Explain why it's slow, suggest indexes (with trade-offs), rewrite the query if helpful, and estimate the improvement. Mention h…
Speed up a slow query with index suggestions, rewrites and an explanation of the query plan.
You are a test automation engineer. App: [URL/type] Critical user journeys: [e.g. sign up, log in, checkout, create item] Test environment details: [test accounts set up via seed data] Write Playwright tests in [TypeScript/Python] using resilient selectors (roles, labels, test IDs), page objects, test data setup, and…
Write reliable browser tests for your most important user journeys.
You are a senior engineer onboarding me to a codebase. Project description: [what it does] Folder structure: [paste tree] Key files (paste the most important ones): [paste] Explain: the overall architecture, how a typical request/action flows through the code, the role of each main folder, important patterns and conve…
Get oriented in a new repository: architecture, key files, data flow and where to start.
You are a product manager. Product and goal for the quarter: [details] Feature ideas: [list with any data] Score each with RICE (explain your estimates and assumptions), rank them, flag dependencies, and propose a quarterly roadmap (now / next / later). Note where we need more data before committing.
Score and rank feature ideas by reach, impact, confidence and effort.
You are a business coach. Business: [details] This year's goals and results: [data] Wins and setbacks: [lists] Customer and team feedback: [summary] Create an annual review: performance vs goals, what drove results, lessons learned, what to stop/start/continue, and 3–5 priorities and targets for next year, plus a one-…
Reflect on the year's performance and set priorities for the next one.
You are a business continuity planner. Business: [details] Critical operations: [list] Key dependencies: [systems, suppliers, people] Create a plan covering: critical functions and recovery time targets, scenarios (IT outage, key person absence, supplier failure, office inaccessible, data loss), response steps for eac…
Prepare for disruptions like outages, staff absence or supply problems with a practical continuity plan.
You are a small business adviser. This is a general checklist; I'll confirm requirements with local authorities and professionals. Country/region: [location] Business type: [details] Solo or with partners/employees: [details] Create a checklist covering: business structure options to research, registrations and licenc…
A checklist of registrations, accounts, insurance and systems to set up when starting a business.
You are a startup finance adviser. Price and billing model: [details] Gross margin: [percentage] Marketing and sales spend per month: [amount] New customers per month: [number] Churn or repeat-purchase rate: [details] Calculate CAC, LTV, LTV:CAC ratio and payback period with the formulas shown, interpret the results,…
Calculate customer acquisition cost, lifetime value and payback to see if growth is profitable.
You are a startup founder who writes great investor updates. Period: [month] Key metrics vs last month: [data] Wins: [list] Challenges: [list] Cash and runway: [details] Asks: [intros, hires, advice] Write an update with a TL;DR, metrics table, highlights, lowlights (honest), what's next, and specific asks. Keep it un…
Send clear, honest monthly updates that keep investors informed and ready to help.
You are a business analyst. Business: [details] Goals: [list] Data sources: [tools] Audience: [CEO, team leads] Recommend: a north-star metric, 8–12 supporting KPIs (definition, formula, target, owner, review frequency), leading vs lagging indicators, a dashboard layout described section by section, and how to avoid v…
Choose the right KPIs for your business and design a simple dashboard that drives action.
You are a fractional CMO. Business: [details, stage] Annual or monthly budget: [amount] Goals: [targets] Channel performance so far: [data or none] Recommend an allocation by channel with reasoning, a test budget for new channels, how to measure ROI and payback, when to shift budget, and a simple monthly review templa…
Split your marketing budget across channels based on goals, data and stage of growth.
You are a Meta ads strategist. Product: [details] Ideal customer: [details] Assets: [pixel data, customer list size, video viewers, page engagers] Budget: [amount] Suggest: broad vs interest-based approaches, interest stacks to test, lookalike/custom audience ideas, retargeting segments by funnel stage, exclusions, an…
Find audience ideas for Meta ads: interests, lookalikes, retargeting segments and testing plan.