93 prompts
Set up a [Supabase/Firebase] backend for [app]. Include the data model, authentication, row-level security or security rules so users only access their own data, example queries from the client, and storage for user uploads.
Sets up auth, database and security rules for a small app.
Outline and code a simple RAG prototype in Python that answers questions from [documents]. Cover loading and chunking documents, creating embeddings, storing them in [vector store], retrieving relevant chunks, building the prompt, and citing sources in answers.
Answers questions from your own documents using embeddings.
Write a system prompt and code in [language] that makes an LLM extract [fields] from [input type] as valid JSON matching this schema: [schema]. Include validation, a retry if parsing fails, and handling for missing data.
Reliably gets valid JSON from an AI model in your app.
Explain [data structure, e.g. a hash map / heap / trie] for a [level] developer. Include a text diagram, how operations work with time complexity, a clean implementation in [language], and when to use it in real projects.
Explains a data structure with visuals and an implementation.
Review and rewrite this page's HTML for SEO and accessibility: semantic elements, heading order, meta title and description, Open Graph tags, canonical link, structured data for [type], and image alt text. HTML: [paste HTML]
Semantic HTML and meta tags that help search engines.
Implement [infinite scroll / cursor pagination] for a list of [items] in [framework] calling [API]. Handle loading and error states, avoid duplicate requests, preserve scroll position, and include the backend query for cursor pagination.
Review this PostgreSQL schema. Check normalisation, data types, constraints, foreign keys, indexes for likely queries ([queries]), naming consistency, and future scaling issues. Suggest improvements with migration SQL. Schema: [paste schema]
Reviews a database schema for performance and integrity issues.
I want to build [app idea] for [users]. Suggest a simple tech stack for a solo developer, the core MVP features, a data model, main pages/screens, API endpoints, auth approach, hosting, and a 4-week build plan. Flag what to leave out of the MVP.
Turns an app idea into an MVP plan with stack, data model and milestones.
Analyze this data and tell me what decisions it supports. Summarise the key trends, anomalies, and comparisons, then give 3 recommended actions with the evidence for each and what additional data would increase confidence. Data: [paste data]
Turns a data export into insights and recommended decisions.
Analyze this churn data and cancellation reasons. Identify the top reasons customers leave, which segments churn most, early warning signals, and 5 retention actions ranked by impact. Data: [paste data]
Finds patterns in why customers leave and what to do.
Outline a quarterly business review presentation for [client]. Include goals recap, results with metrics [data], wins, challenges and how we addressed them, insights and recommendations, next-quarter plan, and asks from the client.
A client QBR outline that shows value and plans next steps.
Review this Google Ads search terms report for a campaign selling [product]. Identify irrelevant terms to add as negatives, high-performing terms to add as exact match keywords, and themes for new ad groups. Present as tables. Report: [paste data]
Finds wasted spend and new keywords from a search terms report.